Skip to Content

Hierarchical view in dashboard

Hi Gurus,

Is it possible to show data in Hierarchical in dashboard. I am using sql server as database and I have bellow requirement.

As you see in the red circle. The data is in the Hierarchical manner. Depending on the selection of the level data changing. How to achieve the Hierarchical manner?

I'm using  BI 4.1 and Sql server 2012 as DB

Regards

Riaz

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 30, 2014 at 05:30 PM

    Hi Riaz,

    You can make use of Query browser connection and Hierarchical Table component.

    Regards,

    Amit


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      If you are using Sql server as a data base,then you would be requiring universe then as Amith mentioned,  use Query Browser-->Universe.

      In Dashboard components Hierarchical Table component will support the hierarchy form of data display.

      Best Reagrds,

      Venkat

  • avatar image
    Former Member
    Jan 16, 2015 at 05:21 PM

    I have oracle as backed and you cannot use hierarhical tables as it supports only BEx.

    For Oracle I cannot bind the Data to a Query browser query for Oracle.

    Amit I am not sure how it can be done for sql server?

    Add comment
    10|10000 characters needed characters exceeded