Interested to Buy Any Domain ? << Click Here >> for more details...
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
How can create users and permissions in cognos?
What do you understand by the term 'dynamic cube'?
What are the different uses of a repository manager?
How is cognos model organization works?
What is the difference between a data mart and a data warehouse?
What is cognos reporting tool?
What are all the different types of prompt in cognos?
Give the advantages of cognos?
What are the advantages 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
faq's on cognos
What are all the types of indexes in Cognos?
What do you understand by the term 'aggregate advisor?'
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
What is main difference mapplets and mapping?
