Answer Posted / phanicrn
I have one dimension and one fact
dimension as Calendar(Calendar_Key,
Calendar_year,Calendar_quarter,Calendar_Month,Calendar_Date)
Fact has(Calendar_Key, Account_Balance, Balance, Amount)
In framework manager i joined
Fact.Calendar_Key=Dimension.Calendar_Key
In Transformer Model when i build the time dimension, i
want the time dimension as
Calendar_Year
Calendar_Quarter
Calendar_Month
Calendat_Date. date should be my lowest level and unique
level. now how do i set scope for Calendar_Date level.
When i look at my fact, I have calendar_Key as key column..
If i put Calendar_Key as lowest level in Time dimension,
when i see the scope. it works.bc'z fact as matching column
Calendar_Key. But how do i set for Calendar_Date as lowest
Level, if i set as lowest level, when i see the scope,Fact
has no column refering to dimension.
what should i do ..?
Thanks
Phani
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
-----------------What is Determination Model?
----------------Describe DWH Architecture?
What is a Cube?
how can I test reports in cagnos?
Define cognos report net?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
What is Bitmap Index?
Explain the characteristics of cognos?
what are the names of the reports that you prepared?
Tell me about Dnamic and Static Dashboards?
What are all the types of gateway used in Cognos?
What is meant by alternate drill down with ex?
When we save a report in report studio with what extn it save?
What is cognos reporting tool?