TM1 rule error

[charan]

Hi I tried to write a rule like,
[target]=N:DB(cubename,dim1,dim2...dim7)*DB(cubename,dim1,dim2...dim11)*DB(cubename,dim1,dim2..dim11)\100;
My request is how make a particular dimension dynamice in the DB function instead of hardcoding.
please suggest me.
Is the error comes for mismatching of dimensions. In this case how to make non matching dimensions dynamic.
Please find the attachment for the error message.


TM1 9.5.2
Excel 2007.

Thank you

[charan]

My exact question is in the rule for a dimension where I am getting error like "invalid synstax error" if i select single element in this particular dimension then I am not getting this error but it is hardcoding, please help me how to make this rule dynamic.



Thank you.

[MSidat]

Charan,

Am I correct in assuming you are having issues with matching on the Cross Product Category Dimension?

If so does this dimension exist in your target cube i.e. the cube where you are writing the rule?

If it does not exists what is the link between your target cube and this dimension

[tomok]

You have 130+ posts on this forum and you still haven't learned that if you ask for help, especially if you are showing error messages, you need to provide specific examples? Your error message and the example you have given ARE NOT THE SAME!!!!!!

[charan]

Hi Tomok,
It is confendintial, and more over I am alone working on TM1 and not much experience on it. This forum is like GOD for me.

Hi Sidat,

No the dimension is not existing in the target cube.

The target value is multiplication of three different cubes as I have posted. Therer are different dimensions from the source where it is not available in target cube.

The link to the cube is target value is price of a product. This products are avaialable in diffrent dimensions in different cubes. To get the price value for the combinations of diffrenent product selection I am multiplying those cubes.

Thank you

[Alan Kirk]

Hi Tomok,
It is confendintial, and more over I am alone working on TM1 and not much experience on it.

Nobody needs to see the data, but it's impossible to diagnose an error message like that without knowing:
- The structures of the cubes involved (that is, the list of dimensions); and
- The exact rule syntax.

If rules refer to specific elements, it may be necessary to know the structure of the dimensions as well.

Otherwise it's just random guessing.

[charan]

Alan,
thank you.
Please find the attachment for the dimension list with the cube names.

[charan]

Any suggestions please.

[Michel Zijlema]

Any suggestions please.

The error is probably generated because you make a !dim type of reference to a dimension that is not part of the destination cube. You can use this type of reference only for the dimensions that are part of the destination cube (which makes sense if you think about it). For all dimensions referenced that are not part of the destination cube you need to come up with "somethinge else", depending on your exact requirements. This could be selecting a single element in these dimensions or use attributes or mapping cubes to derive the required selections.

Michel