Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Best Regards

Ingrid Husby

Former Member

Hi Ingrid,

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.

Best regards,


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question