Best Cognos Reportnet Interview Questions

How To Drill Through From A Powerplay Cube To Reportnet?

Setting up drill-through access from PowerPlay Web to ReportNet involves :

configuring Cognos Series 7 for drill-through access to ReportNet
preparing the Transformer model and cube
copying the search path of the folder that contains the target report
enabling the cube for drill-through access to ReportNet
deciding which filters to create in the target report
creating the target report
disabling the Drill Through Assistant

How To Create Prompts In Report Net?

Prompts is meant by the end user can be filter the data.

u can open the explore bar and added the new prompts page, And enter the new name.
u go to tool menu and track prompts button.
u select prompts and then ok.

Explain What Is Difference Between Query Studio And Report Studio?

Query Studio:

Used to create Ad-hoc (or) simple reports.
It does not provide any pre-defined report templates.
It directly displays data (without running the report) when we insert attributes in the report.

Report Studio:

Used to create complex reports.
It provides pre-defined report templates.
It does not display the data directly in the report. We need to run the report to display the data.

What Is The Difference Between Powerplay Transformer And Power Play Reports?

‘Powerplay transformer’ is an ‘MOLAP’ tool using which one can create multi dimensional structure called “CUBE”.
‘Powerplay for reports’ is used to generate report from the cube.Only one report can be generated from one cube.If u want ‘n’ reports u must create ‘n’ cubes.

Explain What Are Components Of Report Studio?

Components of Report Studio:

Insertable Objects pane.
Properties pane.
Explorer bar – Conditional Explorer, Query Explorer, Page Explorer.
Report Viewer – Work area, Report Layout Objects.

Explain What Are The Advantages Of Query Studio Compared To Report Studio?

The query studio is used to create adhoc reports, it is easy to understand the bussiness user.The report studio is mainly used to create proffessional and corporate reports, it is not like query studio it is having mainly 3 explorers those are page explorer,conditional explorer and variable explorer by using these it is working.

You can view the output in the work area itself while creating the reports in QS but in report studio only when u run the report you can view the values ie the output.

How To Generate The Cubes In Framework Manager?

You can create the IQD file from framework manager.
This IQD file will be used by Transformer to create the cube.
Use Externalize method to import IQD files.

Explain The Versions Of Reportnet?

In ReprotNet have two vertions:

ReportNet 1.0
ReportNet 1.1 MR1, MR2

Explain The Difference Between Native Sql And Cognos Sql?

In cognos reportnet

Native SQL is used for the single datasource to import the meta data.
Cognos SQL used for multiple datasources to import the metadata.

Explain Is There Any Comparison Available For Cognos Reportnet Vs Crystal Reports?

There is a lot of difference between Crystal reports an Cognos Report net:

Crystal report is a product of Business Objects where as Reportnet is of cognos.
Cryatal reports is for only low 2 midrange analysis and that to some even says tha they wont use this for analysis used to make proper strategic decision But report net yes it is for high end analysis.
In reportnet we can login through web and can create our own desired report through web.

Explain How To Generate Iqd File From Framework Manager?

Create a Query Subject, from the properties pane select externalise,there we have 4 options in that select IQD

Suppose Your Client Wants To Ensure Only Specific Users Can Create Reports In Query Studio With Other Users Creating Reports Using Report Studio. How Can This Be Accomplished?

Create 2 roles . One role can be given access to create reports in RS and the other role may be denied