Interested to Buy Any Domain ? << Click Here >> for more details...
set scope level in transformer
- 2 Answers
- 11816 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 |
These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?
What are the batches and it’s details?
can reportnet supports cubes???
-----------With out using DrillThrough how to do Reports?
What is Metrics designer?
----------------Diff b/w Dimensional modeling and Relational modeling?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
What actually a project contains?
What is diffence between query calculation and layout calculation?
what is physical layer and presentation layer?
how u provide security in power play transformer???
3 Answers iFlex, ITC Infotech, TCS,
How to apply securities for reports in cognos connection?
Teradata 
