Forum Discussion

Sweez's avatar
Sweez
Contributor
2 months ago

Export Cube View to Report Format?

Does anyone know if there is an api to export a cubeview to a report format, similar to how BRApi.CubeViews.Process.ExportCubeViewGridsToExcelFile can be used to export a cubeview to Excel via code? ...
Cube View
Reports
sameburn's avatar
sameburn
Icon for OneStream Employee rankOneStream Employee
2 days ago

Hi Sweez​ 

There is another BRApi, you can use for this that behaves in the same way.  But this one relies on (a) having your CubeViews inside Report components and (b) those Report components sitting inside some real Dashboards. 

This is the way the original (quite a long time ago) Guided Reporting worked with "Book" creation

byte[] objBytes = BRApi.Dashboards.Process.ExportReportsForMultipleDashboards(si, isSystemLevel, custSubstVarsForAllDashboards, dashboardNamesAndVars, fileType);

Hope this helps

Sam