Mdx query on ElementAttributes cube

Post Reply
kavitha2002
Community Contributor
Posts: 180
Joined: Sat May 05, 2018 11:48 am
OLAP Product: tm1
Version: 10.3.10100.8
Excel Version: 14

Mdx query on ElementAttributes cube

Post by kavitha2002 »

Hello Everyone,

I am writing a mdx query and call via Tm1 rest api.

Code: Select all

{"MDX":"SELECT {([Dimname].[Subet])} on 0, {([}ElementAttributes_DimName].[Attibute])} on 1 FROM [}ElementAttributes_Dimname]"} 
and i tried in ARC which makes the rest api call successfully...

Here the problem is how can i make a call to the private subset on Dimension which has the similar name of public subset.

Example:
SubsetSample -- private
SubsetSample -- public ...How can i specify which subset private or public in mdx...
bgregs
Posts: 77
Joined: Wed Sep 12, 2018 11:19 am
OLAP Product: TM1 / Planning Analytics
Version: 2.0
Excel Version: 2016

Re: Mdx query on ElementAttributes cube

Post by bgregs »

Hi Kavitha,

This is untested and just a guess, but have you looked into possibly using the "TM1SubsetToSet" method? It allows you to specifically identify if you want the private or public subset (defaults to private if not specified). Hope it helps!

https://www.ibm.com/support/knowledgece ... toset.html
Post Reply