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

100Rub's avatar
100Rub
New Contributor III
2 years ago
Solved

Reporting of Cell Detail Classification in Cube View

Hi All, How can I show Cell Detail Classification in the report ? Thanks
Cube View
  • Krishna's avatar
    Krishna
    2 years ago

    100Rub  - There are couple tables it stores the information.you can query and report out of gridview.

    1. DataAttachment - it has the Annotations, footnote and etc,...

    2. DataCellDetails - Has the Celll level details.

  • KarlT's avatar
    KarlT
    2 years ago

    There is a Data Adapter Method called "DataCellDetail". This can be used to get the information you require and pass into various dashboard components, such as the Report component. From this you should be able to create exactly what you need:

100Rub's avatar
100Rub
New Contributor III
2 years ago

Hi Krishna,

That is what I have done through DataCellDetails but I want to display cell details in dashboard/ Cube View/ Quick View/ Spreadsheet. Is there any way to report supporting details in any of the report view and can I export in PDF/ Excel ?

Thanks

KarlT's avatar
KarlT
Icon for OneStream Employee rankOneStream Employee
2 years ago

There is a Data Adapter Method called "DataCellDetail". This can be used to get the information you require and pass into various dashboard components, such as the Report component. From this you should be able to create exactly what you need:

  • 100Rub's avatar
    100Rub
    New Contributor III
    2 years ago

    Thanks for your solution. How can I export both cell supporting details and complete cube view in an excel and a PDF ?

    • KarlT's avatar
      KarlT
      Icon for OneStream Employee rankOneStream Employee
      2 years ago

      There are probably multiple ways you could approach this with Workspaces/Dashboards. If you want them both in the same PDF/Excel then you could create a Dashboard Report that contained both the Cube View and Cell detail to extract in PDF. Alternatively you could create an excel workbook which contained both the Cube View and a Table View of the cell detail. The specific solution will depend on how you want to interact with the report.

      The simplest solution might be to create a dashboard with both a cube view and a grid view of the cell detail. The users can then extract each separately in the format they desire.

      • 100Rub's avatar
        100Rub
        New Contributor III
        2 years ago

        Thanks for your reply. Is there any way to extract report (PDF/Excel) in one go ?