Sql Server Analysis Server with Excel Pivot Table RRS feed

  • Question

  • What is the best forum to ask what is the best way to provide an end user the ability to see either a dimension attribute members Key, Name,  or Value at their discretion.  For example for a given Category, it has the following:


    Name: CAT100

    Value: Bikes

    I'm not sure if I have to present three hierarchies or if there is a way to take advantage of the fact that the dimension attributes have an KeyColumn, NameColumn, and ValueColumn property.


    Tuesday, September 22, 2020 1:16 PM


All replies