on 11-26-2014 4:38 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.