Posts Categorized: Web Intelligence

Example of sub-query in Webi

Posted by & filed under Web Intelligence.

The post describes an interesting example of use of subqueries in Web Intelligence. The task is to display year-to-day revenue figures. The universe database structure is the following: The universe contains the following objects: Revenue defined as SUM(INVOICE_LINE.DAYS * INVOICE_LINE.NB_GUESTS * SERVICE.PRICE) Invoice Date objects such as Invoice Date, Month, Quarter, Year. Today object defined […]

Crystal Reports vs Web Intelligence

Posted by & filed under Business Objects, Web Intelligence.

Crystal Reports and Web Intelligence are two technologies from SAP BusinessObjects portfolio that provide possibility to build reports. Web Intelligence is a perfect tool for ad-hoc reporting. It is very easy to build report from a scratch even for a new user. However when the requirements are too specific, when it is necessary to build in a sophisticated […]

Hierarchies in Webi

Posted by & filed under Web Intelligence.

The task is to display a fixed level hierarchy together with totals for each level. This can be done using breaks. The most straightforward implementation might look like this: If there are many levels and the level names are long, the table will be very wide, with a lot of empty space. It would be better […]

Calculated Default Value for a Prompt

Posted by & filed under Web Intelligence.

It is possible to specify a constant default value for a prompt. But what if the default value need to be calculated. For example, there should be an optional prompt for the statement date in the report. If the date is not specified by the user, the current date should be used. It is possible […]

Time Sheet Status – Webi Exercise

Posted by & filed under Web Intelligence.

It seems to be a good Webi exercise (for beginners). Employees submit weekly time sheets. Each time sheet has time sheet lines. Time sheet line can have one of three statuses: Submitted, Approved and Rejected. The status of the time sheet is defined by the statuses of the time sheet lines: When for a week one […]

Break on Measure in Web Intelligence

Posted by & filed under Web Intelligence.

Sometimes it makes good sense to apply break on measures. Let's build a query based on the eFashion universe that contains product Lines, product Promotion Cost, Store Name, and Sales Revenue. Promotion cost is money spent for advertising a product, it is not directly related to stores. So the report is showing the same product promotion […]

Use of Alerts in Webi

Posted by & filed under Web Intelligence.

This post is a quick guide how to add a simple alert to a table in Webi. Images Upload necessary images to the BO server in the folder [Business Objects]\BusinessObjects Enterprise 12.0\images In this example images green_arrow.gif and red_arrow.gif were used. Preparation Create new Webi document based on Island Resort Marketing universe, Pull object Resort, […]

Cell Borders in Web Intelligence

Posted by & filed under Web Intelligence.

Web Intelligence cell borders function differently from the borders in Excel. The border in Web Intelligence can have different color from sides. For example, left of two adjacent cells can have gray right border, right can have black left border. The color of the border on the screen depends on the rendering algorithm, i.e. browser, […]

+0 does matter in Web intelligence

Posted by & filed under Web Intelligence.

In university I learned that adding zero does matter sometimes. However I did not expect to see this in Web Intelligence. The fact is that the following two expressions are not the equal: =(Average([Revenue])) In ([Year]) =(Average([Revenue])+0) In ([Year]) The query: The result: So the expression (Average([Revenue])+0) In ([Year]) is not equal to (Average([Revenue])) In […]

Dynamic Formatting in Web Intelligence

Posted by & filed under Web Intelligence.

You can get the response string to a prompt using Web Intelligence function UserReponse(). However the function returns string value which is formatted according to Web Intelligence preferred locale. To make handling of date strings independent on the locale, dynamic formats can be used. Dynamic Formats in ToDate Function To convert the date prompt string […]