Bex Query Structure elements - Too much Caracteristic values displayed

Former Member — Wed, 01 Dec 2010 14:23:07 GMT

I have some troubles when using structures in Bex Query Designer 7.0.

When I run the query, I have line that appear that should not as they donu2019t belong to the structure element selection.

Here is an example of what Iu2019m trying to do and the different results I have when using Bex Query Designer 7.0 and Bex Query Designer 3.x.

I use a simple query which is defined like this:

Lines || Columns ||

Structure || Caracteristic A || Ratio ||

And I use the following structure :

Element 1 || Caracteristic A = CaracteristicValueA ||

Element 1 || Caracteristic A = CaracteristicValueB ||

Element 2 || Caracteristic A = CaracteristicValueC ||

Element 2 || Caracteristic A = CaracteristicValueD ||

Element 3 || Caracteristic A = CaracteristicValueE ||

Element 3 || Caracteristic A = CaracteristicValueF ||

Element 3 || Caracteristic A = CaracteristicValueG ||

Using Bex Query Designer 3.x gives me the following result. This is exactly what I am expecting.

Element 1 || CaracteristicValueA || Value 1 ||

Element 1 || CaracteristicValueB || Value 2 ||

Element 2 || CaracteristicValueC || Value 3 ||

Element 2 || CaracteristicValueD || Value 4 ||

Element 3 || CaracteristicValueE || Value 5 ||

Element 3 || CaracteristicValueF || Value 6 ||

Element 3 || CaracteristicValueG || Value 7 ||

With Bex Query Designer 7.0, I obtain this :

Element 1 || CaracteristicValueA || Value 1 ||

Element 1 || CaracteristicValueB || Value 2 ||

Element 1 || CaracteristicValueC || ||

Element 1 || CaracteristicValueD || ||

Element 1 || CaracteristicValueE || ||

Element 1 || CaracteristicValueF || ||

Element 1 || CaracteristicValueG || ||

Element 2 || CaracteristicValueA || ||

Element 2 || CaracteristicValueB || ||

Element 2 || CaracteristicValueC || Value 3 ||

Element 2 || CaracteristicValueD || Value 4 ||

Element 2 || CaracteristicValueE || ||

Element 2 || CaracteristicValueF || ||

Element 2 || CaracteristicValueG || ||

Element 3 || CaracteristicValueA || ||

Element 3 || CaracteristicValueB || ||

Element 3 || CaracteristicValueC || ||

Element 3 || CaracteristicValueD || ||

Element 3 || CaracteristicValueE || Value 5 ||

Element 3 || CaracteristicValueF || Value 6 ||

Element 3 || CaracteristicValueG || Value 7 ||

Is it a known bug ? Is there a solution to avoid this ?

Iu2019m currently forced to creating some queries with BQD 3.x. and to carefully look at the version used each time I have to maintain those queries.

Edited by: Christophe LG on Dec 1, 2010 3:24 PM

Re: Bex Query Structure elements - Too much Caracteristic values displayed

Former Member — Wed, 01 Dec 2010 14:33:43 GMT

Hi,

In BQD 7.0 try right clicking on Advanced Tab for CharachterisiticA and select option Only values in Infoprovider.

Re: Bex Query Structure elements - Too much Caracteristic values displayed

Former Member — Wed, 01 Dec 2010 16:50:53 GMT

Hello,

Thanks for replying but it didn't solve my problem.

I have just tried to launch the query in RSRT, RSRT1, Bex Analyzer and it works fine. The issue only appears in portal display.

Edited by: Christophe LG on Dec 3, 2010 2:25 PM

Question Re: Bex Query Structure elements - Too much Caracteristic values displayed in Technology Q&A

Bex Query Structure elements - Too much Caracteristic values displayed

Re: Bex Query Structure elements - Too much Caracteristic values displayed

Re: Bex Query Structure elements - Too much Caracteristic values displayed