-
Master detailed relationship
Can you apply the Master detailed relationship between Query studio report and report studio report? how?
vishal_9009
- Mar 17th, 2009
Master detailed relationship from query / Analysis studio report and Report Studio report can be created only with the use of Package level drill through.
simik
- Feb 24th, 2009
Master detail relationships link information between two data containers (such as list, crosstab, or chart) within a report: a master data container, and a detail data container.Using a master detail ...
-
Cognos Installation
How to install Cognos?
samirballal
- Mar 22nd, 2009
Go to the location where the report is saved on Cognos connection.Click on the name of the report. The report will run in the format already saved in the "Set? Properties" option.
velraj9
- Mar 12th, 2008
FOLLOW THE PROCEDURES1. a) Install SQL Server b) Then create Content Manager (New Database) In SQL Server c)Then apply securities such as Database login Id and user...
-
Cognos 8.3 Version New Features
What are the new features in Cognos 8.3 v?
maudgalyasa
- Apr 18th, 2009
It is a complete web based, dynamic, BI reporting solution from IBM, when we installing Cognos 8.3 and later two types of components get installed...i.e.,-> windows based components????? |-- Fram...
-
What is loop in frameworkmanager ?
ASHOK1324
- Apr 23rd, 2009
Loop: Loop is a closed path (relation) that exists among 3 (or) more tables. Loop gets created when "N" tables have "N" joins.For example if we have '3' tables T1 T2 T3 the...
rkiranbedi
- Mar 2nd, 2007
Loop is a closed Path. it can be exist b/w fact &dimensions, to resolve these we have to use shortcuts
-
How can we create reports in query studio?
ASHOK1324
- Apr 23rd, 2009
We can access "Query Studio" to create and view simple reports via cognos connection after selecting the package that got imported from cognos content store. We can now select Required Query Items from different Query Subjects to generate ad-hoc reports.
Rajitha
- Dec 14th, 2006
Through Cognos Connection we can access the Query Studio After that we can select our Package(Which one u imported DataBase). We Can select Required Query Items generate the reports. Its Generate Adhoc Reports.
-
What is purpose of using hierarchy in framework manager?
ASHOK1324
- Apr 23rd, 2009
Hierarchy defines the order of query items for report to report interactions [RRI]. Hierarchies are defined in query subject to support drill-down and drill-up functionalities.
Rpe
- Mar 26th, 2007
Ok, let's start with the definitions...hierarchyA description of the order of levels in a dimension. In Framework Manager, you define hierarchies in the query subject. levelA group of query items ...
-
Stiched Query
What is meant by Stiched Query?
sandeep8000861
- Apr 29th, 2009
When a report fetches data from more than 1 data source, multiple queries are sent to each of the data sources. The result-sets, from these individual queries sent to multiple data sources, are sticth...
-
Link Query to a Data Container
How can you link a query to a data container manually in Report Studio?
sandeep8000861
- Apr 29th, 2009
The various data containers available in Report Studio are Page, List, Crosstab, Chart, Repeater, Map.To link a particular query to any of the above containers, you need to select the container using ...
-
How to perform Single Signon in ReportNet by using URL?
swift_s
- May 6th, 2009
In Cognos configuration cognos under authentication the Allow anonymous access should be false.In cgi-bin properties (under IIS) the enable anonymous access should be false.
-
Use this query i am retriving all years OCt data from 01-10-2004 to 30-10-2007 i need to restrect this query to current date and current year [gosales_goretailers].[Orders].[Order month]between 01 and to_number(to_char(current_date,'MM'))and [gosales_goretailers].[Orders].[Order month]=to_number(to_char(current_date,'MM'))pass polar ID
NagaShilpaV
- May 20th, 2009
Using Current_Date function, you will get the current date. Then use the extract function to extract day, month and year. Then hardcode the filter in the query for day and year.
raju
- Nov 23rd, 2005
You have a function called 'extract' in cognos.Ex:- extract(month,the dte field). by giving like this you will get month. so you can keep a filter to restrict the rows only for october.
-
Build A Cube
How to build a Cube in Cognos 8 using Framework Manger?
rajitha_2000
- May 21st, 2009
In Cognos 8 Framework Manager we have a regular dimension and Measure Dimension.Regular Dimension means categories which we have in Transformer.Measure Dimension holds the measure data like as tr...
-
Burst Report
How to create burst report?
rajitha_2000
- May 21st, 2009
We have Burst option in a query studio while you have to create calculation how to divide the report and whom to get the the divide part of report. The same calculated Put it in Report Studio file ...
-
How to create Cube from Power play transformer by using SQL Server Database(with out creating IQD file using Cognos Impromptu from SQL Server)
nilesh_tiwari
- May 28th, 2009
From the 8.3 version of Cognos you can use even a more wider variety of datasources than you could use previuoslyYou can just publish a package from Framework manager and use it as a source for creating cubes, no need of creating an IQDYou can also use any Cognos 8 Report as a source.
the_xxx
- Oct 16th, 2007
Power Play transformer supports wide range of Local Data Sources, you cannot connect to SQL Server Directly without creating IQD's. Below is he list of data sources which you can use as Data...
-
Restricting the values for a prompt
How can you restrict the number of values available for a prompt?
-
Cognos Filters
List out the types of Filters in Cognos 8 and give the usage?
roopacrn
- Jun 2nd, 2009
In Report Studio, we have Detail filters and Summary filters.In Framework Manager, we have Embedded filters and Stand alone filters.
blm.swapna
- Mar 16th, 2009
Cognos filters are 2 types.1. Summary filter: Aggregated summation on total column2. Detail filter: Aggregated measureable item in row wise.
-
Represent Parameter
How to represent parameter while creating parameter prompt using filter option on data menu?
-
What is meant by Junk Dimension?
swift_s
- Jun 11th, 2009
A "junk" dimension is a collection of random transactional codes, flags and/or text attributes that are unrelated to any particular dimension. The junk dimension is simply a structure that p...
-
What is refreshing of a cube and how can we do it
ravimantur
- Jun 12th, 2009
Refreshing the cube fetches the latest data to the cube. Which can be used to extract the latest reports out of it. Inorder to refresh the cube right click on the cube in powerplay transformer you will get an option refresh cube click on it and its done.
chinnuchaitu
- Feb 13th, 2007
Refreshing the cube means it just gets the latest data and there is a option Refresh to do so.
-
Scheduling
By using Date Prompt . can we schedule the report ?
ps77322
- Jun 16th, 2009
Yes we can schedule a report to run on specified date and time. We can even get the output as in email.
-
Convert Crystal Reports into ReportNet or Cognos 8
How to convert Crystal Reports into Cognos Reports?
IBMCognosPartner
- Jun 22nd, 2009
If you are looking for a simple answer, there aren't any!? The two products are dramatically different with few common features and functionalities. Ive completed several of these conversions and ...
Cognos Interview Questions
Ans