Hi out there!
Is there any possiblity in a MDX query to get all member properties of a member without explicitly naming it?
My MDX query is:
SELECT
{[Time].[1997].[Q1]} ON COLUMNS,
{[Promotions].[Bag Stuffers]}
DIMENSION PROPERTIES [Promotions].[Promotion District Id]
ON ROWS
FROM Sales
The point is that there are several properties for all different members in a dimension and I want to get them by a MDX query that I build in my code, so I don´t know the names of the properties when I built the MDX.
Can anybody help me?
Thank you very very much in advance,
Henning
Is there any possiblity in a MDX query to get all member properties of a member without explicitly naming it?
My MDX query is:
SELECT
{[Time].[1997].[Q1]} ON COLUMNS,
{[Promotions].[Bag Stuffers]}
DIMENSION PROPERTIES [Promotions].[Promotion District Id]
ON ROWS
FROM Sales
The point is that there are several properties for all different members in a dimension and I want to get them by a MDX query that I build in my code, so I don´t know the names of the properties when I built the MDX.
Can anybody help me?
Thank you very very much in advance,
Henning