Forum Discussion

alsathappan's avatar
alsathappan
New Contributor II
8 months ago

Is there an option to create a QV with columnar view of a dimension hierarchy

       
Excel Add In
  • KarlT's avatar
    KarlT
    8 months ago

    Not using the standard QV settings i don't believe. You could possibly try do something with Dynamic Calcs to reproduce these as the first X columns of your query.

    Alternatively if your users are happy to interact with the data through Dashboards, the Cube View MD type data adapter has some functionality that may provide what you're looking for.

alsathappan's avatar
alsathappan
New Contributor II
8 months ago

Thank you KarlT.

We had to create multiple dynamic calcs to get the info and used the members in QV as well as created cube view.