Different rules for same element in different hierarchies

Post Reply
luizg2019
Posts: 9
Joined: Thu Sep 12, 2019 11:02 pm
OLAP Product: TM1 - PAW & Architect
Version: 2.0.7
Excel Version: office 2016

Different rules for same element in different hierarchies

Post by luizg2019 » Thu Oct 03, 2019 8:22 pm

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: 3748
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Different rules for same element in different hierarchies

Post by jim wood » Fri Oct 04, 2019 10:47 am

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

User avatar
Steve Rowe
Site Admin
Posts: 1962
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Different rules for same element in different hierarchies

Post by Steve Rowe » 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.

User avatar
jim wood
Site Admin
Posts: 3748
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Different rules for same element in different hierarchies

Post by jim wood » Fri Oct 04, 2019 1:14 pm

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

User avatar
Steve Rowe
Site Admin
Posts: 1962
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Different rules for same element in different hierarchies

Post by Steve Rowe » Fri Oct 04, 2019 3:26 pm

:lol: My golden rule, never answer a forum post before two cups of coffee!

Wim Gielis
MVP
Posts: 2259
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Different rules for same element in different hierarchies

Post by Wim Gielis » 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:
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

User avatar
jim wood
Site Admin
Posts: 3748
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Different rules for same element in different hierarchies

Post by jim wood » Mon Oct 07, 2019 12:00 pm

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

Post Reply