Table of Contents
How to calculate past 5 weeks in Webi?
I’d construct a flag field (either in the back-end or in the universe) using datediff (in SQL Server terms). Failing that, you could construct a variable in Web Intelligence using the Week function. Thanks for contributing an answer to Stack Overflow!
How to perform a cumulative sum in Webi?
Hello personal perform a cumulative sum between sections of a report of the webi more every time i do have a cumulative sum in section he returns the sum total of section i somasse as follows: does anyone know how do i resolve this problem?
How to insert a formula in a Webi report?
You can also insert formulas and variables in a Webi report. How to Enter a Formula? To enter a formula in Webi report, the report should be opened in Design mode. Click the formula editor to enter a formula. Once the formula editor is open, build the formula. If the formula editor is not visible, go to Properties tab → View → Formula Bar.
How to validate a formula in SAP Webi?
You can click on the tick mark to validate the formula. Once the formula is defined, click Ok. On the left side, you can see this new variable in the list of available objects. To use this variable, you can drag this to Webi report. You can also edit or delete the variable.
I’d construct a flag field (either in the back-end or in the universe) using datediff (in SQL Server terms). Failing that, you could construct a variable in Web Intelligence using the Week function. Thanks for contributing an answer to Stack Overflow!
Is the order date always the same in Webi?
You have a Webi report set up that has two date dimensions in it. I’m assuming that your two dates are always in the same order. E.g. the order date is always before the shipment date. That you truly should be ignoring weekends.
When does Web Intelligence return the correct count?
When asked for a count of the resorts from query 1 or 2, Web Intelligence returns the total number of resorts for the merged object instead of the individual object. After SP03, the system returns the correct count for the queried objects.
Is the calculation engine for Web Intelligence updated?
The calculation engine for Web Intelligence was updated for Business Objects XI 3.0 and 3.1 to include several corrections and improvements. These changes are present in the 4.1 releases. This document describes these changes and the way they might affect the calculation results in Web Intelligence documents.