cancel
Showing results for 
Search instead for 
Did you mean: 

Single Values List - Filter Variable

Former Member
0 Kudos

When I click on Select Filter Values and choose single values it takes a long time - several minutes - to produce the list for particular characteristics. In this example I am looking at customer group. The setting in the Query for Filter Value Selection at Query Execution is set to Only Posted Values for Navigation. In the infoobject Selection of Filter Values for Query Execution is set to  Q mode Only posted values for navigation. The query is built on a multiprovider made up of four cubes. Each cube has several million records in. Is there an obvious way to speed up the single values list.  

Accepted Solutions (1)

Accepted Solutions (1)

cornelia_lezoch
Active Contributor
0 Kudos

yes, it is obviuos that you should change to read master data table (assuming that in master data table there are only few and not millions of records).

inworst case the user selects a value, which is not booked in any of the cubes yet, then he will not get any data in the query.

regards

Cornelia

Former Member
0 Kudos

I thought as much. Thank you.

Answers (0)