Intersection cube calculation in Performance Modeler

Post Reply
msnoriko93
Posts: 2
Joined: Wed Jun 08, 2016 9:37 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: Microsoft Excel 2013

Intersection cube calculation in Performance Modeler

Post by msnoriko93 »

Hello, I'm new to TM1 and still learning little by little.
Anyway, my boss decided to move older application that was made from TM1 to Performance Modeler, and I'm stuck at writing intersection rules.

In TM1, we can write the rules as:
['Dimension1_Element1','Dimension2_Element1']
I was wondering if someone can help me how to write this rules in Performance Modeler.
Thank you in advance,
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: Intersection cube calculation in Performance Modeler

Post by Wim Gielis »

Hello,

I may be missing something but can't you just write rules in PM like in Perspectives / Architect ?
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
qml
MVP
Posts: 1097
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Intersection cube calculation in Performance Modeler

Post by qml »

msnoriko93 wrote:I was wondering if someone can help me how to write this rules in Performance Modeler.
You can create and edit rules in the Model Design pane of Performance Modeler, similarly to how you would do it in Perspectives/Architect.

Rule syntax is unchanged and in your example the correct are definition would be as follows:

Code: Select all

['Dimension1':'Element1','Dimension2':'Element2']
If this does not answer your question then I'm afraid you'll have to rephrase it as it is not entirely clear what you are asking about.

Oh, and last but not least, you can tell your manager that he made a decision to migrate to a technology that is an evolutionary dead end. My suggestion would be to stay on the Perspectives/Architect dev stack until Prism a.k.a. Planning Analytics is prime time ready and has full development capabilities.
Kamil Arendt
msnoriko93
Posts: 2
Joined: Wed Jun 08, 2016 9:37 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: Microsoft Excel 2013

Re: Intersection cube calculation in Performance Modeler

Post by msnoriko93 »

qml wrote:
msnoriko93 wrote:I was wondering if someone can help me how to write this rules in Performance Modeler.
You can create and edit rules in the Model Design pane of Performance Modeler, similarly to how you would do it in Perspectives/Architect.

Rule syntax is unchanged and in your example the correct are definition would be as follows:

Code: Select all

['Dimension1':'Element1','Dimension2':'Element2']
If this does not answer your question then I'm afraid you'll have to rephrase it as it is not entirely clear what you are asking about.

Oh, and last but not least, you can tell your manager that he made a decision to migrate to a technology that is an evolutionary dead end. My suggestion would be to stay on the Perspectives/Architect dev stack until Prism a.k.a. Planning Analytics is prime time ready and has full development capabilities.
I mean how to write that rule in cube calculation from performance modeler.
but anyway, thank you. I'm going to try the one you told me.
Post Reply