Author Topic: How do I set a scope for a new Dimension with a Measure in Transformer?  (Read 2874 times)

Offline naveen10046

  • Full Member
  • ***
  • Join Date: Dec 2009
  • Posts: 34
  • Forum Citizenship: +0/-0
Hi Guys,
How do I set a scope for a new Dimension with a Measure in Transformer?
Step by Step guide appreciated.

Thanks
Naveen

Offline naveen10046

  • Full Member
  • ***
  • Join Date: Dec 2009
  • Posts: 34
  • Forum Citizenship: +0/-0
Continuation....

My New Dimension is coming in Green, where as existing dimensions are coming in Orange.
How to I set Scope for the Green ones?

Offline wyconian

  • Statesman
  • ******
  • Join Date: Mar 2008
  • Posts: 360
  • Forum Citizenship: +25/-0
HI

The dimensions are associated to the measures by name i.e. you need to have a column in the dimension source table that matches a column in the measures source table by name.

If the columns that you think are common have different names in the source tables just rename them so they are the same.

Good luck

Offline naveen10046

  • Full Member
  • ***
  • Join Date: Dec 2009
  • Posts: 34
  • Forum Citizenship: +0/-0
Thank you so much wyconian!

Since I am beginner, I was thinking Scope has to be set manually.
The issue was with the Key columns name were different between the Measure query and Dimension query.
Fixed the issue.

Thank you again for a quick response :)

Naveen

 


       
Twittear