Regarding Filter in Webi Report which is based on BEx query

[Former Member]

Hi,

I am developing Webi report, in which using universe which is baed on BEx query.

Suppose BEx query contains filter on fiscal year 2010.

And I am developing Webi report on that query. So I want to know, whether my Web i report output will contain data of only fiscal year 2010, as filter is applied in BEx query.

Thanks,

Pradip Nikam

[Former Member]

Answered

[IngoH]

Hi,

if this is a fixed filter the data will be filtered.

if this is a variable in the BW query the user will get prompted.

ingo

[former_member193430]

IS there a way to create objects in Universe designer to filter data based on the the YTD, fiscal year. The universe is designed on a BW Query.

[arijit_das]

Yes. You are correct.

Filters in the BEx query will not be visible in BO, but will be applied to the report created in WebI.

Regards