Explore topic-wise InterviewSolutions in .

• Tabular model: It is the basic list query. It contain the data ITEMS, filters and CHILD tabular objects.
• Tabular SQL: We can write and edit our own SQL
• Tabular ref: It is a SHORTCUT to another tabular object somewhere in another query within the same REPORT specification.
• Tabular set: Tabular set object returns a single result set using union, INTERSECT or minus operators

We can limit the maximum number of ROWS by setting the web page size OPTION in the MANAGE file tab in the REPORT STUDIO.

We can limit the maximum number of rows by setting the web page size option in the manage file tab in the report studio.

Yes it can CONNECT multiple DATASOURCES at a TIME when the frame work MANAGER has the metta data REGARDING that datasources.

Yes it can connect multiple datasources at a time when the frame work manager has the metta data regarding that datasources.

The difference between Filter and CONDITION:Condition returns TRUE or false Ex: if Country = 'India' then ...Filter will RETURN two types of results

1. Detail information which is EQUAL to where clause in SQL statement
2. Summary information which is equal to GROUP by and Having clause in SQL statement

The difference between Filter and Condition:Condition returns true or false Ex: if Country = 'India' then ...Filter will return two types of results

• We can in do it in this way. first creat a list REPORT in which u have a calculated item in the starting.
• Then creat a prompt page with a value prompt.In value prompt creat static CHOICE of which u want to be dynamically DISPLAYED.
• Let the parameter of value prompt be ?Par1? and the choices as Revenue, Cost.
• Now u write the expression of the calculated item in the report page as follows, "If ?Par1?=Revenue then Revenue ELSE Cost.
• Here Revenue,Cost should b dragged from the Model Items. So now the calculated item column displays the value of the one selected in the prompt.
• Now make a graph using the list report,then place the calculated item on the axis of the chart ,which u wanted to DISPLAY dynamically based on ur selection.
• So now if u select Revenue in the prompt then the grph will take the values for Revenue.And if u select Cost then graph will be with the values of Cost.

There isnt any need to copy the data before reporting on as long as the data is clean. But if the data is not clean it should be cleansed and so go for ETL process.

Adv of reporting directly against the DATABASE(OLTP): No need to sepertaley maintain a Database for it.(SPACE consumption is recduced).

Disadv of reporting directly against the database(OLTP): It slows down the process bcoz OLTP system is DESIGNED for the online application but a DataWarehouse application which requires to do ANALYSIS and hence takes the same data but takes a long time.

There isnt any need to copy the data before reporting on as long as the data is clean. But if the data is not clean it should be cleansed and so go for ETL process.

Adv of reporting directly against the database(OLTP): No need to sepertaley maintain a Database for it.(Space consumption is recduced).

Disadv of reporting directly against the database(OLTP): It slows down the process bcoz OLTP system is designed for the online application but a DataWarehouse application which requires to do analysis and hence takes the same data but takes a long time.

Model:

• Model is a representation of the metadata structures(imported from the soure datawarehouse).
• A model contains organized metadata objects(organizing depends on business needs).
• After the completion of a model(obviously in a framework manager environment) it has to SUBMITTED to ReportNet server.

Package:

• There enterts the object called Package.
• A Package compresses(or includes) the DEVELOPED meta data definitions and publishes (forwards) it to ReportNet server.
• Then the reportnet server moves it into a content store(repositiry) and now this repository acts as a source for report developers for generating various types of reports(list reports, CROSS tab reports ETC etc.)

Model:

Package:

TEMPLATE EXTENSION is .IMT

Template extension is .imt

Its a multidimensional VIEW of DIMENSION and MEASURES. It is used to ANALYZE the data in various aspects, which is called slicing and dicing

Its a multidimensional view of dimension and measures. It is used to analyze the data in various aspects, which is called slicing and dicing

Actually the it is not possible to make reports without packages and packages can be build in FM. So no WAY ONE can SKIP FM and create reports.Adding to it,we NEED metadata (created in FM) to create relations among tables or views and also creating objects which satisfies reporting need.

Actually the it is not possible to make reports without packages and packages can be build in FM. So no way one can skip FM and create reports.Adding to it,we need metadata (created in FM) to create relations among tables or views and also creating objects which satisfies reporting need.

• '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.

One of the advantage's of Reportnet, is:

• It is web-based REPORTING wherein, reports can be easily accessed from anywhere through a browser.

By USING ipromptu we can use multidimensional analysis to SEE the DATA in diff formates.i.e we have drillup,drilldown features in cognos impromtu,but it is not POSSIBLE in reportnet.

One of the advantage's of Reportnet, is:

By using ipromptu we can use multidimensional analysis to see the data in diff formates.i.e we have drillup,drilldown features in cognos impromtu,but it is not possible in reportnet.

If we wanna test the REPORT in report net, FIRST we can intially CHECK by validating it in the report page.

After that we can test the out put of the report Using a SQL anlyser and sql query.so here we will be comparing the sql analyzer output with the output of the report viewer.

If we wanna test the report in report net, first we can intially check by validating it in the report page.

After that we can test the out put of the report Using a sql anlyser and sql query.so here we will be comparing the sql analyzer output with the output of the report viewer.

You need to do the following for a standard installation process:

1. VERIFY your system requirements like RAM Minimum: 512 MB, a Web server installed and started
2. Review the ReportNet default settings like default ReportNet ports and URI settings.
3. Create the database for the content store which means you must create the database that is used for the content store using either Oracle, Microsoft SQL Server, or DB2 UDB. ReportNet uses this database to store, organize, and retrieve INFORMATION.
4. Install ReportNet: Use the installation wizard to select the components you want to install and the LOCATION on your computer where you want to install them.
5. Set up the database client for the content store (Oracle and DB2): If you use Oracle or DB2 as the database server for the content store, additional steps are required after you install ReportNet before you can configure ReportNet. you need to go to the 6th step only when installing on UNIX. For Windows above 5 steps are good.
6. Update Your Java Environment: Before you can use the cryptographic operations, such as DATA encryption and key management, implemented by ReportNet, you must check that the required JAR (Java Archive) files are present in your Java Runtime Environment (JRE).

You need to do the following for a standard installation process:

We have a function called param DISPLAY VALUE. By USING this function we can display the parameter value SELECTED in prompt.

We have a function called param Display Value. By using this function we can display the parameter value selected in prompt.

Prompts act as questions that help USERS to customize the information in a report to suit their own NEEDS.

The different types of Prompt are :

• Value prompt
• Text Prompt
• Date prompt
• Time prompt
• Date and time prompt

Using prompts is faster and easier than REPEATEDLY changing the filter.Cognos Report Studio provides several ways to create prompts.

You can :

• use the Build Prompt Page tool
• build your own prompt and prompt page
• create a PARAMETER to produce a prompt
• create a Prompt DIRECTLY in a report page

Prompts act as questions that help users to customize the information in a report to suit their own needs.

The different types of Prompt are :

Using prompts is faster and easier than repeatedly changing the filter.Cognos Report Studio provides several ways to create prompts.

You can :

procedure for PROVIDING security for query subject in FRAME WORK manager is:

select querysubject -> in properties pane select ->security filters(click on edit)a specify data security wizard appears->click on ADD groups -> cognosnamesspace(select users and groups wizard opens)

procedure for providing security for query subject in frame work manager is:

select querysubject -> in properties pane select ->security filters(click on edit)a specify data security wizard appears->click on add groups -> cognosnamesspace(select users and groups wizard opens)

It has six (6) formats in report NET. They are HTML, PDF, Excel 2000, Excel 2002, CSV, and XML FORMAT. We can see the types of formats in the report viewer on the RIGHT side

It has six (6) formats in report net. They are HTML, PDF, Excel 2000, Excel 2002, CSV, and XML format. We can see the types of formats in the report viewer on the right side

There may be a Feature film (movie) WITHOUT a Trialer.But there will be no trialer without a movie.similarly Data warehousing is a concept related to extracting CLIENT's business data and applying business processing features on that data according to USER needs and finally loading the processed data into a database,this database is what we call a warehouse or data warehouse.

After the completion of a data warehouse the business user ultimately want to view his data (a precise and summary data)but as a business person he may don't have knowledge of accessing a database( a computer person can ACCESS the database with SQL)..

so there comes olap toos(which help that person to access the database )we can call these olap tools as Business Intelligence tools(Intelligence in sense they generate sql QUERIES internally and provide lot of facilities and privileges for a reporting developers in formating the data and presenting it in a higly convenient manner).

So data warehouse(movie) is a database and business intelligence tools(trialers) present the content of a database in an effecticient manner.

There may be a Feature film (movie) without a Trialer.But there will be no trialer without a movie.similarly Data warehousing is a concept related to extracting client's business data and applying business processing features on that data according to user needs and finally loading the processed data into a database,this database is what we call a warehouse or data warehouse.

After the completion of a data warehouse the business user ultimately want to view his data (a precise and summary data)but as a business person he may don't have knowledge of accessing a database( a computer person can access the database with SQL)..

so there comes olap toos(which help that person to access the database )we can call these olap tools as Business Intelligence tools(Intelligence in sense they generate sql queries internally and provide lot of facilities and privileges for a reporting developers in formating the data and presenting it in a higly convenient manner).

So data warehouse(movie) is a database and business intelligence tools(trialers) present the content of a database in an effecticient manner.

ReportNet has a three-tier architecture, namely,

1. Web server 
2. Applications and 
3. Data.

The tiers are BASED on business function, and are TYPICALLY separated by firewalls. ReportNet user interfaces SIT above the tiers.ReportNet user interfaces include

• Web-based COGNOS Connection, Cognos Report Studio, and Query Studio.
• Windows-based Framework Manager.

ReportNet has a three-tier architecture, namely,

The tiers are based on business function, and are typically separated by firewalls. ReportNet user interfaces sit above the tiers.ReportNet user interfaces include

CREATE 2 ROLES . One role can be given ACCESS to create reports in RS and the other role MAY be denied.

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

Create a QUERY Subject, from the properties pane SELECT externalise,there we have 4 OPTIONS in that select IQD

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

There is a lot of DIFFERENCE between CRYSTAL reports an Cognos REPORT net:

1. Crystal report is a product of Business Objects where as Reportnet is of cognos.
2. 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.
3. In reportnet we can login through web and can create our own desired report through web.

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

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.

In cognos reportnet

In ReprotNet have TWO vertions:

1. REPORTNET 1.0
2. ReportNet 1.1 MR1, MR2

In ReprotNet have two vertions:

• 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.

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.

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.

COMPONENTS of Report Studio:

1. Insertable Objects PANE.
2. PROPERTIES pane.
3. Explorer bar - Conditional Explorer, Query Explorer, PAGE Explorer.
4. Report Viewer - Work area, Report LAYOUT Objects.

Components of Report Studio:

• '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.

Query Studio:

1. Used to create Ad-hoc (or) simple reports.
2. It does not provide any pre-defined report TEMPLATES.
3. It directly DISPLAYS data (without running the report) when we INSERT attributes in the report.

Report Studio:

1. Used to create COMPLEX reports.
2. It provides pre-defined report templates.
3. It does not display the data directly in the report. We need to RUN the report to display the data.

Query Studio:

Report Studio:

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.

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

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

1. configuring Cognos Series 7 for drill-through access to ReportNet
2. preparing the Transformer model and cube
3. copying the search PATH of the folder that contains the target REPORT
4. enabling the cube for drill-through access to ReportNet
5. deciding which filters to create in the target report
6. creating the target report
7. DISABLING the Drill Through Assistant

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