Mdx query on ElementAttributes cube
Posted: Wed Sep 19, 2018 9:03 am
Hello Everyone,
I am writing a mdx query and call via Tm1 rest api.
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...
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]"} 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...