RULE LINE ERROR [] = S:

Post Reply
bogdan
Posts: 18
Joined: Wed Oct 15, 2014 9:33 am
OLAP Product: Cognos
Version: 10.2
Excel Version: 2013

RULE LINE ERROR [] = S:

Post by bogdan »

Hello!
I have a dimension in which both text and numeric elements. I need for all text to execute the rule which will be the first.

Code: Select all

[] = S: IF(!Version @<> 'New', CONTINUE, STET);
But then writes the error in the trace on the consolidated elements "RULE LINE ERROR"
Tell me how to solve the problem? Thank you
User avatar
jim wood
Site Admin
Posts: 3958
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: RULE LINE ERROR [] = S:

Post by jim wood »

You might want to put an level test in there. Then it wil not try to apply this to consolidated levels. Hint: ElLev.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: RULE LINE ERROR [] = S:

Post by David Usherwood »

I was thinking of DTYPE - one of the lesser-used functions, but seems to fit the bill here.
Willi
Regular Participant
Posts: 151
Joined: Mon Oct 07, 2013 11:51 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2010

Re: RULE LINE ERROR [] = S:

Post by Willi »

DTYPE is my first guess as well
User avatar
jim wood
Site Admin
Posts: 3958
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: RULE LINE ERROR [] = S:

Post by jim wood »

I was thinking of DType as well at first, but as this is a string rule, surely it will only apply to string elements at the N: level? S: rules however also apply to consolidated elements as well, hence my reason for ElLev. Thoughts??
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
jim wood
Site Admin
Posts: 3958
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: RULE LINE ERROR [] = S:

Post by jim wood »

Possibly combine the 2???
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: RULE LINE ERROR [] = S:

Post by Duncan P »

Try

Code: Select all

[] = S: IF('New' @<> !Version, CONTINUE, STET);
Post Reply