Skip to Content
0

Help with values for filter a dimension in a query

Jan 30, 2017 at 04:45 PM

125

avatar image

Good day:

I'm having an issue with a query, the problem is that when I try to filter a dimension in the values for filtering shows more than the ones that have data.

I made a query usin Bex query designer 7.4, in the query I have a dimension in wich I have selected the "only values with posted data" option:

In the infosite I have a dimension that is an atribute of the custommer and other that is an attribute of the bill, in the query I'm only using the one of the custommer.

When I run the query in Bex Analyzer (version 7.4), in Analysis edition for Excel (version 2.4.1.65132) or in SAP Design Studio 1.6 SP4 and try to filter the dimension in the tree programs shows more values for filtering data that the ones that have information (As shown below):

As you can see in the tree cases it shows 19 values for filtering the data, but if I put on a table in the rows the dimension it shows only 8 values (the image is from Bex Analyzer but in the tree programs has the same behavior):

Does anyone knows how to solve this issue and show in the members for filtering only the values that are shown in the table?

I would appreciate any help that you can give me, I reviewed all the options in the Bex Query designer but without any change.

Thanks in advance.

Greetings

propiedades.png (14.4 kB)
valores.png (35.4 kB)
tabla.png (3.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Cornelia Lezoch Jan 31, 2017 at 01:54 PM
0

Hi Andoni,

If your selection goes on a navigation attribute, I would try the option "Characteristic relationship" or the one tjat is according to "navigation".

It depends a bit on your data model - maybe there are several info provider below a multi - then I think the system reads all values from all providers.

and it also usually behaves strange in case of a compounded char.

best regards

Cornelia

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Cornelia for the answer, I didn't have idea about the the behaviour for the multiprovider, I thought that when I check the values available for filtering it will only show the ones that have a value but not all of the infoproviders that are linked to the multiprovider. Perhaps in one of the infoproviders is the "extra" data.

I'm going to check in the infoproviders and tell you about the results.

Thanks for the response.

Greetings

0