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.
Environment: Business Objects 4.1 Support Pack 2