DIMNM performance in PAfE

Post Reply
dan.kelleher
Community Contributor
Posts: 127
Joined: Wed Oct 14, 2009 7:46 am
OLAP Product: TM1
Version: 9.4
Excel Version: 11
Location: London

DIMNM performance in PAfE

Post by dan.kelleher »

Has anyone else experienced issues with Perspectives functions in PAfE? We have a fairly large function dimension and it takes ~ 10 seconds for a single retrieve. My alternative REST API query is much faster.

Existing IBM query:

http://server:port/api/v1/Dimensions%28%27dimension%27%29/DefaultHierarchy/Members?$filter=Element/Index%20eq%20201 - 12.36secs

My proposal:

http://server:port/api/v1/Dimensions('dimension')/Hierarchies('dimension')/Elements?$filter=Index eq 201&$select=Name - 308ms

Raised a case with IBM, but they have rejected that it warrants a fix, and have suggested I raise an idea/ enhancement instead:

https://ibm-data-and-ai.ideas.ibm.com/ideas/PAOC-I-935

If you also experience similar performance issues with any of the Perspectives functions I'd like to hear about it. Also, please add your votes to my idea above.

Thanks,

Dan
User avatar
Steve Rowe
Site Admin
Posts: 2410
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: DIMNM performance in PAfE

Post by Steve Rowe »

Wow, that's a big change in response times, I've voted and commented.

Any view on why their method takes so long to evaluate?
Technical Director
www.infocat.co.uk
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: DIMNM performance in PAfE

Post by gtonkin »

Members and Elements are not the same unless you only ever have one and only one occurrence of each element i.e. no element has more than 1 parent.

Where you have 5 rollups e.g. Products and have Total Products, Total Products by Brand, Total Products by XYZ etc. etc. your element count and member count are very different. Members are effectively the unique name as I understand it i.e. combination of Parent(s) and Element e.g. BRAND Y^SKU1 vs SKU1

Not saying that 12 seconds is reasonable just that there is more to this than meets the eye...
Post Reply