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
where you can save the report net documentation in our local system?
What is the advantage of using shortcuts?
What are the other methods working as deployment functionality?
What are the batches and it’s details?
Can you define a catalog and types of catalogs in cognos?
what is the role of cognos comsultant?what actually it means?pls reply
What are the types of studio present in Cognos?
What is meant by Reportstudio shortcut?
What is metric store database?
What do you mean by drill through report?
What is a Cube?
Give me any example of semi and non additive measures?
What is a Folder?
Explain the different types of views used in cognos.
---------------Describe OLAP Reporting and RDBMS Reporting?
