-----------Types of Fact Tables?
Answer Posted / tanveer ahmed
There are two types of Fact Tables namely :
1) Cummulative Fact Table : Facts collected over a period
of time are called CFT.
2) Snapshot Fact Table: Facts collected at adhoc basis are
called SFT.
Is This Answer Correct ? | 30 Yes | 7 No |
Post New Answer View All Answers
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
What is the difference between the standard and metrics folder?
where you can save the report net documentation in our local system?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
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?
what is the main advantage of impromptu over cognos reportnet?
What is a Query Subject?
What is Fullouterjoin?
what is hints in cognos and where we use it.
What do you understand by the term 'dynamic cube'?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
What is main difference mapplets and mapping?
Explain the characteristics of cognos?
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
--------------Diff b/w ODS and OLAP?