Sunday, April 11, 2010

1. How to build a cube in Cognos 8 using Framework Manger?

2. Master detailed relationship?

3. Fact less fact table?

4. How to evaluate the cube?

5. what are the different performance tuning techniques of a cognos cube?

6. what is the difference between the render variable and the style variable?

7. Framework Manager ?

8. Query Studio ?

9. what is the difference between a cascading report and drillthru report?why do we go for drill thru what is the difference between a cascading report and drillthru report?why do we go for drill thru report?

10. How can I create a dynamic column name in Cognos

11. Import two data sources to Framework Manager in Cognos

12. What is object security in framework manager?

13. Cognos Decision Stream

14. Materialized view

15. Performance tuning in model and report level

16. Static Choice

17. what are complex reports?

18. What is the difference between parameter and variable in report studio

19. how to configure content store in Cognos?

20.What is level span? How it is used in Cognos? what is the main advantage of level span.

21. cognos improve report performance

22. What different kinds of SQL you can write at the report level What is tabular SQL,Tabular Modal and Tabular Set

23. Cognos Model

24. What is usage property?

25. How to show the data reported horizontally? For example, employee skill1 a1 b1 c2 d2 e2 fReport result:1 abc2 def

26. How to combine two crosstab reports in to single crosstab report?


27. How do you handle this DB Schema changes in our Framework manager to update automatically our meta How do you handle this DB Schema changes in our Framework manager to update automatically our meta data

28. How to create Cube from Power play transformer by using SQL Server Database(with out creating IQD file using Cognos Impromptu from SQL Server)


29. what is drill down and slicing and dicing whats the difference between them.


30.what is model and say about process how to create model and how to test model

31. Define Dimensions, measures, Regular dimensions and Measure Dimensions

32. What is data processing?

33. How can we use NVL function/Dataformat to resolve the Blank spaces in our report. Explain with navigation

34. How do you utilize Java Script within Cognos?

35. How do you speed up the report execution even though it has lot of charts.

36. How to pass multiple values from picklist prompt to sub report filter


37. what is spaning of tree

38. How to use Lookup Command?

39. What are the steps involved in migrating CRN enviroment to Cognos 8

40.how can i schedule reports in cognos

41. what is snapshot

42.
What is meant by Junk Dimension?
How do you perfom while running the report?
Where will you see the tWhat is meant by Junk Dimension?How do you perfom while running the report?
Where will you see the time of running report?
Size of the cube?
What are the types of prompts in ReportNet?
What is macro and how it will be work?
What is difference between Cognos and Cognos ReportNet?
How do you create cube in ReportNet?
There are 10 facts are there.How will you connect all?

43. what is incremental refreshing of a cube and how can we do it


44. When You Import data into catalog You have complex columns names. How do you change the Name of those columns?

45. What are the Ways to Import Data into Catalong?(2 ways)


46. What is catalog and types of catalogs in Cognos and which is better

47. what is the difference between cognos 8 and cognos reportnet 1.1mr1,cognos reportnet 1.1mr2?

48. What do you mean by slow dimensions?

49.
1.In middle level project aprox How many Number of Dimension and Facts are exists?
2.In a complex report how much maxm. No. of dimension are exist in a Cube?

50.How to improve Report performance in ReportNet?