Disambiguation in Multiple-Element Rule Not Possible

Post Reply
image2x
Posts: 125
Joined: Tue Jun 02, 2009 7:05 pm
OLAP Product: TM1, PAX, PAW, SPSS
Version: 2.0.916.10 on RHEL
Excel Version: 2016
Location: Minneapolis, MN

Disambiguation in Multiple-Element Rule Not Possible

Post by image2x »

Came accross this today when trying to use dimensional qualification (i.e. 'dim':'account'') inside a multiple-element group (i.e {'elmnt1,'elmnt2', 'etc'} ) on the left side of a rule.

This will error when saving with "Element Not Found":
[ { 'Account':'Sales' } ] = n: 1000;

This will error when saving with "Missing Right Brace":
[ { 'Units', 'Account':'Sales'} ] = n: 1000;

Either should work. 9.5.2 FP1 on AIX.

-- John
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Disambigation in Multiple-Element Rule Not Possible

Post by rmackenzie »

You are using the wrong syntax.

The correct syntax would be:

Code: Select all

[ 'Account':{'Sales' } ] = n: 1000;
Actually you don't need the { and } for a single element. The other statement should be:

Code: Select all

[ 'Units', 'Account':{'Sales'} ] = n: 1000;
Once again, you don't need the { or }.

This should work fine:

Code: Select all

['dim1':{'elem1','elem2'},'dim2':{'elemA','elemB'}]=N:100;
Etc etc.

Mods - this shouldn't be in the bug sub-forum.
Robin Mackenzie
image2x
Posts: 125
Joined: Tue Jun 02, 2009 7:05 pm
OLAP Product: TM1, PAX, PAW, SPSS
Version: 2.0.916.10 on RHEL
Excel Version: 2016
Location: Minneapolis, MN

Re: Disambigation in Multiple-Element Rule Not Possible

Post by image2x »

rmackenzie wrote:Your using the wrong syntax. The correct syntax would be:
Ahh-hah.... I don't recall that one being in the documentation (though I haven't read it since 9.4).
rmackenzie wrote:Mods - this shouldn't be in the bug sub-forum.
Yes, please move. Thanks.
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Disambiguation in Multiple-Element Rule Not Possible

Post by rmackenzie »

image2x wrote:I don't recall that one being in the documentation
Wouldn't be the first time :)
Robin Mackenzie
Post Reply