1. What are products of cognos?
Cognos 6.6 7.0,7.3(PowerPlay, Impromptu)--ReportNet1.0,1.1mr1, 1.1mr22---ReportNet 8.0(latest)IWR is use by Impromptu to publish reports, PPES is used by PP, Cognos Connection is used by repornet. there are many other tools but these are the main.
2. How can i test reports in cagonos?
In cognos report net by the validate report option a report can be tested. If there will be any error, it will specify the 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 .
3. How can i schedule reports in cognos?
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.
4. How can create users and permissions in cognos?
in impromptu menu go to Catlog->User profiles -> userclass tab -> click on Creator ->u can give there folder access,table access,filters,Governor etc
you can crate users by using USERS PROFILE option......and you can give permissions using ROLE IN C8 and GOVERNERS in C7
5. What is Cognos Visualizer and Cognos Scripting?
Visualizer is a representation of data cubes in a dashboard format. We can drill through to the ground level of a hierarchy as like in power play report but cannot add or remove fields dynamically.
Cognos script editor : We can write cognos macros or programs in this tool and can fine tune or process some execution .
6. What is catalog and types of catalogs in cagonos and which 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.
7. How do add dynamic titles in PP?
PowerplayFrom format menu-->title, header & footer-->title-->insert report filename
8. What you mean by Drill across and what is the difference between drill through, drill across?
Drill across means when you are moving from one report to another report like country in one report and States in another Report whereas if the report is using same report from moving from country to state. In other when you are moving details level if you are using the different report it is drill across and if you are using same report it is drill through.
9. What is loop in frameworkmanager?
Loop: loop is a closed path (relation) that exists among 3 (or) more tables. For example, if we have '3' tables T1, T2, T3 then, a loop exists among these tables only when we create joins in the following fashion:
Loop: T1 ---> T2 ---> T3 ---> T1
To resolve the above problem, we have to create a shortcut (or) Alias to the Table T1.
No Loop: T1 ---> T2 ---> T3 ---> Alias (or) Shortcut of T1
10. How create measures and Demensions?
You can create measure once you import all the data into the data source.You can create measures and dimensions by draging the required source from datasource into dimension map and measure tab.(need to find scope of measures for all the dimensions)
Alternate drill down path means there will be two path to opt.For example- We will have time dimension now the client requirement is they want two type of year -one is calender year(Jan-Dec) and another is fiscal year(Apr-Mar).
12. What is the difference between enterprise data warehouse and data warehouse?
Big Organizations have a lot of diversified sources of data.There might be a dataware house exclusively for transport and others for data related to the project the company runs.In such case the complete enterprise's(company's) date ware house is a big combination of all and is known the Enterprise data Warehouse(EDW)
13. How you drill from powerPLay to Impromptu? Explain all Steps?
go to tran former,
build the cube
right click on the cube and open properties
go to drill through tab and select your report from that browse option
14. What is Zero-foot print?
What are the other methods working as deployment functionality?
Cognos offers Portal Services that allow organizations to easily manage and display Cognos business intelligence, planning, and scorecarding in your existing enterprise information portals. Including Cognos reports, analysis, dashboards, scorecards, and other capabilities drives higher returns in your information and portal investments.
Cognos portals offer:
Zero Footprint: Cognos portals have no footprint on the user's desktop. Anyone inside or outside the organization with a Web browser can access and interact with content.
Intuitive User Interface: No special training is required to use the portal. Standard browser interface actions-such as following hypertext links, copying, and pasting-allow users to access and organize business intelligence content quickly and easily
15. What is difference between PAGE BREAK and Section Report?
What is Main Advantage Datawarehousing over Oracle?
Section-section is eliminate the duplicate recod.but report looking separate bluck.
setpagebreak means to display the reports in onepage. eg. suppose u create a list report ordermethod,orderyear,revenu
when u create section on ordermethod.it will eliminate the duplicate record.but when u apply the set pagebreakc.report display in onepage.like fax reports in onepage,email reports in another page.this in cognos 8 querystudio.
16. Give me any example of semi and non additive measures?
Semi-Additive: Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table, but not the others. Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table. Current Balance and Profit Margin are the facts.Current Balance is a semi-additive fact, as it makes sense to add them up for all accounts (what's the total current balance for all accounts in the bank?), but it does not make sense to add them up through time (adding up all current balances for a given account for each day of the month does not give us any useful information). Profit Margin is a non-additive fact, for it does not make sense to add them up for the account level or the day level.
17. What is drill down and slicing and dicing whats the difference between them?
Drilling lets you quickly move from one level of detail to another to explore different aspects of your business. Drilling down moves you down in the hierarchy; drilling up moves you up in the hierarchy.
Slicing and Dicing
While you can drill to look at information at any level, you can slice and dice to select the exact information you want in your report.
18. What is the difference between a cascading report and drillthru report?why do we go for drill thru report?
Cascading report works based on the condition but drill thru work based on the data item what we select as a drill thru options
19. What is meant by Junk Dimension?
The junk dimension is simply a structure that provides a convenient place to store the junk attributes
20. What is Cognos Powerhouse and what is it used for?
Cognos Powerhouse is High-Productivity Application Development Solutions equips you with high-productivity development environments for creating your data-driven business solutions faster,whether for Web-based, client/server, or traditional terminal-based access. PowerHouse has gained a worldwide reputation for productivity, reliability, performance, and flexibility.
21. What is Cognos Reporting tool?
Cognos is a Reporting tool from IBM which helps in reporting and analysis of various data from a data warehouse.
22. What is Cognos Connection?
It is a Web portal for Cognos 8 and a component which interracts with the Content Store. It is a frontend to publish, find, manage, organize, and view organization’s business intelligence data.
23. What is Report item?
Report item is nothing but a query item when it is drag and drop into the work area.
24. What is Cardinality?
Cardinality is nothing but relation between tables.
One to One > One to Many > Many to Many > Many to One
25. What is data mining?
Data mining is a process of extracting hidden trends within a data warehouse.
26. What are the types of prompt in Cognos?
Value prompt ,Text Prompt, Date prompt, Time prompt, Date and time prompt
27. What is Drill Through?
Drill-through reporting allows you to link from one report to another. You can drill through in a number of ways. > A Drill Through id developed with two reports.
1. Parent Report > 2. Child Report.
28. What are the components of Report Net?
Framework manager ,Cognos connection, Query Studio, Report Studio
29. What is difference between content store and content manager?
A content store is a data base which stores the meta data of the reports.
But where as a content manager is a service which is available in dispatcher. which it manages the security.
30. What is OLAP?
OLAP stands for On Line Analytical Processing, a series of protocols used mainly for business reporting.
31. What are components of report studio?
Insertable Objects pane > Properties pane > Explorer bar >Report Viewer
32. What is Snap Shot?
snapshot is a static datasource it is a picture of of report once u created a snapshot report u can't add a data item.
33. How do you define a cube?
Its a multidimensional view of dimension and measures. It is used to analyze the data in various aspects, which is called slicing and dicing.
34. 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.
35. What is cube size?
2.0 GBIt depends on ur project requirements.
36. What is meant by Junk Dimension?
The Junk Dimension also called as garbage dimension.
A junk dimension is a convenient grouping of typically low-cardinality flags and indicators.
37. What is transformer?
Transformer is used for building the Cubes (Multidimensional Structure used for OLAP
38. What is catalog and types of catalogs in cagonos?
A catalog is a file containing the information (Database tables) that Impromptu users need to create reports. > personal > distributed > hared > secured
39. What is Cardinality?
Relationships exist between two query subjects. The cardinality of a relationship is the number of related rows for each of the two query subjects. The rows are related by the expression of the relationship; this expression usually refers to the primary and foreign keys of the underlying tables.
40. How to join multiple db in catalog?
Mutiple database could not be connected in a single catalog. So that we use hotfile for thispurpose.
41. How to generate cubes in cognos?
Power Play Transformer contain dimension,measure,model and cube. we can generate cube different way. > Just right click on cube name and build.
we can write script in unix. using that we can generate cube.
42. What is snapshot?
A Snapshot is the copy of data, when we create a snapshot it copies the exact data that'srelated to the at perticular report, we use snapshot when ever we want to compare reports.(Example :we want to compare this months report with previous months).
43. Define datastores in Cognos?
Data sources, also known as query databases, are relational databases, dimensionalcubes, files, or other physical data stores that can be accessed through IBM Cognos8. Application Tier Components use data source connections to access data sources.
44. What is metric store database?
A metric store database is a special case of a query database. A metric storedatabase is used to store the information associated with metrics that appear inscorecards, including targets performance metrics , thresholds , embership in sorecards
links to related reports.
45. What is difference between view and materialized view?
Views contains query whenever execute views it has read from base table Where as M views loading or replicated takes place only once which gives you better query performance.
46. What is difference between data mart and data warehouse?
A data mart designed for a particular line of business, such as sales, marketing, or finance.
Where as data warehouse is enterprise-wide/organizational
The data flow of data warehouse depending on the approach.
47. What is DTM?
DTM transform data received from reader buffer and its moves transformation to transformation on row by row basis and it uses transformation caches when necessary.
48. What are the different uses of a repository manager?
Repository manager used to create repository which contains metadata the informatica uses to transform data from source to target. And also it use to create informatica user’s and folders and copy, backup and restore the repository.
49. What is a folder?
Folder contains repository objects such as sources, targets, mappings, transformation which are helps logically organize our data warehouse.
50. Explain Informatica Architecture?
Informatica consist of client and server. Client tools such as Repository manager, Designer, Server manager. Repository data base contains metadata it read by informatica server used read data from source, transforming and loading into target.
Cognos 6.6 7.0,7.3(PowerPlay, Impromptu)--ReportNet1.0,1.1mr1, 1.1mr22---ReportNet 8.0(latest)IWR is use by Impromptu to publish reports, PPES is used by PP, Cognos Connection is used by repornet. there are many other tools but these are the main.
2. How can i test reports in cagonos?
In cognos report net by the validate report option a report can be tested. If there will be any error, it will specify the 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 .
3. How can i schedule reports in cognos?
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.
4. How can create users and permissions in cognos?
in impromptu menu go to Catlog->User profiles -> userclass tab -> click on Creator ->u can give there folder access,table access,filters,Governor etc
you can crate users by using USERS PROFILE option......and you can give permissions using ROLE IN C8 and GOVERNERS in C7
5. What is Cognos Visualizer and Cognos Scripting?
Visualizer is a representation of data cubes in a dashboard format. We can drill through to the ground level of a hierarchy as like in power play report but cannot add or remove fields dynamically.
Cognos script editor : We can write cognos macros or programs in this tool and can fine tune or process some execution .
6. What is catalog and types of catalogs in cagonos and which 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.
7. How do add dynamic titles in PP?
PowerplayFrom format menu-->title, header & footer-->title-->insert report filename
8. What you mean by Drill across and what is the difference between drill through, drill across?
Drill across means when you are moving from one report to another report like country in one report and States in another Report whereas if the report is using same report from moving from country to state. In other when you are moving details level if you are using the different report it is drill across and if you are using same report it is drill through.
9. What is loop in frameworkmanager?
Loop: loop is a closed path (relation) that exists among 3 (or) more tables. For example, if we have '3' tables T1, T2, T3 then, a loop exists among these tables only when we create joins in the following fashion:
Loop: T1 ---> T2 ---> T3 ---> T1
To resolve the above problem, we have to create a shortcut (or) Alias to the Table T1.
No Loop: T1 ---> T2 ---> T3 ---> Alias (or) Shortcut of T1
10. How create measures and Demensions?
You can create measure once you import all the data into the data source.You can create measures and dimensions by draging the required source from datasource into dimension map and measure tab.(need to find scope of measures for all the dimensions)
50 Latest Cognos Interview Questions with Answers pdf
11. what is meant by alternate drill down with ex?Alternate drill down path means there will be two path to opt.For example- We will have time dimension now the client requirement is they want two type of year -one is calender year(Jan-Dec) and another is fiscal year(Apr-Mar).
12. What is the difference between enterprise data warehouse and data warehouse?
Big Organizations have a lot of diversified sources of data.There might be a dataware house exclusively for transport and others for data related to the project the company runs.In such case the complete enterprise's(company's) date ware house is a big combination of all and is known the Enterprise data Warehouse(EDW)
13. How you drill from powerPLay to Impromptu? Explain all Steps?
go to tran former,
build the cube
right click on the cube and open properties
go to drill through tab and select your report from that browse option
14. What is Zero-foot print?
What are the other methods working as deployment functionality?
Cognos offers Portal Services that allow organizations to easily manage and display Cognos business intelligence, planning, and scorecarding in your existing enterprise information portals. Including Cognos reports, analysis, dashboards, scorecards, and other capabilities drives higher returns in your information and portal investments.
Cognos portals offer:
Zero Footprint: Cognos portals have no footprint on the user's desktop. Anyone inside or outside the organization with a Web browser can access and interact with content.
Intuitive User Interface: No special training is required to use the portal. Standard browser interface actions-such as following hypertext links, copying, and pasting-allow users to access and organize business intelligence content quickly and easily
15. What is difference between PAGE BREAK and Section Report?
What is Main Advantage Datawarehousing over Oracle?
Section-section is eliminate the duplicate recod.but report looking separate bluck.
setpagebreak means to display the reports in onepage. eg. suppose u create a list report ordermethod,orderyear,revenu
when u create section on ordermethod.it will eliminate the duplicate record.but when u apply the set pagebreakc.report display in onepage.like fax reports in onepage,email reports in another page.this in cognos 8 querystudio.
16. Give me any example of semi and non additive measures?
Semi-Additive: Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table, but not the others. Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table. Current Balance and Profit Margin are the facts.Current Balance is a semi-additive fact, as it makes sense to add them up for all accounts (what's the total current balance for all accounts in the bank?), but it does not make sense to add them up through time (adding up all current balances for a given account for each day of the month does not give us any useful information). Profit Margin is a non-additive fact, for it does not make sense to add them up for the account level or the day level.
17. What is drill down and slicing and dicing whats the difference between them?
Drilling lets you quickly move from one level of detail to another to explore different aspects of your business. Drilling down moves you down in the hierarchy; drilling up moves you up in the hierarchy.
Slicing and Dicing
While you can drill to look at information at any level, you can slice and dice to select the exact information you want in your report.
18. What is the difference between a cascading report and drillthru report?why do we go for drill thru report?
Cascading report works based on the condition but drill thru work based on the data item what we select as a drill thru options
19. What is meant by Junk Dimension?
The junk dimension is simply a structure that provides a convenient place to store the junk attributes
20. What is Cognos Powerhouse and what is it used for?
Cognos Powerhouse is High-Productivity Application Development Solutions equips you with high-productivity development environments for creating your data-driven business solutions faster,whether for Web-based, client/server, or traditional terminal-based access. PowerHouse has gained a worldwide reputation for productivity, reliability, performance, and flexibility.
21. What is Cognos Reporting tool?
Cognos is a Reporting tool from IBM which helps in reporting and analysis of various data from a data warehouse.
22. What is Cognos Connection?
It is a Web portal for Cognos 8 and a component which interracts with the Content Store. It is a frontend to publish, find, manage, organize, and view organization’s business intelligence data.
23. What is Report item?
Report item is nothing but a query item when it is drag and drop into the work area.
24. What is Cardinality?
Cardinality is nothing but relation between tables.
One to One > One to Many > Many to Many > Many to One
25. What is data mining?
Data mining is a process of extracting hidden trends within a data warehouse.
26. What are the types of prompt in Cognos?
Value prompt ,Text Prompt, Date prompt, Time prompt, Date and time prompt
27. What is Drill Through?
Drill-through reporting allows you to link from one report to another. You can drill through in a number of ways. > A Drill Through id developed with two reports.
1. Parent Report > 2. Child Report.
28. What are the components of Report Net?
Framework manager ,Cognos connection, Query Studio, Report Studio
29. What is difference between content store and content manager?
A content store is a data base which stores the meta data of the reports.
But where as a content manager is a service which is available in dispatcher. which it manages the security.
30. What is OLAP?
OLAP stands for On Line Analytical Processing, a series of protocols used mainly for business reporting.
31. What are components of report studio?
Insertable Objects pane > Properties pane > Explorer bar >Report Viewer
32. What is Snap Shot?
snapshot is a static datasource it is a picture of of report once u created a snapshot report u can't add a data item.
33. How do you define a cube?
Its a multidimensional view of dimension and measures. It is used to analyze the data in various aspects, which is called slicing and dicing.
34. 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.
35. What is cube size?
2.0 GBIt depends on ur project requirements.
36. What is meant by Junk Dimension?
The Junk Dimension also called as garbage dimension.
A junk dimension is a convenient grouping of typically low-cardinality flags and indicators.
37. What is transformer?
Transformer is used for building the Cubes (Multidimensional Structure used for OLAP
38. What is catalog and types of catalogs in cagonos?
A catalog is a file containing the information (Database tables) that Impromptu users need to create reports. > personal > distributed > hared > secured
39. What is Cardinality?
Relationships exist between two query subjects. The cardinality of a relationship is the number of related rows for each of the two query subjects. The rows are related by the expression of the relationship; this expression usually refers to the primary and foreign keys of the underlying tables.
40. How to join multiple db in catalog?
Mutiple database could not be connected in a single catalog. So that we use hotfile for thispurpose.
41. How to generate cubes in cognos?
Power Play Transformer contain dimension,measure,model and cube. we can generate cube different way. > Just right click on cube name and build.
we can write script in unix. using that we can generate cube.
42. What is snapshot?
A Snapshot is the copy of data, when we create a snapshot it copies the exact data that'srelated to the at perticular report, we use snapshot when ever we want to compare reports.(Example :we want to compare this months report with previous months).
43. Define datastores in Cognos?
Data sources, also known as query databases, are relational databases, dimensionalcubes, files, or other physical data stores that can be accessed through IBM Cognos8. Application Tier Components use data source connections to access data sources.
44. What is metric store database?
A metric store database is a special case of a query database. A metric storedatabase is used to store the information associated with metrics that appear inscorecards, including targets performance metrics , thresholds , embership in sorecards
links to related reports.
45. What is difference between view and materialized view?
Views contains query whenever execute views it has read from base table Where as M views loading or replicated takes place only once which gives you better query performance.
46. What is difference between data mart and data warehouse?
A data mart designed for a particular line of business, such as sales, marketing, or finance.
Where as data warehouse is enterprise-wide/organizational
The data flow of data warehouse depending on the approach.
47. What is DTM?
DTM transform data received from reader buffer and its moves transformation to transformation on row by row basis and it uses transformation caches when necessary.
48. What are the different uses of a repository manager?
Repository manager used to create repository which contains metadata the informatica uses to transform data from source to target. And also it use to create informatica user’s and folders and copy, backup and restore the repository.
49. What is a folder?
Folder contains repository objects such as sources, targets, mappings, transformation which are helps logically organize our data warehouse.
50. Explain Informatica Architecture?
Informatica consist of client and server. Client tools such as Repository manager, Designer, Server manager. Repository data base contains metadata it read by informatica server used read data from source, transforming and loading into target.
No comments:
Post a Comment