-----------Types of Fact Tables?
Answer Posted / suresh
Fact tables have 4 types:
1)Additive Fact table
which can be summed ex:Sales,we can summed sales amount
2)Non-Additive fact table
which can not be summed ex:
3)Semi Additive fact table
That can be summed up for some of the
dimensions and not others.
EX:
4)Fact less fact table:which does not contain measures.
ex:student :faculty,year,course details..there is no measures
Is This Answer Correct ? | 8 Yes | 8 No |
Post New Answer View All Answers
Can you define cube?
What is the difference between the standard and metrics folder?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
what is log in cognos?
Define the cognos reporting tool?
How is cognos model organization works?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
--------------Diff b/w ODS and OLAP?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
What is the importance of having monitor service in cognos?
Explain about scorecarding?
What is cognos powerhouse?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
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?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks