TM1 Forum

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

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?

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...