Skip to main content

Power BI

New

member properties ssas

Vote (116) Share
Diederick's profile image

Diederick on 23 Feb 2016 15:28:32

Currently it's not possible to show the member properties of a dimension. For creating reports some of the metadata is stored in member properties and needed for reporting questions.

Comments (15)
Diederick's profile image Profile Picture

97ffc659 6b72-4ad6-ad29-936b7068c557 on 06 Jul 2020 00:13:14

RE: member properties ssas

In Tabular/Power BI, the "Summarized By" property does not work on Data Type "Text" columns/fields. If allowed the option to set this to "Do not summarize", would this not give use the Member Property equivalent that we have in the multidimensional environment? Would it also be possible to attached a list of similar columns/fields that have "Do not summarize" to a field/column with the option to Hide these from the list of columns so that users cannot drag in without the use of the allocated field/column?

Diederick's profile image Profile Picture

5b10a524 e7c5-40de-931f-bd65e4854378 on 06 Jul 2020 00:05:12

RE: member properties ssas

Up

Diederick's profile image Profile Picture

f780dade e0d8-404b-a942-393a959b26e5 on 06 Jul 2020 00:04:52

RE: member properties ssas

This feature would solve so many problems.

Diederick's profile image Profile Picture

b1408c67 6b77-48b4-b59b-a3938c6bff86 on 06 Jul 2020 00:04:41

RE: member properties ssas

Up

Diederick's profile image Profile Picture

82c2e0f8 7556-4905-aee0-a9cee19a10d0 on 05 Jul 2020 23:50:10

RE: member properties ssas

Up! At the moment you can do this easily in Excel Pivot Tables but in "Power" BI this is not possible! Come on MS... Give Power BI some power when working with SSAS Multidimensional!

Diederick's profile image Profile Picture

fb8663d1 fe9a-4d05-b283-2449aa589263 on 05 Jul 2020 23:49:36

RE: member properties ssas

Up!

Diederick's profile image Profile Picture

605a3a24 e2f4-4b95-bffe-e5d5b7ef417b on 05 Jul 2020 23:42:11

RE: member properties ssas

Up. This is still a problem even after three years. Cube processing takes hours because we need to aggregate by every attribute, since we can't access member properties through a live connection.

Diederick's profile image Profile Picture

9e7b25cb 7088-4686-94dd-297b9565fb89 on 05 Jul 2020 23:41:57

RE: member properties ssas

In our cubes handling financial data we, for different god reasons, store the meaningfull descriptive texts for dimension members in a properties and without being able to render those properties as labels in the ui we can't use power bi. Prefered would be to be allowed to concatinate properties like property1 + " - " + property2

Diederick's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:30:00

RE: member properties ssas

up

Diederick's profile image Profile Picture

cce713af 3cfc-41cd-b147-e9ecef59c988 on 05 Jul 2020 23:23:37

RE: member properties ssas

up