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.

[jordanpanov]

You are probably missing master data for the 0fiscper object to cover the fill horizon.

[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

[bhavinvyas]

As you said, this issue you are having in your QA environment. Check the above settings in your production system if is is having component type 'RSBOLAP_VALUE' in production and still working then we need to search for other solution.Else you can replace it with 'BICS_PROV_VALUE'

Thanks,

Bhavin

[former_member203111]

No, we are having this issue in production environment.

What I said above was that we did a client copy from production to QA and it stop working in QA and in production both.

Thanks

[bhavinvyas]

Refer SAP OSS note for the same,

2465736 - Error: Error in rendering root for dialog “DLG_VARIABLE”

Since you are on < 7.50 SP6 (e.g. 7.50 SP5), please follow the manual instructions mentioned below to solve the problem.

1. Go to SE11
2. Enter 'BICS_PROV_STATE_VARIABLE' in section 'Data type'. Choose the option 'Change'
3. Remove the component type 'RSBOLAP_VALUE' and enter 'BICS_PROV_VALUE'
4. Click on 'Save' and 'Activate'
5. Please restart your portal after performing the steps above.
6. More details on SAP Note 2357717.

Hope it helps!

Thanks,

Bhavin

[former_member203111]

Hi Bhavin,

According to the note you mentioned in line 6, it says "The problem occurs only in SAP BW 7.50"

Can you please advise if there is an impact on removing component type 'RSBOLAP_VALUE' and enter 'BICS_PROV_VALUE'

Thanks