Interested to Buy Any Domain ? << Click Here >> for more details...
set scope level in transformer
- 2 Answers
- 11689 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 do you test the performance of a report?
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?
What is an open session command in cognos connection?what is it meant for?
How can you create prompts in framework manager?
Define dimensions?
What is a Folder?
What is Online View?
suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?
how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.
how can i provide security to my reports in report studio?
Explain what is the difference between native sql and cognos sql?
Teradata 
