Different rules for same element in different hierarchies

Post Reply
luizg2019
Posts: 41
Joined: Thu Sep 12, 2019 11:02 pm
OLAP Product: TM1 - PAX-PAW-Perspectiv-Arc
Version: PA 2.0.9 - PAW 2.0.73
Excel Version: office 2016

Different rules for same element in different hierarchies

Post by luizg2019 »

Hi!

I'm having trouble with rules for same element in different hierarchies.

I have two hierarchies: 'Plano de Contas' (default hierarchy) and 'DRE1' which was created by me.

These are the rules:
['Plano de Contas':'Plano de Contas':'1110290002'] = DB('GBL_PC', !Centros de Custo, !Versões, !Anos, !Meses, !Moedas, 'Plano de Contas':'111019');
['Plano de Contas':'DRE1':'1110290002'] = DB('GBL_PC', !Centros de Custo, !Versões, !Anos, !Meses, !Moedas, 'DRE1':'111019');

Instead of each hierarchy having separated rules, the rule is bringing the value from the default hierarchy to both hierarchies.
I tried using [] for the right side instead of a DB but I got the same result.

Here is the default hierarchy:
Image

And this is the other hierarchy:
Image


Does anyone know what is wrong? Any help is appreciated.
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: Different rules for same element in different hierarchies

Post by jim wood »

C level rule, if statements and elisanc. That's the way I'd go about it.
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
Steve Rowe
Site Admin
Posts: 2456
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Different rules for same element in different hierarchies

Post by Steve Rowe »

I don't think what you want to do is possible, the N level of a cube is common for all hierarchies.

C levels are different, same named C level members in different hierarchies are distinct members.
Technical Director
www.infocat.co.uk
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: Different rules for same element in different hierarchies

Post by jim wood »

Steve Rowe wrote: Fri Oct 04, 2019 12:52 pm I don't think what you want to do is possible, the N level of a cube is common for all hierarchies.

C levels are different, same named C level members in different hierarchies are distinct members.
The moral of that story is don't try and answer questions at 6.30 in the morning. :oops: You are of course right Steve. The only alternative would be to have 2 elements of similar name in the 2 different hierarchies, after all if they need different values they are not the same thing. What I said would still apply but to only elements of level 1 or greater,

Jim.
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
Steve Rowe
Site Admin
Posts: 2456
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Different rules for same element in different hierarchies

Post by Steve Rowe »

:lol: My golden rule, never answer a forum post before two cups of coffee!
Technical Director
www.infocat.co.uk
Wim Gielis
MVP
Posts: 3234
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: Different rules for same element in different hierarchies

Post by Wim Gielis »

Steve Rowe wrote: Fri Oct 04, 2019 3:26 pm :lol: My golden rule, never answer a forum post before two cups of coffee!
Well, goodbye then.
I hate coffee and will never drink it.
Even if it means leaving the forum :lol:
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
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: Different rules for same element in different hierarchies

Post by jim wood »

Wim Gielis wrote: Fri Oct 04, 2019 9:26 pm
Steve Rowe wrote: Fri Oct 04, 2019 3:26 pm :lol: My golden rule, never answer a forum post before two cups of coffee!
Well, goodbye then.
I hate coffee and will never drink it.
Even if it means leaving the forum :lol:
I can't stand it either. That may be the reason why my answers make no sense?
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
Post Reply