Error in rendering root for dialog "DLG_VARIABLE while executing BEx query

[#1]

Hi,

I am having an issue executing one of our old BEx query.

When I executing using filter fiscal period 001.2019 to 012.2019 it works perfectly fine but when I execute for 001.2020 to 012.2020 it throws an error (please see the screenshot).

It is really strange that it is working for 2019 but as soon as I change the fiscal period 2020, I get this error.

We are on SAP_BW7.4 / SP74020

According to the error below in screenshot, it says there is a replacement path variable ZFISCYRPER_TO causing an issue but I have created a test report on the same source system using the same variable and it works perfectly fine.

Just for your information, our basis dept recently copies a client from production to QA and this issue started after that otherwise last year this report was working fine.

I would really appreciate your help if you can advise what could be the possible cause as this is our most important report.

Thank you.

[bhavinvyas]

are you getting same error while running report from backend? try to see if there is any changes in authorization using RSECADMIN you can try to run the report and see the logs,

2668218 - Error in rendering root for dialog "DLG_VARIABLE" caused by missing analysis authorization

Bhavin

[former_member203111]

Bhavin, This report works fine when I run for year 2019 but we have forecast data in the report for 2020 and when i run this for 2020 thats when i get this error.

Thanks