Spread values from string picklist

[tobtm1]

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

[TrevorGoss]

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.

[tobtm1]

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

Thanks for any replies!

[rmackenzie]

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?