Skip to Content
0
Former Member
Jan 29, 2014 at 01:18 PM

webi report with filter Month -1 (Bex Query)

23 Views

Hi all,

We have a problem. We have a webi report that calculates Month and Month-1 information.

This report gets directly from a Bex Query. We wanted to create at level report a filter that calculates the month (single) and another filter that calculates Month - 1 (here is complicated).

If I have a relational universe then no problem because I would create a filter Month-1 by prompt.

The problem is that my report extracts information directly from a Bex Query. Alternative, we can create a universe from Bex Query and a filter Month-1 by prompt.

We tried and gives an error creating level filters Universe Bex Query.

Has it occurred to anyone? it resolved?


Within two days we started to production and don`t resolve.


Thanks all!
Sergio


-------------------
Environment: Business Objects 4.1 Support Pack 2

Build: 14.1.2.1121
-------------------