Wednesday, January 7, 2009

Cognos PowerPlay QnA

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

No comments: