cancel
Showing results for 
Search instead for 
Did you mean: 

Only values in InfoProvider not working for ODS

Former Member
0 Kudos

Hi,

I'm on BEx 3.5 and I'm trying to use a variable in a query on an ODS. The InfoObject is set to "Only Values in InfoProvider" in RSD1 in the Query Execution Filter Val Selectn entry. The same setting has also been done in the ODS InfoObject specific properties for that InfoObject.

In spite of this, whenever I run the query and press F4, it shows all the values in the master data table of the InfoObject.

I've run it in BEx, and also in RSRT after deleting the cache. Nothing works.

Any ideas how I could proceed to fix this.

Regards,

Suhas

Accepted Solutions (0)

Answers (1)

Answers (1)

FCI
Active Contributor
0 Kudos

For queries on a ODS, variable values are always get from the masterdata table. This behavior is explained in the note 626887.

Regards,

Fred.

former_member185132
Active Contributor
0 Kudos

Hi,

Thanks for the note, it does explain this behaviour.

But that in turn begs the question of what is the point of allowing the option of ODS-specific properties of InfoObjects if an ODS can fetch F4 help only from the master data table!

Regards,

Suhas