Skip to Content
avatar image
Former Member

AO 2.4 Variants on BIP

We upgraded to AO 2.4 and now the variants are grayed out when launching reports from the BOBJ launch pad. It worked fine in AO 1.4. Is there a setting I need to check or something I'm missing?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 04, 2018 at 08:42 PM

    Hi Matthew - please see SAP Note

    "save variants in Document Mode when opening the workbook from BI platform, make sure all prerequisites mentioned in the User Guide are in place:

    • You use at least version 4.2 SP 4 of SAP BusinessObjects BI platform.
    • The workbook is already saved on the SAP BusinessObjects BI platform.
    • In the Central Management Console, properties of the Analysis runtime, the Variants Support is set to User or User and Global.
    • You open the prompting dialog with the icon in the ribbon.
    • The workbook property Merge Variables is selected when a new query is inserted.

    If the workbook contains only one data source, it is possible to change the default mode from Document to Data Source by changing the setting ShowDSVariantsForWorkbooksWithOneDS to TRUE in Analysis Office settings. See SAP note 2083067.
    In this case the workbook will be opened with default variant mode set to Data Source. Note that this setting only changes the default mode for the initial prompt. Meaning that after refreshing the workbook, the default mode will change to Document again.

    The user can also cancel the prompt dialog and open the Prompt for Data Source in order to save the variants in Data source mode..." Source: SAP Note

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Great thank you!!! We were missing the config file portion of this. This fixed my issue thank you so much!!