Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 12, 2014 at 11:49 AM

    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,


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Venkata Subhash Medisetty

      Hi Venkata.

      We wanted to not have 8 queries running towards the same datasource just because we have 8 different views / filters of the same data on different tabs in the Excel Sheet.

      Apparently that is not possible.

      Thanks for your answer anyway 😊