TM1 Forum

Posted: **Tue Apr 14, 2015 8:26 am**

Hi gurus,

To simplify, consider the following setup:

Dimensions

Product
Year
Month
Measure

The measuredimensions consists of one picklistelement (string) and one value called volume. If the user set the picklistelement to "Hello" under "2015" and "All Month" (stacked columns) then "Hello" should automatically be populated down to all single Months for that particular year (2015). In other words - spreading a string value. Do I need a rule for this? Any ideas?

Thank you for any replies...

Posted: **Tue Apr 14, 2015 1:00 pm**

Hello,

If you are only using cubes, then yes you would need to use Rules. It sounds as if you have conditions which need to be met, so IF statements would need to be used.

If you are in applications web, you could use a TI which runs after an event, such as the commit event, the TI could populate the cube according to the picklist choice, but if you are only using cubes, then yes, Rules are needed.

Trevor.

Posted: **Thu Apr 16, 2015 12:24 pm**

Thanks for your thoughts but ok, if rules are needed, how should that rule look like? That is my problem...

Thanks for any replies!

Posted: **Thu Apr 16, 2015 1:02 pm**

This is just air-coding so take with a pinch of salt, but something like this might get you going:

Code: Select all

['Volume'] = S:
  IF ( DTYPE ( 'Month', !Month ) @= 'N', 
    DB ( 'YOUR CUBE', !Product, !Year, 'All Months', !Measure ), 
    STET );

What did you try already?

TM1 Forum

Spread values from string picklist

Spread values from string picklist

Re: Spread values from string picklist

Re: Spread values from string picklist

Re: Spread values from string picklist