Interested to Buy Any Domain ? << Click Here >> for more details...
set scope level in transformer
- 2 Answers
- 11712 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 cognos connection?
what are the filters in framework manager and report studio?
how to test reports in cognos?
What is the use of content store in cognos?
Diff b/w Crossproduct and Outerjoin?
----------------------Diff b/w MOLAP and ROLAP?
If you need latest cognos certification dumps to get certified in first attempt with 100% score, please e-mail to getmecert@yahoo.com
Explain the different types of views used in cognos.
If anybody need certification dumps like COG-112 COG-122 COG-132 THEN MAIL ME ON kris.bi121@gmail.com.all are latest dumps test taken on july-09
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
What is the difference between regular dimension and derminant?
1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?
Teradata 
