Rules and Subsets

Post Reply
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Rules and Subsets

Post by ioscat »

Hello!
Here is link:
http://www.lead2pass.com/downloadable/d ... le_id/777/
Look at the question 7:
Which of the following examples will apply a rule to a subset of the Month dimension?
A. [{'Jan', 'Feb', 'Mar'\}]
B. ["Jan", "Feb", "Mar"]
C. ['Jan', 'Feb', 'Mar']
D. [('Jan', 'Feb', 'Mar')]
Answer: A
how is it possible? Or am I missing smt?
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Rules and Subsets

Post by Wim Gielis »

Hi

I would go for A, although I do not know what the \ means at the end.
Is it a typo maybe?
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Rules and Subsets

Post by Alan Kirk »

ioscat wrote:Hello!
Here is link:
http://www.lead2pass.com/downloadable/d ... le_id/777/
Look at the question 7:
Which of the following examples will apply a rule to a subset of the Month dimension?
A. [{'Jan', 'Feb', 'Mar'\}]
B. ["Jan", "Feb", "Mar"]
C. ['Jan', 'Feb', 'Mar']
D. [('Jan', 'Feb', 'Mar')]
Answer: A
how is it possible? Or am I missing smt?
It's always been possible to use a subset (which is to say, a collection of some or all of the elements that make up a dimension) in Rules using curly braces, as discussed here. However named subsets are not supported in rules since it would then be impossible to predict what the outcome would be since anyone with admin access (or the ability to run a metadata-altering TI) could easily change (or worse, delete) the named subset definition and cause the values to change for everyone else.

And I agree with Wim, I believe that the backslash is a typo.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Re: Rules and Subsets

Post by ioscat »

Thanks, Wim, Alan.
The only thing that confused me was the backslash. Finally it is placed next to the end square bracket.
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Rules and Subsets

Post by Wim Gielis »

ioscat wrote:Thanks, Wim, Alan.
The only thing that confused me was the backslash. Finally it is placed next to the end square bracket.
In the TM1 Rules Editor, the syntax with backslash evaluates to an error, so I'm certain it must be a typo.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
EvgenyT
Community Contributor
Posts: 324
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: 2016
Location: Sydney, Australia

Re: Rules and Subsets

Post by EvgenyT »

Hi ioscat,

Its definitely a typo, I came across these questions awhile ago.

Regards,

Evgeny
Post Reply