Below are the lists of available Webi XI 3.1 report functions and will describe each & every functions along with example. Webi 4.0 reports are also having same functions with some additional futures. Since the Tables are complex to add in the pages I have uploaded the PDF version of Webi Functions. Please click below…
When you want to do some data processing / analyze in your report data in Excel format, your converted or saved excel report should have proper formatting. For example, excel should not have any merged cells which will make lots of issues when you do analysis / processing your data and look and feel of…
BO Universe Hint is one of the option to improve your Report / Query performance by forcing to optimize your Database servers in different ways. If you have complex report query which has more tables and complex joins, BO Universe level Hint would help to reduce the report refresh time at Query level. Will discuss…
There is a requirement to access the PDF report (Scheduled BO reports saved in PDF format) using BO Deski / Webi report by link. The link should be dynamic whenever the report migrated from one environment to another environment (DEV to TEST or TEST to UAT or UAT to PROD), because PDF reports are different…
We have 4-5 databases for DEV, TEST and PROD and whenever there is an UAT, user will get confused or whoever refreshing the report, they were not able to find which database currently the universe / report was pointed. To avoid User confusion and provide clear information to the user, we have come up with…
This is to discuss about, how a Rank / Top N Country Sales report can be developed based on user Prompt values. Report should display the RANK / Top N country Sales based on the User inputs. If the user selects 10 as input report should display Top 10 Country in the sales wise. .…
Cascading Prompt is an additional feature in BO reports where user wants to input the values from higher level to Granular level which they are not aware. To help them, cascading prompt will provides the facility to Input the values from Hierarchical way (higher level to Granular level). For example, User wants to enter input…
Index Awareness is one of the great features for Query / report optimization in Universe Designer. Index Awareness is the ability to take advantage of the indexes on key columns to speed up data retrieval. Objects we create in Universe Designer are based on database columns with required business names which are meaningful to the…
DWBI castle 