Forum Discussion

Ranvir06's avatar
Ranvir06
New Contributor II
2 years ago

to get report of two cube views in a single dashboard

Dear community, Can you please suggest me way to get report of two cube view in single dashboard. in pdf and excel format. Any solution to this will be very helpful, Thank You

  • MikeG's avatar
    MikeG
    Contributor III

    Here's a stacked Grid that has 3 Cube Views in a single view.  Note you can show/hide the Header of the Cube View and choose which one's can be viewed in PDF and/or Excel.  It's a property on the Component.

    Dashboard:

     

    Component property for Header:

    Check out an example in GolfStream and see how the dashboard components are arranged.  What you are asking for is pretty common and very do-able.

    Hope this helps.

    • Ranvir06's avatar
      Ranvir06
      New Contributor II

      Thank You so much! But we have one more issue, do we have any way to combine pdfs of two cube views into one?

      • MikeG's avatar
        MikeG
        Contributor III

        Hi Ranvir06 I would not use a Dashboard for that.  I would recommend creating a Report Book.  Using Report Books you can combine one-to-many Cube Views, create Loop parameters to cycle through dimensions, and the end result can be a PDF (or Excel output file).  And, you can create a cover page.  So it really depends on what your goals are for the output.  Dashboards for real-time ad hoc analysis, or a Report Book for a ready-to-email nice looking PDF.

        Hope this helps.