If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

DMR Modelling

Started by srinu1253, 01 May 2010 12:50:14 PM

Previous topic - Next topic

srinu1253

How to give Scope relationship between a measure and Dimension?

kalyan_y

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".

srinu1253

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??

kalyan_y

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.