Forum Discussion

Sweez's avatar
Sweez
Contributor
3 months ago
Solved

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
    29 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

sameburn's avatar
sameburn
Icon for OneStream Employee rankOneStream Employee
29 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