Cnnection error while creating universe on Bex Query in BW

[former_member360582]

Hi

I am getting connection error while connecting to BW Bex query.

The error i am getting while creating universe is A runtime exception has occured Error getting levels for hierarchy dimension .....:Unknown error.

After this

Also while creating universe no key figures/measures are getting generated from Bex query to designer.

Also in Bex query which are created as mandatory variables comes as Prompts in webi.

But when I try to parse in Condition filter it is throwing error.

Currently that mandatory variable is From Date and To Date

Is we require to change the prompt syntax in Condition filter.

Also kindly suggest solution for Connection error as impemtation is getting affected.

Regards

Gaurav Mang

[Former Member · Accepted solution]

Have you checked "Allow to external applications" in Advanced properties to allow BO to use BEX query?

[former_member360582 · Accepted solution]

Hi

R u saying allow external acces in BEX query.This option in Bex Query designer.

Or In whether while creating universes under properties tab there is use of OLAP universes option has to be made to Yes.

This both things we have tried

Let me know any other option to be tried.

Regards

gaurav mang

[Former Member · Accepted solution]

Yes, I was talking about option in BEX query designer.

[amitrathi239 · Accepted solution]

Hi,

Try with below steps.

In SAP GUI for the BW system hosting the BEx query, go to transaction STMS and make sure the transport "Business Objects Personalization objects" R21K900693 is loaded properly and has a green light.

If it has a red square load the SAP Integration Kit SP3 transport files.

Thanks,

Amit