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
DIMNM performance in PAfE
-
- Community Contributor
- Posts: 127
- Joined: Wed Oct 14, 2009 7:46 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 11
- Location: London
- Steve Rowe
- Site Admin
- Posts: 2415
- 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
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?
Any view on why their method takes so long to evaluate?
Technical Director
www.infocat.co.uk
www.infocat.co.uk
- gtonkin
- MVP
- Posts: 1198
- 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
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...
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...