Scenario to months

[charan]

Hi,
I have tried to write a for cube which different number of dimensions, after writing the rules it is not giving any errors at the same time it is not giving required data from source cube to target cube, in rule I have selected a dimension which is not in source cube but in target cube.
Please find the attached and correct me.

Thanks and regards

TM1 9.5.2
Excel 2007

[jim wood]

Do you have skipcheck enabled? If so have you enabled feed strings? Also have you created feeders for them?

[Steve Rowe]

There seems to be a mismatch in the dimensionality of the cubes.

In source you have a dimension that has elements like Jan-12 but in the Target cube you have no elements with this name and hence the look up is not working.

You probably need to concatenate your month and year in your rule
Instead of !scenario in your rule try !Month | '-' | Subst (!Year ,3,2)

It's pretty easy to write a rule that compiles, unless you understand the rules concept then you'll find it easy to write rules that do nothing too!

Cheers

[tomok]

There are several things wrong here:

1) Target cube has what looks to be a "Version" dimension and source doesn't. In this case you need to hard code which version you want the values to go into in your rule.
2) Source cube appears to have a dimension that is a combination of month abbreviation and two digit year while target cube has separate dimensions of month abbreviation and four digit year. This is going to be very problematic for you. You CAN write a rule to do this using the SUBST function but it appears to be way over your head as far as your skill set is concerned. You should probably re-think this design.
3) I don't see any SKIPCHECK and FEEDERS.

[charan]

Hi Steve,
Thank you, I had got it with your help.
In trying to control year, I am not getting it completely like, i have tried it writing a rule like;

['Customer name','plan']=S:DB('Source_cube',!Dim name,!Dim name,!Month|'-'|substr(!year,3,2),'Customer name');

Here the rule applies for plan whatever the year I select but in my requirement the current year is always Forecast and the next years are Plan.

Please one more suggestion.

Thanks and regards