What are the unique advantage of having 3 explorer in cognos i.E 1) page explorer 2) query explorer 3)variable explorer
By using one drill through can we explore the four reports at a time ?
1) Create Drill through report to link two reports contain related information 2) You can access related and more detailed information in one report by using to select a value in another report. ...
Its possible for eg: you click on any list column body and click on drill through.Over there you can add multiple new drill throughs and each drill through can open a new report. So when you run ...
Reconciliations compares two set of accounts. It is usually the balance in two accounts to make sure that they are in agreement.
Suppose you have 2 types of balances A and B reconcilaition is a process in which we compare if balances in A are equal to balances in B
Hello everyone, I am using report studio in report net. I have a value prompt that I would like to display a code number and its description. As it is now, it will only display EIther the code number or the description, not both. Is there anyway I can display both with a space in the middle? Thanks!!
1)create a new data item in that concatenate code with the description
2) in the properties of value prompt select the display value to the new data item created.
Reportnet report studio & cognos8 report studio
What are the differences between cognos reportnet 1.1 report studio and cognos 8 report studio?
These are the differences between Cognos Reportnet report studio and Cognos 8 report studio: 1. In Cognos 8 we can use dimensional data for reporting.2. We can drill through from chart also in Cog...
Cognos 8 Report Studio is the reporting tool for ReportNet, the Web-based reporting solution.
What is the use of event studio, analysis studio and metric studio
Please explain what is the use of event studio, analysis studio and metric studio and when and where we will use these studios
Analysis Studio - an application to analyze cubes and explore business data in a multidimensional manner. Mainly used by business analysts. • Metrics Studio - used for the scorecarding. The idea ...
How to limit the output in a report for testing?
Let us assume that I have to create a report whose output has 1 million rows. When I create the report and run it may take several hours to show me the complete report. So can I limit the output to just 100 rows to save time while testing the report? Thanks in advance.
You can limit data by applying filter on some query item - for example if you have somany contract ids - you can apply filter contract id -1234
In the run options set the data mode to limited data.
What r the components of cognos connection?What r the components of query studio?What r the components of report studio?What r diff between master detailed relationship and drill through report?
What are the components of Cognos connection? Cognos connection is the single point of entry to all of the report writing tools. You can customize your pages and tabs. It contains cognos administr...
Cognos Connection is a single entry point to access entire functionality of the Cognos ReportNet, such as Report Studio, Query Studio, Reports, Server Administration, Directory Administration, System Administration etc.
Cognos report studio data containers
What are the types of data containers in cognos report studio?
List
list, crosstab, charts
Hi friends,i have a problem with suspense account. I been working for some organization and they have been getting this suspense account error since 2003. But its a big organization and they didn't consider it as a problem so far..But now-a-days this suspense account is increasing rapidly and decreasing...
I have worked for "Westpac Banking corporation" which is largest bank of Australia. I was in suspense team. In suspense accounts generally value comes when the values moves from sub ledger to ledge...
To clear suspends account in oracle finance.we have to assign suspends account type in at our chart of accounts as liabilities account type.in values of account segment.then go to accounting setups op...
Can you apply the master detailed relationship between query studio report and report studio report? How?
Master detailed relationship from query / Analysis studio report and Report Studio report can be created only with the use of Package level drill through.
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 ...
If there is no calculations and the data is summerized, will you use materialized view? Give reason
they can be used to summarize, precompute, replicate, and distribute data.
but if there are no calculations needed and the summarization is already been done then not sure if we need to use them..
How do you partition time dimension in cognos.
i guess by partitioning it in date, month, year, hours, minute, second.
1. Getting the requirements for report creation. (could be any functional document)2. Tables creation.3. Working on the framework manager for data modelling4. Starting report development acc...
I need answer
Macro is a object embeded with in the query or the sub query which can be executed while runing the query.
Junk dimension means, The dimension value which has absolute value in the dimensional hierarchy. and the lowest level of the the dimensions does not have corresponding measures in the face table. When...
Here it goes: Page explorer: You use this to navigate through pages of a report (page by page). You can also use this to add more pages to your report.Query Explorer: You use this to view or modify th...
For the ease in accessing / arranging pages, queries and variables.