cancel
Showing results for 
Search instead for 
Did you mean: 

AFO Prompts not responding

former_member595337
Discoverer
0 Kudos

Hello,


I have an issue with AFO, when I try to add another field in Prompts (e.g another Business or category filter), the Excel is not responding anymore ... In the attached print screen you can see circled in red the button I chose before getting blocked.

Thank you for your help,
Have a nice day!

TammyPowlas
Active Contributor
0 Kudos

Hi Andrei - which version/SP of Analysis Office are you using? Are you using a BEx query? Are you using Excel 2016?

Accepted Solutions (0)

Answers (4)

Answers (4)

RafkeMagic
Active Contributor

Are you sure about that version? I believe after 2.4 SP3, SAP moved to version 2.5... Anyways, it's an "ancient" version, so you should consider upgrading to 2.7 SP2.

A BEx query is what we (old school people) call a query (which is used as a basis for reports), so in your case it would probably be what you refer to as "BW report".

0 Kudos

Hello Community,

I experienced the same issue:

  • Prompts: Excel buttons are not responding, match codes, add/remove lines, submit prompts etc... The only i get interaction is by using keyboard (the good old TAB, ENTER...)
  • once report had run : i cannot drag the Query elements (eg effective filters, variables etc... or any other query information) --> the Excel worksheet becomes totally blank....


Product Versions

  • Microsoft® Excel® 2019 MSO (16.0.14026.20202) 32-bit
  • AFO version 2.8.600.95340

The only workaround I found was to close the Excel (down to kill the thread) and restar fresh... hoping all would be good in the new navigation.... ideally not the best outcome.

0 Kudos

i forgot the attachment

former_member595337
Discoverer
0 Kudos

Hello,

The Analysis Office is 2.4 SP1.2 (I forgot to put the "." in my previous comment). Can be an ancient but unfortunately this is the one that we can use for time being and we don`t have possibility for update :(..

Thank you,
Have a nice day!

former_member595337
Discoverer
0 Kudos

Hello,

Thank you for your fast reply. Yes I am using Excel 2016, the version / SP of Analysis Office is 2.4 SP12 EN. Honestly speaking I don`t know how to answer to your question in which regards BEx query, but what I can tell you, is that I am trying to extract data using a technical name of a BW report. If you need any other information, please let me know.

Have a nice day!