cancel
Showing results for 
Search instead for 
Did you mean: 

Doubt in Bex query designer

Former Member
0 Kudos

hi experts,

I have restricted storage location values in Bex query Designer

But when i open Filter option in Webi report ,i could not see all the storage location value

So kindly help me to solve my issue

Accepted Solutions (1)

Accepted Solutions (1)

swati_gawade
Contributor
0 Kudos

Hi Maya,

Please check the settings made for the storage location characteristic in BEx query.

if the extended property tab in Bex query is set to Only posted value then only the values of master data that are currently available in infoprovider will be displayed.

Change this option to master data for showing all values in master data.

Hope this helps.

-swati.

Former Member
0 Kudos

Hi Swate,

Refer the Screen shot.this is my extended properties for storage location..Is this correct?

swati_gawade
Contributor
0 Kudos

Hi Maya,

for the Filter value selection at query execution, select the radio button next for option Values in master data table.

Thanks,

Swati.

Former Member
0 Kudos

Swathi,

Thanks for your quick response..

But i m thinking whether it ll affect globally wen i use the option which you suggest me

swati_gawade
Contributor
0 Kudos

Hi Maya,

This option will have effect only to this query and the settings will be applied to every place where the query is used.

if this query is used in multiple bobj reports then after this selection the entire master data list will be shown for all those BOBJ reports. However, for Other BOBJ reports which do not use this query there will be no change in behaviour.

Also, this setting will apply only to your storage location object and no other object in your query filter. i.e. if you have company code in your selection then the setting change of Storage location will not be applied to Company code.

hope this is clear.

-Swati.

Answers (3)

Answers (3)

former_member186053
Active Contributor
0 Kudos

Hi Maya,

First check, have you mapped to the correct storage location in Universe level(if you are creating report based on Universe) and also check the settings. if yes, try the options mentioned by others.

Thanks,

Vengal.

former_member976
Active Contributor
0 Kudos

Hi,

in WEBI have the next button on the pane pelase click on it.

have you restrcited the storage location globle filter or local filter - please check.

if it is the global filter you  are able to see those storage locations.

if it is the local filter able to see the specific key figure vlaeus.

form the swathi screen shot select the only values in info provider- now refresh the WEBI report.

-Phani.

Former Member
0 Kudos

Hi Phani,

in WEBI have the next button on the pane pelase click on it.I cant get this

former_member976
Active Contributor
0 Kudos

Hi ,

scrool down the inlist vlaues you will get the those storage location values.

infront of don't have the WEBI acces other i would have check.

-Phani.

former_member183012
Active Contributor
0 Kudos

Hi Maya,

try the solution mentioned by Swati and let us know the result.

Regards,

Ganesh Bothe