Multiple sheets on one datasource
Hi there Analysis experts.
How can we use the same datasource in different sheets in SAP Business Objects, edition Analysis for Office.
Apparantly it is possible in Analysis for Olap, and of course in WEBI.
But we seem unable to find that information in Analysis for Office.
Our customer has a workbook with 8 different worksheets using the same datasource/query.
She is meeting performance issues with this report.
If she runs the bex query only once in a new report, she has no issues on performance.
Patrik Maag replied
You can add a additional crosstab for a data source by using the Analysis Pane.
- Select the cell in the grid where you want to place the additional crosstab
- Open the Analysis Pane / Design Panel by clicking Display in the AO Ribbon.
- Go to Components tab
- Right click the data source and select "Insert Crosstab".
- The Insert Crosstab dialog is prefilled with the cell that you selected in step 1, so just confirm it.