Interested to Buy Any Domain ? << Click Here >> for more details...
set scope level in transformer
- 2 Answers
- 11586 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 |
How to use Cascade Macro in Report studio? Anybody know about Cascade Macro & and the procedure to use?
What is the difference between ‘macro’ and ‘prompt?
When we save a report in report studio with what extn it save?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
What are the different type of securities can we apply in framework manager?
Hi,please suggest me how to creat username while creating a report.
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
How can we Maintain the Cube Security by Category level and Dimension level ?
what r the claims? how many type of claims we face from client side?
Why is auto-regression used in forecasting used on cognos platform?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
what is session parameters? what is use?
Teradata 
