-
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 ...
-
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...
-
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.
-
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.
-
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 ...
-
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...
-
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 ...
-
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 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
-
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...
-
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...
-
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 ...
-
What is the difference between the render variable and the style variable?
cognosvij
- Mar 17th, 2009
Render Variable: - Specify a variable based on which object can be conditionally rendered.Style Variable: - Specify a variable based on which object can be conditionally styled.Example for Style...
sivakumar.bora
- Jan 29th, 2008
Render Variable: - Specify a variable based on which object can be conditionally rendered.Style Variable: - Specify a variable based on which object can be conditionally styled.
-
How to Migrate reports from Cognos Impromptu 7.x to Cognos ReportNet
binduandme
- Mar 10th, 2009
From Impromptu to Reportnet we use a migration tool called cattoxml which you can find after installation in cer2/../bin folder go to command prompt and give the path of the tool and say cattoxml the...
g.malli
- Aug 23rd, 2007
I think in my view to migrate a report from impromptu to report net the administrator must configure impromptu on reportnet server with proper credentials then only we can open and logon, we should log on to both other wise we can't
-
How can we use NVL function/Dataformat to resolve the Blank spaces in our report. Explain with navigation
binduandme
- Mar 10th, 2009
Yes this was the aproch in previous version but from Cognos 8 specifically from 8.3 you have no data option provided to handle missing values.
sivabisani
- Nov 14th, 2008
As per my understanding we need to put '0' i place of blanks that's correct?for this we can select the dataitems which have blanks and then goto properties pane then select the dataformat in that selc...
-
What is meant by dash boards/flash cards?
simik
- Feb 24th, 2009
Dashboards are reports created using graphs and charts as a mechanism of presenting information.Dashboards communicates complex information quickly. They translate information from your various corpor...
rkiranbedi
- Mar 5th, 2007
Dash Board reports are used to create many reports in one report like Gauge chart, Progress chart, Combination Chart and so on. It combines Multiple Queries into a same chart are multiple charts.
-
What is a complex report, where it'll useful
simik
- Feb 24th, 2009
A complex report is a report that has multiple queries, variables, conditional formatting, advanced prompting, HTML items, JAVA scripts, images.
chinnuchaitu
- Feb 13th, 2007
Complex report is the one that shows a list chart, bar chart , product images etc to illustrate every thing whatever requirements are not predefined and are specific in a single report.Report Studio is a Web product for creating complex reports.
-
What is the technique to know total load of Data in cognos Decision Stream7
nehaleo03
- Feb 4th, 2009
In Decision Stream7 when the data is passed from the source through the data stream we can double click the data stream and click on the option generate SQL, it will show all the total number of records from the input.
-
How to configure content store in Cognos?
my OS is windows XP Prof , back-end oracle 9i , i tried to install cognos repertnet8.2 , but couldn't able to start the service..content store is not configured correctly. what are the steps to configure it and how to create a new database for content store?thanks
phamminhtruong
- Jan 14th, 2009
Hi sreedil,??? I am also newbie of Cognos. Your problem is caused of Oracle JDBC driver loading. So you copy classes12.jar (>= 10g) or classess12.zip (
sreedil
- Nov 12th, 2008
Go to Cognos Configurationlook for Content ManagerDelete the default COntent Store For SQL ServerRight Click Content manager and create a new content storeGive data base name as OracleGive the user id...
-
How to improve Report performance in ReportNet.
thakkalapelly anil
- Aug 30th, 2007
To improve the performence of the report move all the calculations and filters from report level to frame work manager.
Cognos Interview Questions
Ans