How many fact tables and dimension tables in your project?

Answer Posted / c h i t t i

Depend on project, for ex. mostly fact tables 1 or 2 and
dimensional tables infinity.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you explain model durability?

691


Which studio is used to create reports?

703


What are the other methods working as deployment functionality?

608


Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

1684


3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

2229






What do you understand by user class in cognos?

612


What do you mean by query studio?

605


I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

1800


What is a Pivot?

624


How create measures and demensions?

711


Define query items?

678


Define dimensions?

706


Explain the difference between native sql and cognos sql?

594


How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

1627


Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

1761