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
What are the advantages of using cognos sql?
what is online view?
How to apply securities for reports in cognos connection?
---------------Describe OLAP Reporting and RDBMS Reporting?
Write types of folders present in cognos?
how to explain health care project and which reports we can create in health care doain?
What do you mean by drill across?
What are the different kinds of panes included in cognos?
hi my name is siraj i want to know cognos queriy language
How to deploy from one server to another server?
How can create users and permissions in cognos?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
What actually a project contains?
-------------What is Coditional Prompting?
What are the types of hierarchies?
