BEx Workbook Conversion to A Office: Error

[former_member198454]

Hello. I am attempting to convert a workbook developed within BEx Analyzer to Analysis for Office. When I attempt to convert the workbook it immediately fails with the following error message:

'Nested exception. See inner exception below for more details: That command cannot be used on multiple selections'

Has anyone experienced this error message? Also, is there a place to look up these error messages to determine what is specifically causing the issue? We have many workbooks to convert so having a place to diagnose would be beneficial.

Kind regards,

Lynn Peter

[former_member198454]

I was able to bypass that workbook by hiding the SAPBEXqueriesDefunct sheet and it worked. I do not understand why but I will take it.

I have another workbook that will not convert. It is giving me the error message 'Delete method of Style class failed'. I turned on the conversion log but it will not display it unfortunately.

I will log a ticket with SAP to see if they can assist.

Thank you,

Lynn

[TammyPowlas]

Hello Lynn - I am not sure there is a diagnosis list, as that error sounds like it came straight from Microsoft (my take only)

The best resource on workbook conversion is this (starting on page 35) http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/602fb1d6-869b-2f10-b69c-89169b6aa...

I'm wondering if your workbook has a non-convertible object; could you check against the above linked document?  Do you have your workbook conversion settings set up per the document?

[former_member198454]

Thanks Tammy. It has navigation panes but it simply doesn't put those in (which is fine). The workbook has macros so I am not sure if they are an issue and will have to be removed prior to conversion.

Yes, I had my workbook conversion settings as suggested in the document. 

Many thanks,

Lynn

[Former Member]

Hi Lynn,

maybe stupid questions, but those were issues when we converted... so maybe helpful to check?!

1) The workbooks are not local, but stored on the server?

2) The user is valid (time & password) and has appropriate authorization?

3) The Workbook was created with BEX Analyzer not EPM add-in?

Have you tried different conversion settings?

Was there any failure protocol file created?

BR, Martin

[former_member198454]

Hello Martin. Thank you for your response.

1. Yes, actually at our organization all of our workbooks are local. So, we are saving some of the more robust workbooks to the server so we may convert them. I wish we could convert local workbooks. But to answer your question, yes it is stored on the server.

2. Yes, the user is valid. It is actually myself and I have converted about a dozen workbooks with no issues.

3. Yes, it was created with BEx Analyzer.

Actually, I set it to show the conversion results but I am not seeing them. I will try some other conversion settings, that is a good idea.

This particular workbook has some robust macros so we are suspecting they are the cause. However, we would like to keep them in there during conversion if possible.

I will keep you all posted.

Many thanks,

Lynn