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.

  • KarlT's avatar
    KarlT
    Contributor III
    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.