passing parameters to restrict rows

[Former Member]

Hi All,

I have created a Universe, I want this universe to be used in WEBi/ Dashboards.

My question is, how can I pass a date to restrict number of rows.

TIA

[Former Member · Accepted solution]

Hi Charlie,

This can be done in two ways:

1. At universe level:

Create a universe filter on date with @prompt syntax, this will promp the user who is running the report and will passs the value in where clause of query and filter out that data.

You have to use this filter while creating the report.

2. At report level:

Select the data object in query filter while creating the the report with prompt.

Like below:

Thanks

[Former Member · Accepted solution]

Thanks for the reply.

How about making this in Dasboard?

TIA

[Former Member · Accepted solution]

For dashboard, we can connect Universe with the below connection mechanisms.

1. Qaaws: There we can pass paramter to restict the values

2. Query brower: same as Qaaws.

3. Webservices: we have apply filter in webi document so that we can get exact whatever we wants that results.

Regards,

Chandrakanth

[Former Member · Accepted solution]

3. Webservices: we have apply filter in webi document so that we can get exact whatever we wants that results.

I want to fileter the records even in Dashboards. How can I achieve that.

Thx

[Former Member · Accepted solution]

Use query browser and prompt

[Former Member · Accepted solution]

chandra kanth is correct..

The process is almost same if you are using query browser in dashboard..however if you are using BICS or live office then you will need to define the filer at the underlying report level..