how to select range through combo box?

[Former Member]

Hi Experts,

How should select the range through combo box.

For example: jan feb march apr may jun jul aug

                    10  20   30      40  50    60 55  23

                    32   32   23     43  22    23  43  56

                    12   31   13     13   31    11  12  12

here If i select the starting range and end range I want data between the range

start range: feb

end range : jul

expected output:

                    feb march apr   may   jun   jul

                    10   20      30      40    50    60

                    32   32     23      43     22    23

                    12   31     13      13      31   11

[Former Member]

There is no such component where you can specify the start and end value in dashboards.
You will have to define the prompts as start value and end value as suggested by Naras above.

[Former Member]

Hi Abhilasha,

It is correct what happen when i am clicking the open document link is working fine. but in dashboard the open document does not taking filter data.

[former_member207052]

If your dashboard is based on QaaWS, just add a query filter for start and end months. So when the user chooses the start and end months the query will(you have to configure) run and fetch only the data for the selected months.

If you want to fetch all data in one shot and then do something internally within dashboard you have use some lengthy formula(s) and transformations (rows to columns so that you can use filtered rows option).

Regards,

Naras

[Former Member]

Hi Narashimman,

How should pass through QaaWS Connection.

I am passing following way but it is not working

http://10.5.100.212:7080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=Ae35bKxQveJIs...

[former_member207052]

First of all , the above link is an Opendoc link to open a report. Query as a web service is a separate method of accessing data.

Learn more: http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_qaaws_en.pdf

Regards,

Naras