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:
You will need to develop a dashboard to enable users to extract both the cube view and the cell detail in one report (either PDF/Excel). This is not possible directly from the cube view.
I am using Cube View MD for a full cube view and the DataCellDetail method type for supporting details, adding these Data Adapters to the BI Viewer. I have been trying to extract both the Cube View and Cell Details through the Dashboard into a single Excel/PDF. From your reply, I understand that this is not possible. Please let me know if there is another way to export the single report to the client, as separate exports do not suffice.
Thank you.
No, i see a few options (probably not exhaustive), some mentioned above:
1. BIViewer - If you already have the data in BI Viewer it will allow you extract the whole dashboards as either a PDF or Excel. Please note the excel will put different grid components on separate tabs and the PDF will only show what fits on the page when extracting the entire dashboard.
2. Report component - will allow you to put both a cube view and cell detail in one report and extract to PDF
3. Spreadsheet component - you could create a cube view on one tab, and a table view of the cell detail on a second tab.
I hope that helps
Regards,
