Category Archives: Business objects Web Intelligence

Best Practices in Business Objects

In this thread, I am trying to collect all the best practices as much I can. If you can contribute your own best practices for Business Objects, it would be really good to share with all. Have a look at … Continue reading

Posted in Business Objects Administration, Business objects Web Intelligence, Universe Designer | Tagged , , , , , , , | 1 Comment

Hide a column in Web Intelligence

How to hide a column in WebI In this post I would like share some information on how to hide columns using alternate and manual methods. The illustrative example report is created from Efashion sample universe in BOXI 3.1. Let … Continue reading

Posted in Business objects Web Intelligence | Tagged , , , , , , , , , | 1 Comment

Frequently used Functions and Formula

Frequently used Functions and Formula To remove the commas and currency symbols in the measure values, =FormatNumber([Sales revenue];"#") To get the measure values in decimal notations, =FormatNumber([Sales revenue];"#,##.00") To get the beginning and ending [year] values from a list of … Continue reading

Posted in Business objects Web Intelligence | Tagged , , , , | Leave a comment

Rolling Text in Report Title

Rolling Text in Report Title Using HTML Scripts inside the reports for label and other format makes the report more dynamic from its interactiveness For Example we can show a rolling text as an report title, We must ensure the … Continue reading

Posted in Business objects Web Intelligence | Tagged , , , | Leave a comment

Hyperlink to open mulitple Web Intelligence documents by Open document functionality

Open document syntax to open multiple reports in single hyperlink we can link two or more reports in a single hyperlink, this can be achieved by injecting an javascript inside the open document URL. let me first tell some basics … Continue reading

Posted in Business objects Web Intelligence | Tagged , , , | 5 Comments

CREATING HYPERLINK IN WEB INTELLIGENCE

  1.      Create two reports in Web Intelligence and export both to the Central Management Server. Since the object has to be passed to the second report, create the second report with user prompts which is going to get the … Continue reading

Posted in Business objects Web Intelligence | Tagged , , , , , | 41 Comments

Rolling calculations in web intelligence by row wise

In webi  we can calculate the rolling sum by using two functions as per my knowledge, In the following example, i have used efashion  sample universe from Business Objects They are RunningSum() and Previous(self) functions while using RunningSum() function we … Continue reading

Posted in Business objects Web Intelligence | 2 Comments