refresh characteristic texts in query result without logoff in Bex 7.0

[Former Member]

Dear Experts,

I'm using a query in BEx 7.0 and switched off all caching parameters in RSRT. For instantly reloading values from Cube/DSO this is working fine.

Some of my characteristics are shown as key + text in query result. Unfortulately these texts are not updated during the query reloads. I do not want the user to logoff / logon the report to get the updated texts.

Interestingly, after a refresh the texts for those characteristics are updated immediately for all filter items, but not in the result area.

Could you give me a hint, how I will be able to refresh those characteristic texts as same as the values in the infoprovider? E.g. using VBA makros or by customizing of specific workbook settings?

Thanks for your help!

Kind regards,

Tim

Edited by: Tim Kley on Apr 19, 2010 2:42 PM

[sven_mader2 · Accepted solution]

in RSD1 there is the reading class for the characteristic. Change it to an other one that don't cache texts.

Sven

[Former Member · Accepted solution]

Hi Sven,

thank you! Your hint solved my problem.

I expected the OLAP or the session context to cache the texts, but didn't have a look at the md reading class before. Now my own class refreshes the texts in the course of refresh.

Regards,

Tim

[Former Member]

Hi,

what have you achieved so far concerning this.

My post from today was also going in this topic.

The setting of this paramter I mentioned there could maybe help in your case.

transaction "RS_FRONTEND_INIT" add the parameter "ANA_ENHANCE_REFRESH" with value "X"

o Open the analyzer and connect to system to open WB

o Click on the refresh button

o New functionallity "Full Refresh Of Active Queries" is now available.

Best regards Harry

[Former Member]

Hi Harry,

thanks for your advise. But unfortunately it didn't have any effect on the reloading behaviour of characteristic texts. So far, I didn't find a solution on my own. In our current state, all users will have to re-logon in BEx Analyser.

Regards,

Tim