BEx query changes are not reflected through OLAP connection

[Former Member]

Hi,

I've made some changes (Changed some variables) in a BEx query, which gives me a new prompt and prompt text.

I can see the changes in BW->RSRT and in the query designer, but if I use the OLAP connection on the BO Platform, I only see the old prompts.

If I add another dimension to the free characteristics, I can see and use it, but I still get the old prompts.

I've tried the following:

• Changed the OLAP connection (To another query and back)
• Created a new OLAP connection (Here I see the right prompts...)
• Added an object to the BEx query
• Tried to remove and re-apply the variable

I am using BW 7.3 and BO 4.1 SP 4 Patch 2.

I consider this an error, which I will report to SAP, but until this has been fixed I would appreciate any help I can get.

Thanks in advance!

/Kris

[Former Member]

Did you also try logging out of launchPad, closing the browser and logging in back again?

[Former Member]

Hi Victor,

Yes, I forgot to mention that I did the changes last friday. Thus having logged out and closed my laptop in the meantime.

Also, my colleague has experiences the exact same issues.

[amitrathi239]

Hi,

try with open the report in rich client and edit the query and refresh again the report.

or under the Data Access tab, select the "Tools" tab Click "Change Source".

Select the query you want to change the data source of

Select the radio button for "Specify a new data source"

Navigate to the new data source

Then follow the wizard which will include object mapping

see if it will work.

Amit

[Former Member]

Hi Amit,

This occurs in all tools (WebI, Design Studio, Analysis) as long as they use this connection.

I have also tried creating new reports from scratch, same result though.