How to give Scope relationship between a measure and Dimension?
Click on the "Dimension Map".
Click on the measue for which you want to set the scope. (You can see the Measures and Attributes tabs on the right side.)
Right Click on the dimension(top level) and select "Remove Scope".
I have a measure dimension P&L Bookings and dimension Bookings Now I want to have relationships between these two.
I have Couple of Questions on this...
1) Do I need to have to include the keys in P&L Bookings of Bookings Dimension?
2) How to give the Scope between this DImesion and Measure??
hi
You will have a query subject with the dimensional attributes and fact columns, Create a model query subject extracting only fact columns and convert this to measure dimension. (Click on the newly created model query subject and select Actions - > Convert to Measure Dimension).
Now u can see the L symbol to the newly created query subject. You can also see this in "Measures" tab on right hand side. U can select the level of the dimension which contains "All" and then set scope.