Ambiguous error

Post Reply
Yukiya
Posts: 22
Joined: Wed Jun 30, 2010 3:53 am
OLAP Product: TM1
Version: 102
Excel Version: 2010

Ambiguous error

Post by Yukiya »

Hello,

I could not save a rule due to ambiguous. It has some dimensions (for example, year and staff code, location, etc.), and year and staff code have same element. When I tried to save a rule on Rules Editor with year, TM1 warned as ambiguous of both of SKIPCHECK and FEEDERS - element of year and staff code is 2010.

So, could you kindly tell me how to set a rule with specific dimension.

Thanks and Best Regards,
Yukiya
User avatar
rkaif
Community Contributor
Posts: 328
Joined: Fri Sep 05, 2008 6:58 pm
OLAP Product: IBM Cognos TM1
Version: 9.1 or later
Excel Version: 2003 or later

Re: Ambiguous error

Post by rkaif »

In your rules, you need to mention the element name as per this syntax:

Code: Select all

Dimension_Name:Element_Name
So it would be [Year:'2010'] or [Staff_Code:'2010'] in your case.
Cheers!
Rizwan Kaif
Yukiya
Posts: 22
Joined: Wed Jun 30, 2010 3:53 am
OLAP Product: TM1
Version: 102
Excel Version: 2010

Re: Ambiguous error

Post by Yukiya »

Dear Rizwan,

Thank you for your great advice.
I could setup a rule.

Yukiya :D
jstrygner
MVP
Posts: 195
Joined: Wed Jul 22, 2009 10:35 pm
OLAP Product: TM1
Version: 9.5.2 FP3
Excel Version: 2010

Re: Ambiguous error

Post by jstrygner »

One more thing, if your dimension has a space in its name (TM1 allows it, but some of us have best practice not to put them there) you must also put it into apostrophes:
['Dimension with spaces':'Element with or without_them_it_just_does_not_matter'].
Post Reply