Skip to Content
author's profile photo Former Member
Former Member

Members Filtering in design studio 1.6

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Aug 23, 2016 at 08:10 AM

    Please check below link helpful.


    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20ecb78c-374a-2d10-c6af-f024f19b785d?QuickLink=index&…

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 23, 2016 at 08:35 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.