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

Help needed in SAP BO dashboards


I am looking for expertise recommendation on a requirement I have based on the below data set…

Requirement is to create a list box (labels State), and create a combo box that lists the city. Cascading filtering should occur... Which
means when state Texas is selected in the list box, then cities should be filtered down to Dallas, Austin and Houston in the combo box...

I was able to achieve this by using 2 different destination tables.

My question is….How can I populate the results into one destination table when either state or city is selected ? (as seen in the below screenshot).

If I keep 2 tables, then I need to hide one or the other depending on which filter component is selected (trying to avoid dynamic visibility
and also reduce the number of components)

I hope my question is clear. Please let me know if you have any questions.

Appreciate any help / guidance.

Thanks in advance,

Ann 😊

data set.png (8.9 kB)
my result.png (24.9 kB)
desired result.png (25.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2013 at 04:19 PM

    Hi Ann

    Are you asking if you can select only a state value and no city is selected and show all the cities in the destination table? Please confirm.

    To do that are you allowing them to select none/null/all cities kind of values ? How do you plan to provide that option? based on that I can give you an answer. I have done a similar thing before.

    I just want to make sure I am answering the right question 😊


    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.