TM1 Forum

Hi:

I am very new to TM1 and apologise for the newbie question.

I am creating a cube that needs to pull a measure (in order to perform a calculation at a later stage) say "Commission" from a cube 'Sales.'

Each Cube features several dimensions, however this particular measure resides in the 'Measures' dimension.

DB (cube, element1, element2, element3, elementn);

Given that I only need the Commission measure, would the DB formula just be:

DB ('Sales', !Commission);

or do I need to list all elements present in the cube?

Many thanks in advance

You really should read the documentation, especially the rules guide. When you do you'll see that the DB syntax requires you to list all the dimensions in the cube. Also, the "!" character means "all the elements in the dimension". Commission is not a dimension, it's an element within a dimension. To address an individual element you surround it with apostrophes. Once again, all this is covered in the rules guide.