Skip to Content
avatar image
Former Member

is it possible to have single filter instead of 3 filters (input is same for 3 filters but data is diffrent)

hi experts,

can you please guide me i am using 3 filters that reflecting 3 graphs with different data,

i want to use 1 filter instead of 3 filters,if we select in 1st filter  same input should pass to reaming 2 filters

data is different for 2 graphs but selection is same.

please find below attaches screen

filters.JPG (52.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Dec 31, 2014 at 05:28 AM

    Hi Naresh,

    Can you try Filtered Rows functionality?

    Regards,
    Fazith Ali Z

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi Fazith,

      thanks for reply i tried with option also, can you please guide me with step by any note or videos

  • Dec 31, 2014 at 07:16 AM

    Where is your data coming from? Has every chart its own separate data source? Do you use connections or the query browser? You can use prompts/filters in that case. The Filter component can provide the filter value for all connections.

    Otherwise, if all data is in the spreadsheet, you should do some rearranging within the spreadsheet so your filter component can use the three separate data sets as one big data set.


    /Xavier

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Naresh,

      So you have three separate SAP NetWeaver BW Connections in the Data Manager, or are you using the Query Browser?

      In the Definition tab of the data manager, you can bind the filter value(s) (that result from the selection the users makes with the filter component) to a characteristic in the BEx Query. This is in the Input Values area. You can bind to the same spreadsheet cell(s) from each SAP NetWeaver BW connection.

      /Xavier

  • avatar image
    Former Member
    Dec 31, 2014 at 10:27 AM

    HI Naresh,

    Use combox and use filtered rows as property

    make use two more comboboxes and make them hidden .

    property of combobox should be set as follows

    under behaviour tab

    select type as dynamic

    item: map to the first combobox destination .

    then its work fine and chart data gets displayed.

    Regards

    sushma


    pastedImage_1.png (34.5 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 02, 2015 at 10:10 AM

    Hi Naresh,

    You can achieve this by mapping all your queries filter to same cell say Sheet1$A1 and In usage tab of Connection , Use Refresh on trigger of cell Sheet1$A1 , and refresh on open.


    Untitled.png (48.4 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Naresh,

      If you are using BI 4.0 SP4 or higher version,you can connect through the Query Browser to the Bex Query.Add 3 queries in the Query Browser which all the queries contains the same prompt filed.Take Query prompt selector ,while selecting the properties select all 3 queries in the Refresh Queries option as below.

      Hope it helps to your scenario.

      Best Regards,

      Venkat

      Server.PNG (17.2 kB)