cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BW Query Selection support

0 Kudos

Hi all,

I am working with the SAP INT KIT 3.1 and based some reports on WebI (OLAP UNIVERSE). Some queries used are containing Selection object in the Key Figures structure (not Formula!) where some restriction had been set. This restriction are using characteristic which are using a node hierarchy variable.

When we run the webI report based on the underlying OlapUniverse we get an error (classic in this forum : wis 10901). We alreday apply the SAP notes 1007048. And we are sure that nothing is wrong on this side.

We made a test and modify the query according some help catch in this forum and delete the Selection, put the characteristic in the "Characteristic Restriction" with the Node Hierarchy variable and re-build the Olap Universe. We then run a new WebI that was successfully displayed with the variable Hierarchy Node.

We assume that the BW Query Selection feature is not properly working with Characteristic using restriction based on Hierarchy Variable Node.

To the question why we not use the other working solution is simple. Because the requirement need this Selection in order guarantee a correct display of 2 different Key Figures. A IS vs PLAN display using different Hierarchy Node is actually what we need there.

Let me know if someone is having an idea about it.

Thank you and cheers,

S

Accepted Solutions (0)

Answers (1)

Answers (1)

IngoH
Active Contributor
0 Kudos

Hi,

do you see the hierarchy node selection variable in the Universe as a filter objects ?

Ingo

0 Kudos

Hi Ingo,

Yes I see it together with 3+ others variables. When I call WebI it is also displayed with all other variables but only the node hierarchy variables are bringing back the error stated above.

Cheers and thanks

S

IngoH
Active Contributor
0 Kudos

Hi,

when do you see the error coming up ?

Ingo

0 Kudos

When I am on the WebI query designer and click on RUN the prompt (variables) are coming up. I fill the required values for the some variables and when I want to set the value for the node Hierarchy variable it is hanging some seconds (I gues it tries to refresh the LOV for the variable) and then the error is coming up.

Cheers

S

IngoH
Active Contributor
0 Kudos

does the query run in BEX Web Reporting without any issues ?

Ingo

0 Kudos

Yes no issue in Web Bex.

Cheers

S

IngoH
Active Contributor
0 Kudos

Hi,

can you trace sofa and MDX for the webi report and send the logfiles ?

ingo