set scope level in transformer
- 2 Answers
- 10607 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vsandhyana
To create the relationship between fact and dimension you
need to have calendar_date also in your fact table and than
only you can make the relationship with that.
| Is This Answer Correct ? | 1 Yes | 0 No |
Where do i get Cognos 10 BI Online Training in Low price for the below tools. Cognos Framework Manager Cognos Report Studio Cognos Query Studio Cognos Analysis Studio Cognos Event Studio Cognos Transformer Cognos TM1 Development
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
2. What functional area you worked on.
How can we do the unit testing?
how u create cubes in ur project
Difference betwween cognos report net architecture and cognos8 architecture
How will u execute a stored procedute from a reportstudio
What are initial page components of Cognos connection?
For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?
hi, i am Having 2 Reports one list report,one crosstab report if i put 2 querys for 2 reports which query will execute first?if i put same query for both 2 which report i will Get?pls pls pls Explain me...
wat is called Model dimension?
what is the use of layout component reference
Teradata 
