Explore topic-wise InterviewSolutions in .

For FRAMEWORK manager packages, before you head away with creating a new package it asks whether or not you want to have security set up for the package in use. EVEN if you haven't defined any security at this stage, you can always goto the actions >> package >> Edit package settings and there you can define the security settings for the package.

For reports, you can either give report-level or folder- level security by GOING to the properties of that and choosing suitable roles/user groups that are SUPPOSED to be entitled to view/modify/create reports.

For framework manager packages, before you head away with creating a new package it asks whether or not you want to have security set up for the package in use. Even if you haven't defined any security at this stage, you can always goto the actions >> package >> Edit package settings and there you can define the security settings for the package.

For reports, you can either give report-level or folder- level security by going to the properties of that and choosing suitable roles/user groups that are supposed to be entitled to view/modify/create reports.

No

No

Reportnet1.1 migration TOOL is available to migrate the IMPROMPTU REPORT to REPORTNET.

Reportnet1.1 migration tool is available to migrate the impromptu report to reportnet.

List report show data in ROWS and columns VERSUS a cross tab report show data in grids with dimension in rows and columns and MEASURES in cells or in the intersection points.

List Report and Cross tab report both CONTAINS rows and columns but difference is list report is a detail report for analysis whereas cross tab report is the intersection of data or summarized data for analysis.

List report show data in rows and columns versus a cross tab report show data in grids with dimension in rows and columns and measures in cells or in the intersection points.

List Report and Cross tab report both contains rows and columns but difference is list report is a detail report for analysis whereas cross tab report is the intersection of data or summarized data for analysis.

By using the FRAMEWORK Manager we can CREATE measures and DIMENSIONS ACCORDING to our business needs.

By using the Framework Manager we can create measures and dimensions according to our business needs.

FIRST you have to CLICK on column header which you have to CHANGE. Then in property pane you will FOUND name option. Then change column name.

First you have to click on column header which you have to change. Then in property pane you will found name option. Then change column name.

• Cube can be created by using different data sources.
• Data sources: IQD, TEX file Cube CREATION by using iqd data sources.
• These iqd sources are COMING from IMPROMPTU.

Create a Model In framework Manager and then publish it, MAKE sure that Model meets the REQUIREMENTS, don't overload the model with unwanted query items.

Model is nothing but a project. And the project will be created by framework manager in which we can extract the metadata from the various operational sources... we will test the model by using the TOAD.

Model contains meta data which is related to business reporting INFORMATION. We import this data from the data base. Using this metadata we are creating PACKAGES, Publishing packages, This metadata contains query SUBJECTS and namespaces.

Create a Model In framework Manager and then publish it, make sure that Model meets the requirements, don't overload the model with unwanted query items.

Model is nothing but a project. And the project will be created by framework manager in which we can extract the metadata from the various operational sources... we will test the model by using the TOAD.

Model contains meta data which is related to business reporting Information. We import this data from the data base. Using this metadata we are creating Packages, Publishing packages, This metadata contains query subjects and namespaces.

Whenever we INSTALL COGNOS Server we get it documentation alone OTHERWISE we can store it in DEPLOYMENT FOLDER of Cognos.

Whenever we Install Cognos Server we get it documentation alone otherwise we can store it in Deployment Folder of Cognos.

TWO LEVELS: SUMMARY and DETAIL.

Two levels: summary and detail.

There is no specific reporting LIFECYCLE. We can generate the reports from data warehouse/data MARTS or we can generate the reports directly from OLTP systems.What I mean generating reports from OLTP systems is loading data into one system and generating the reports. But this is not recommended. This will depends on the BUSINESS.

1) Generating reports from the OLAP interface system retrieving the data from the data warehouse to generating FORMS and reports.
2) They can use Business intelligence project life cycle.

There is no specific reporting lifecycle. We can generate the reports from data warehouse/data marts or we can generate the reports directly from OLTP systems.What I mean generating reports from OLTP systems is loading data into one system and generating the reports. But this is not recommended. This will depends on the business.

1) Generating reports from the OLAP interface system retrieving the data from the data warehouse to generating forms and reports.
2) They can use Business intelligence project life cycle.

There is no limit for catalog size. It MAY be 3MB or 4MB.

There is no limit for catalog size. It may be 3MB or 4MB.

Without Dimension and Fact cannot make a relation between tables it could not be USE for JOINS and retrieve the DATA as a form of reports in cognos. Dimension is a major subject AREA through which we can analysis our business.

Without Dimension and Fact cannot make a relation between tables it could not be use for joins and retrieve the data as a form of reports in cognos. Dimension is a major subject area through which we can analysis our business.

• List report, Cross TAB report, PIE charts ETC.
• Master detail, DRILL through, CascadingList, Cross tab, CHART, Map report are the basic report of Cognos.

Slowly Changing Dimensions are those whose DATA are not fixed.

SCD types:
SCD type 1: Whose data is not fixed.
Historical data are not saved. Data keeps on changing.-> Current Data

SCD type 2: Whose data is fixed and ALSO save historical data.

SCD type 3: Like SCD type 2 only but save historical data in ANOTHER table. In one table data will updated and in another table historical data will be there.

Slowly Changing Dimensions are those whose data are not fixed.

SCD types:
SCD type 1: Whose data is not fixed.
Historical data are not saved. Data keeps on changing.-> Current Data

SCD type 2: Whose data is fixed and also save historical data.

SCD type 3: Like SCD type 2 only but save historical data in another table. In one table data will updated and in another table historical data will be there.

In transformer you import METADATA from architect or catalog to CREATE a CUBE. We just import metadata. we don’t add DATA to it.

In transformer you import metadata from architect or catalog to create a cube. We just import metadata. we don’t add data to it.

Loop is an very dangerous EXCEPTION in framework manager we can resolve the loop create alias table. loop Display wrong results in the reportnet. A Loop is a Closed Path CIRCUIT.

AVOID loops: using SHORTCUTS.We have ambiguous relationships types:Hierarchical relationships RECURSIVE relationships Multi-valid relationships. To avoid these relationships using shortcuts.

Loop is an very dangerous exception in framework manager we can resolve the loop create alias table. loop Display wrong results in the reportnet. A Loop is a Closed Path Circuit.

Avoid loops: using shortcuts.We have ambiguous relationships types:Hierarchical relationships Recursive relationships Multi-valid relationships. To avoid these relationships using shortcuts.

In CRN we can't view multi dimensionally,

• we cant' see a REPORT in excel,
• we can't format a report in CRN

Report net does not support DRILL through and ALSO bursting of reports is no possible in report net. Also it does not support DIMENSIONAL analysis.

In CRN we can't view multi dimensionally,

Report net does not support drill through and also bursting of reports is no possible in report net. Also it does not support dimensional analysis.

You can ASSOCIATE one or more data ITEMS with a GROUPED data ITEM. An associated data item should have a one-to-one relationship with the grouped data item. For example, Order No. is a grouped data item.
For each order number, there is an Order DATE. Order No. and Order Date have a one-to-one relationship.

You can associate one or more data items with a grouped data item. An associated data item should have a one-to-one relationship with the grouped data item. For example, Order No. is a grouped data item.
For each order number, there is an Order Date. Order No. and Order Date have a one-to-one relationship.

While creating REPORTS or creating models LOGS have all INFORMATION till SESSION closed.

While creating reports or creating models logs have all information till session closed.

2.0 GB (It DEPENDS on your PROJECT REQUIREMENTS).

2.0 GB (It depends on your project requirements).

A Snapshot is a Permanent Local Copy Of the Report.Snapshot is Static Data Source it is SAVED with .IMR File it is suitable for Disconnected NETWORK.

A Snapshot is a Permanent Local Copy Of the Report.Snapshot is Static Data Source it is saved with .imr File it is suitable for Disconnected Network.

FRAMEWORK Manager generates a separate QUERY for each 'FACT' table and joins the RESULT set this is called STITCHED query.

Framework Manager generates a separate query for each 'FACT' table and joins the result set this is called Stitched query.

#parameter1#. Give this in ur FILTER where U pass MULTIPLE VALUES

#parameter1#. Give this in ur filter where u pass multiple values

Open framework manager click on any query SUBJECT and go Open the properties dialogue BOX and you can observe the EXTERNALIZE METHOD you CHANGE the IQD.

Open framework manager click on any query subject and go Open the properties dialogue box and you can observe the EXTERNALIZE METHOD you change the iqd.

CRN is WEB based TOOL. So it will very useful to VIEW the REPORTS very easily. So that they preferred CRN

CRN is web based tool. So it will very useful to view the reports very easily. So that they preferred CRN

IQD stands for IMPROMPTU query definition. It is report save extension with .iqd it is use for creating a cube in power play transformer.

IQD is Impromptu Query Definition. It CONTAINS the SQL query to DISPLAY the data from the database and SQL query is automatically created based on the columns SELECTED from database.

IQD stands for Impromptu query definition. It is report save extension with .iqd it is use for creating a cube in power play transformer.

IQD is Impromptu Query Definition. It contains the SQL query to display the data from the database and SQL query is automatically created based on the columns selected from database.

FILTERS in framework manager are
1. Standalone filters
2. EMBEDDED filters

Report studio Filters are
1. DETAIL filters
2. Summary filters

Filters in framework manager are
1. Standalone filters
2. Embedded filters

Report studio Filters are
1. Detail filters
2. Summary filters

USING deplyement TOOL we can MIGRATE the REPORTS.

using deplyement tool we can migrate the reports.

In cognos configuration under authentication ALLOW ANONYMOUS access should be FALSE.In cgi-bin PROPERTIES (under iis) the ENABLE anonymous access should be false.

In cognos configuration under authentication allow anonymous access should be false.In cgi-bin properties (under iis) the enable anonymous access should be false.

Open COGNOS CONNECTION in that select REPORT studio or query studio it will DISPLAYS there you have PACKAGES(ex: gosales and goretailr (defult)) click on that it display Report studio in that select Object pane select required query subject then click run it displays your report on report viewer screen.

Open cognos connection in that select Report studio or query studio it will displays there you have packages(ex: gosales and goretailr (defult)) click on that it display Report studio in that select Object pane select required query subject then click run it displays your report on report viewer screen.

Enhancements in COGNOS REPORTNET is Cognos 1.0, 1.1, MR1.1, MR1.2 Cognos 1.0,1.1, MR1.1, MR1.2 AND cognos 8, 8.1.1MR, 8.1.2MR, now new version is 8.2

Enhancement in cognos in the list report:-

• APPLY list column title STYLES
• Apply list column body styles
• Apply table styles.

Enhancements in Cognos reportnet is Cognos 1.0, 1.1, MR1.1, MR1.2 Cognos 1.0,1.1, MR1.1, MR1.2 AND cognos 8, 8.1.1MR, 8.1.2MR, now new version is 8.2

Enhancement in cognos in the list report:-

• Drill down means it will explains the summary level information to LOWEST level information.
• Slicing is nothing but cutting edge of the CUBE.
• Dicing is nothing but viewing the cube in all possible directions.
• Drill down is the way to GET the more detailed DATA.
• Slicing and dicing is to get the data ACCORDING to where clause.

GO to Cognos Configuration and SEE the settings for cognos in the EXPLORER PAGE. There you can SET for win2000 server.

Go to Cognos Configuration and see the settings for cognos in the explorer page. There you can set for win2000 server.

Basically there are TWO types of securities for any object Levels of Securities:

1. Database LEVEL SECURITY
2. Row level security

EVEN we can provide LDAP security too.
By setting up the Governors in frame work manager also we can give the security to the data accessing through the report.

Basically there are two types of securities for any object Levels of Securities:

Even we can provide LDAP security too.
By setting up the Governors in frame work manager also we can give the security to the data accessing through the report.

Go to POWER play transformer, on toolbar select RUN menu. In RUN menu there is one option that is TEST BUILD you can test ur report there.

You may ALSO test the outcome of a report by writing and EXECUTING SQL Queries and comparing the outcome with the report outcome.

BY USING SYSTEM TESTING, UNIT TESTING, PERFORMANCE TESTING

Go to power play transformer, on toolbar select RUN menu. In RUN menu there is one option that is TEST BUILD you can test ur report there.

You may also test the outcome of a report by writing and executing SQL Queries and comparing the outcome with the report outcome.

BY USING SYSTEM TESTING, UNIT TESTING, PERFORMANCE TESTING

Using a single Model, we can create as many number of CUBES U WANT. By using the dimension VIEWS...etc. Regarding the navigation, when we save cubes, these act as separator multidimensional databases. There wont be any relations. Navigate means opening the cubes separately.

Using a single Model, we can create as many number of cubes u want. By using the dimension views...etc. Regarding the navigation, when we save cubes, these act as separator multidimensional databases. There wont be any relations. Navigate means opening the cubes separately.

This can be DONE in IMPROMPTU ADMINISTRATOR.

This can be done in Impromptu administrator.

Macro is set of instructions to RUN REPORT.

Prompt is just like a DIALOG box which will ASK USER to select/enter the information what he needs.

Macro is set of instructions to run report.

Prompt is just like a dialog box which will ask user to select/enter the information what he needs.

• Users and Permissions can be given in Access manager - Administration.
• INDIVIDUAL users can be created using their names or their Ids (if any) in Access manager and then be given permissions.
• This TOOL is loaded when you install Cognos 7.x in your machine.
• In content manager--we have one component CALLED cognos process manager, using process manager we can integrate with third PARTY tools like LDAP or NTLM. we cannot create users in reportnet directly, in real time we can use LDAP.

Open that report and SAVE as that reportSelect public FOLDER and then SELECT package in which package you WANT to save then save it.

Open that report and save as that reportSelect public folder and then select package in which package you want to save then save it.

drill through ALLOWS you to navigate from summary to DETAILED information.

drill down also similar kind of thing,for example will do drill down on year if we drill down on this the next level will COME means year contains quaters, it contains

• months,
• months contains weeks,
• WEEK contains DAYS.

so,we can view all the levels through drill down.

drill through allows you to navigate from summary to detailed information.

drill down also similar kind of thing,for example will do drill down on year if we drill down on this the next level will come means year contains quaters, it contains

so,we can view all the levels through drill down.

Report can be DIVIDED into different PARTS and SENDING these different parts of report to different users. It occurs in COGNOS connection.

Report can be divided into different parts and sending these different parts of report to different users. It occurs in cognos connection.

The SECURITY module USED in COGNOS is cognos ACCESS manager.

The security module used in cognos is cognos access manager.

A Filter is a restriction that reduces the amount of data displayed in the REPORT.
The report filters are non-reusable and specific to the report.
Filters are

• before aggregation: non-aggregated RECORDS are FILTERED(DETAILS record)
• after aggregation: summary records are filtered

A Filter is a restriction that reduces the amount of data displayed in the report.
The report filters are non-reusable and specific to the report.
Filters are

Transformer is USED for building the CUBES (MULTIDIMENSIONAL Structure used for OLAP processing).

Transformer is used for building the Cubes (Multidimensional Structure used for OLAP processing).

A catalog is a file containing the information (Database tables) that IMPROMPTU users need to CREATE REPORTS.

► personal
► distributed
► shared
► secured

shared catalog is better.

A catalog is a file containing the information (Database tables) that Impromptu users need to create reports.

► personal
► distributed
► shared
► secured

shared catalog is better.

impromptu MENU go to Catlog->User profiles -> userclass tab -> CLICK on Creator ->you can give there folder access,table access,filters,Governor etc.

you can create users by USING USERS PROFILE option..and you can give permissions using ROLE IN C8 and GOVERNERS in C7.

impromptu menu go to Catlog->User profiles -> userclass tab -> click on Creator ->you can give there folder access,table access,filters,Governor etc.

you can create users by using USERS PROFILE option..and you can give permissions using ROLE IN C8 and GOVERNERS in C7.

By using COGNOS Schedular, one can SCHEDULE the running reports in Impromptu to execute and save it in desired format.

By using Cognos MACRO script language the reports can be executed and DISTRIBUTED to recipients by using mail applications.

COMPILED Cognos MACROs can be scheduled using Cognos Schedular.

By using Cognos Schedular, one can schedule the running reports in Impromptu to execute and save it in desired format.

By using Cognos MACRO script language the reports can be executed and distributed to recipients by using mail applications.

Compiled Cognos MACROs can be scheduled using Cognos Schedular.

In cognos report net by the validate report option a report can be tested. If there will be any ERROR, it will specify the error, UNLESS it will GIVE message -'report specification is valid'.

After creating the report we will connect to the oracle and we will WRITE the SQL query and we will compare this 2 reports .

In cognos report net by the validate report option a report can be tested. If there will be any error, it will specify the error, unless it will give message -'report specification is valid'.

After creating the report we will connect to the oracle and we will write the sql query and we will compare this 2 reports .