Interested to Buy Any Domain ? << Click Here >> for more details...
set scope level in transformer
- 2 Answers
- 11826 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 |
what is cardinality that you can give to employee and department query subjects in framework manager?
How can we create a dynamic column name in cognos?
-------------What is a Conformed Dimension?
What is Parametermap?
what is report burn and where it occurs
Hi, I am Searching on Cognos 10, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is asimcognos10@gmail.com. Hope you will help....
What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?
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?
What are the components used in web tier?
how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
How do we drill through from a powerplay cube to reportnet?\
Teradata 
