-----------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
Write types of folders present in cognos?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
Can you define a datastore in cognos?
What do you mean by drill through report?
What is the function of model design accelerator?
Name the types of report?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
what is the role of cognos comsultant?what actually it means?pls reply
What actually a project contains?
Which studio is used to create reports?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
Write some methods to apply securities in framework manager model?
i was asked what are the caluclations done by you in your report? plz give reply
What you mean by drill across and what is the difference between drill through, drill across?
What are the services provided in cognos 8?