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 (18)
RE: member properties ssas
Still not solved. Need a solution to use Power BI in our company.
RE: member properties ssas
this is really ridiculous... It forces you to design the cubes in a sub-optimal way just for Power BI to be able to visualize the attributes...
RE: member properties ssas
Still not solved
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?
RE: member properties ssas
Up
RE: member properties ssas
This feature would solve so many problems.
RE: member properties ssas
Up
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!
RE: member properties ssas
Up!
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.