How can I discover all properties (property_name) available for a dimension (e.g. [Sprint])?

Questions & Answers
, ,
1

I am trying to define a calculated member formula for dimension Sprint, but I would like to know all properties that Sprint would have so that I can choose the most appropriate for my goal. That would be useful to know for all dimensions. So how can I find a list of all properties available given a dimension?
Thanks!

2

Hi @LR_San,
You can use MDX formula to get All Properties for the Sprint dimension.

[Sprint].CurrentHierarchyMember.AllProperties

In the report it looks like this:

eazyBI_Sprint_all_properties
eazyBI_Sprint_all_properties1750×1612 299 KB

Also, you can use MDX auto-complete:

eazyBI_Sprint_properties
eazyBI_Sprint_properties1816×1028 238 KB

best,
Gerda // support@eazyBI.com