set scope level in transformer

Question Posted / phanicrn

2 Answers
11901 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

set scope level in transformer..

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

set scope level in transformer..

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

Post New Answer

More Cognos Interview Questions

What is stitched Query?

5 Answers

Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

1 Answers

can any one explain about blue prints&performance tuning in cognos?

1 Answers TCS,

wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container

0 Answers

what are versions of cognos from starting release to latest in the market?

4 Answers IBM,

my cient has reports in java and the dw mart is there already, whether you will suggest for Cognos reports ?

1 Answers IBM,

What is the difference between the content store and content manager?

1 Answers

What are the themes in a data warehouse?

1 Answers

How to apply securities for reports in cognos connection?

1 Answers TCS,

wat is called Model dimension?