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…
Analysis: During one of my Webi report development, I need a universe level Prompt which allow user to select the values from LOV or enter their own input into that prompt. In the Development phase as a developer I used to purge all of the data from reports before I release the reports to UAT…
Purpose A Universe should be designed to deliver reports that maximize the performance of data returned. Database delegated measures are a feature in universe design that can greatly impact reporting delivery. Benefits of Smart Measure Database delegated measures can improve query performance. Taking advantage of this built in feature can give a great boost to…
DWBI castle 