Analysis for Office - Prompt twice for parameters dialog box

[Former Member]

Hi,

We are implementing Analysis for Office V1.4 launching workbooks off the BI Launch pad (BI 4.0 SP6.3) via OLAP connection to BW.   When running the workbooks directly from Excel with the Analysis Ribbon, everything seems to work ok but when launching via the BI Launchpad the report parameter prompt appears first, the user fills it in and the report refreshes however the user is prompted a second time with the same parameters.  If they hit cancel the second time the workbook loses its connection to the datasource.  The workbook is a simple single sheet, single datasource.

Any information on this would be greatly appreciated.

thanks,

Karen

[kelly_stone1 · Accepted solution]

Hello Karen - we get the same thing on A4O 1.4.2.  Did you find a resolution for this?

Kind regards,

Kelly

[Former Member · Accepted solution]

Hi Kelly,

Yes we were able to get a patch release from SAP - it is fixed in 1.4.5.2765

regards,

Karen

[TammyPowlas]

Hi Karen,

I just wanted to be sure that you are on the latest SP for Analysis Office (1.4 SP3?)

[Former Member]

Hi Tammy,

Correct - we are on 1.4.3.2665

thanks,

Karen

[Former Member]

Hi Karen,

Do you have a Prompt setting for Authentication in your OLAP Connnection in CMC??. - You can change that to Predefined and update a Communication id here and check.

Regards,

Sri

[Former Member]

Thanks Sri,

We are using Single Sign On

regards,

Karen