Skip to Content

   WEBI is a strategic web based tool for creating Ad-hoc reports. Reports can be created on top of Universe which can             have data from different sources including OLAP & OLTP connections.

    It has great report formatting functionalities, all in a web environment.

    Below we will see, how can we create a WEBI report on top of a universe.

   1) Open WEBI and click on Universe. Give the login credentials.

Untitled.png

  2) Select a universe on which you want to create a Report.

Untitled.png

  3) Drag the required characteristics & Key figures in the result panel and run the query.

Untitled.png

  4) After that run the query and you can see the query output.

Untitled.png

   5) Here we can do lot of formatting. First, we will see how can we do the ranking of our top customers. For this select Amount and right click–>Ranking–>Add        Ranking.

Untitled.png

   6) Enter 5 in the space besides Top to see top 5 customers and click OK.

Untitled.png

   7) Below, you can see the top 5 customers.

Untitled.png

   8) Below we will see, how can you put rules in WEBI.  It is similar to Exceptions in the BEx query. 

       Select the column and Goto Analysis–>Conditional–>New rule

Untitled.png

  9) Enter Amount Greater than <Any value> based upon your data, here 90000 and click on format.

Untitled.png

   10) Select Text and select the font color. Here Black is selected.

Untitled.png

   11) Also set the Background color. Select Background and set background color. Here we give Red.

Untitled.png

   12) See the report output as below.

Untitled.png










To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply