The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

mitra_daei's avatar
mitra_daei
New Contributor
3 years ago

Cube view report in excel

I am looking for a way to download a dashboard with multiple tabs to excel and making sure each tab is downloaded to a tab in excel workbook. Is there a way to do that easily?

dashboards

4 Replies

  • ckattookaran's avatar
    ckattookaran
    Valued Contributor
    3 years ago

    I believe if you create a BI Viewer component with multiple sections it'll do that. 

    Now for tabs, I don't think the default option of Export to EXCEL does it. I had to create a custom button that exports and downloads the content from all the tabs once clicked.

    • Cosimo's avatar
      Cosimo
      Contributor II
      3 years ago

      You're generating an XLSX workbook using BR?? Would love to see a code sample.

    • mitra_daei's avatar
      mitra_daei
      New Contributor
      3 years ago

      Good afternoon , would you be able to expand on the custom button, did you write a BR to export all tabs to the Excel at the same time and then assigned that to the button? Any way you can share the code with me?

       

      • ckattookaran's avatar
        ckattookaran
        Valued Contributor
        3 years ago

        I'm using EPPlus for creating the EXCEL workbook. I'll try and generalize the rule and post it here, or I will do a separate post for the same.