How do I set a scope for a new Dimension with a Measure in Transformer?

[naveen10046]

Hi Guys,
How do I set a scope for a new Dimension with a Measure in Transformer?
Step by Step guide appreciated.

Thanks
Naveen

[naveen10046]

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?

[wyconian]

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

[naveen10046]

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