Members Filtering in design studio 1.6

[Former Member]

HI Experts,

When we click on member filtering in initial view of application we can use couple of options

1.Only values with posted data

2.Values with Master data

3.Values in fact table

I Have searched lot of threads and found some but till now there is no proper explanation for these things .very confusing not  sure which option to use on which scenario

Threads i have searched

Any Help would really hyelpful

Thanks,

varun

[former_member4998 · Accepted solution]

Please check below link helpful. 

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20ecb78c-374a-2d10-c6af-f024f19b7...

Point1: The values are transferred according to the setting of “Query definition filter value selection” in infoobject maintenance (RSD1)

Point2: If the setting for the “filter value selection for the query execution” as the value "Values in Master Data Table", the system displays the values for the master data table. Otherwise, it displays the values for the dimension table.

Point3: Since other Infoproviders do not have a dimension table, the system displays only posted values if you select "Only Posted Values for Navigation". Otherwise, it displays the values from the master data table

[gopinath_kolli]

when you use the data source in a filter panel, the members for selection for the column you applied those options will get effected.

For ex:-

In a data source you are adding a column and used that data source in a filter panel.

1.Let say you have added that column and set an option "Values in fact table"

you will get all the values existing for that particular column in the fact table.

2.Let say you have added a column and set an option "Only values with posted data"

In this case consider you already applied some filters on other columns which will give less number of values for the column due to this option.

ie; this column will also get filtered. In case 1 you will get all the values in the fact table.

It holds same with the master data.