1. Explain the various interfaces in Transformer?
2. Explain the process of building a modal and cube?
3. Explain the technique for optimizing the cube?
4. What is the difference between fiscal time dimension and calendar dimension?
5. Can we use both calendars, fiscal dimensions in a single model?
6. What are the different data sources used in transformer?
7. What is the difference between dimension and level?
8. How do implement a security in the model?
9. What is a dimension view?
10. What are the extensions of the model?
11. How do you calculate the model size if categories are not generated?
12. What is the difference between incremental update and refresh?
13. What are the different states of rollups?
14. What is a time state rollup?
15. What is regular rollup?
16. How to move the Transformer model in development to production?
17. What is s Special Category?
18. Shall we use drill through from cube to report. Cube to cube is yes where shall we define?
19. Can we generate a user defined level in the model?
20. What is alternate drill down?
21. What is convergence level?
22. How do you define a cube?
Note: Answers will be posted very soon
Wednesday, January 7, 2009
Cognos FM QnA
1) What is the FM and what is significance of FM in Cognos reporting.
2) What are the different types of import source available to create a new model?
3) What does a project contains?
4) What is difference b/w model & package?
5) How many files Framework manager creates while saving project?
6) What is IQD? What is contained in IQD?
7) What is parameter mapping explain with an example.
8) What is the meaning of stitched query?
9) What is namespace?
10) How can we identify ambiguous relation ships in frame work manager?
11) What is the Query subject and types of Query subjects available in FM?
12) How do we provide security in frame work manager for a query subject?
13) How can we generate the cubes in framework manager?
14) What is the cardinality and how do you define the cardinality in FM?
15) What is the Query item in FM?
16) What is the use of governors in Frame Work manager?
17) What is loop in framework manager?
18) How can we improve performance at FM level?
19) How can we set security at FM level?
20) What is the Dimension and how many types of Dimension are available in FM?
2) What are the different types of import source available to create a new model?
3) What does a project contains?
4) What is difference b/w model & package?
5) How many files Framework manager creates while saving project?
6) What is IQD? What is contained in IQD?
7) What is parameter mapping explain with an example.
8) What is the meaning of stitched query?
9) What is namespace?
10) How can we identify ambiguous relation ships in frame work manager?
11) What is the Query subject and types of Query subjects available in FM?
12) How do we provide security in frame work manager for a query subject?
13) How can we generate the cubes in framework manager?
14) What is the cardinality and how do you define the cardinality in FM?
15) What is the Query item in FM?
16) What is the use of governors in Frame Work manager?
17) What is loop in framework manager?
18) How can we improve performance at FM level?
19) How can we set security at FM level?
20) What is the Dimension and how many types of Dimension are available in FM?
Note: New Questions and Answers will be posted very soon
Cognos Reports QnA
1) What are the different types of reports which can be created by Report Net?
2) Can report net connect multiple data source at a time in report creation time?
3) What function should you use to display the value entered or selected by a user in
Response to a prompt?
4) How can we limit the max no of rows retrieved in the report?
5) Difference between filter and condition?
6) What are the advantages of query studio compared to report studio?
7) What are components of reportnet?
8) What is difference between query studio and report studio?
9) How can i create prompts in report net?
10) What is the Crosstab and Graphs in Report Studio?
11) What is the main advantage of impromptu over cognos reportnet?
12) What are the filter and how many types of filters available in reportnet? Explain briefly.
13) Is it possible to convert the repeater to “List” after I convert the List to Repeater?
14) What are the various file formats involved in reportnet?
15) What is the difference between Native SQL and Cognos SQL?
16) How can I test report in reportnet?
17) What are components of report studio?
18) Report Studio allows you to create the data model from a query and thereby skipping Framework Manager. Given that this feature is available, in what scenarios would one want to skip Framework Manager? Is Framework Manager an un-needed overhead?
19) What is the difference between drill through and master-detail reports?
20) What is calculation and how many types of calculations are there?
21) What is the meaning of drill down and drill up in cognos?
22) What is the level span in cognos?
23) What is the Repeater report in Cognos?
24) What is prompt? Types of prompts? Use of prompts? Syntax of prompt?
25) What is cascading prompt?
26) What is the difference between parameter and variable in report studio?
27) What is conditional formatting?
28) What is a drill through report?
29) What is diff. between Master Detail and Drill Through report?
30) What is bursting of Reports?
31) How can we improve performance at report level?
32) How can we set security at report level?
33) How many reports you created so far in your career?
34) What is the complex report you created and explain about it?
35) What is Cognos Connection? Explain about it?
Note: New Questions and Answers will be posted very soon
2) Can report net connect multiple data source at a time in report creation time?
3) What function should you use to display the value entered or selected by a user in
Response to a prompt?
4) How can we limit the max no of rows retrieved in the report?
5) Difference between filter and condition?
6) What are the advantages of query studio compared to report studio?
7) What are components of reportnet?
8) What is difference between query studio and report studio?
9) How can i create prompts in report net?
10) What is the Crosstab and Graphs in Report Studio?
11) What is the main advantage of impromptu over cognos reportnet?
12) What are the filter and how many types of filters available in reportnet? Explain briefly.
13) Is it possible to convert the repeater to “List” after I convert the List to Repeater?
14) What are the various file formats involved in reportnet?
15) What is the difference between Native SQL and Cognos SQL?
16) How can I test report in reportnet?
17) What are components of report studio?
18) Report Studio allows you to create the data model from a query and thereby skipping Framework Manager. Given that this feature is available, in what scenarios would one want to skip Framework Manager? Is Framework Manager an un-needed overhead?
19) What is the difference between drill through and master-detail reports?
20) What is calculation and how many types of calculations are there?
21) What is the meaning of drill down and drill up in cognos?
22) What is the level span in cognos?
23) What is the Repeater report in Cognos?
24) What is prompt? Types of prompts? Use of prompts? Syntax of prompt?
25) What is cascading prompt?
26) What is the difference between parameter and variable in report studio?
27) What is conditional formatting?
28) What is a drill through report?
29) What is diff. between Master Detail and Drill Through report?
30) What is bursting of Reports?
31) How can we improve performance at report level?
32) How can we set security at report level?
33) How many reports you created so far in your career?
34) What is the complex report you created and explain about it?
35) What is Cognos Connection? Explain about it?
Note: New Questions and Answers will be posted very soon
Subscribe to:
Comments (Atom)