Skip to Content
avatar image
Former Member

Bex query changes not reflecting in the Bex Reports

Hi Experts,

I have made the currency conversion change in one of the existing key figures definition in the Bex query and try to refresh the locally saved Bex report but the changes are not reflecting in the report however the report still showing the old values.

However creating a fresh report on the same query reflects the changes.

Please suggest how can I refresh the query structure in the locally saved Bex reports. 

Thanks

Shikha            

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 13, 2015 at 12:54 PM

    Dear Shikha

    The existing workbook might be still taking the cache values. Can you run for a different selection and check if the values are changing

    Regards

    Gajesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Gajesh Nagesh

      Thanks much Gajesh,

      That shows the correct values in the report however all the local filters and settings were removed after reassigning the data provider.

      Shikha

  • avatar image
    Former Member
    Jan 13, 2015 at 11:23 AM

    Hi,

    Have you directly done changes at prod.

    if yes then save your changed query and close it.

    Try to generate your query from RSRTĀ  and later open your query from analyzer.

    See the results.

    if you done at dev system then again retransport your bex query changes to prod.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 13, 2015 at 12:42 PM

    Hi,

    after changes query please save it

    then come to RSRT execute it

    now check the changes replect in the query.

    which system your are checking- dev/prd.

    check the last changed by user.

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2015 at 01:52 PM

    Hi Raman and Phani,

    Changes are  there in the Prod system already.

    I executed the query in RSRT and then refreshed the locally saved report but it didn't help, report is still retrieving the local currency instead of converted USD values.

    Thanks

    Shikha

    Add comment
    10|10000 characters needed characters exceeded