Extended @Prompt / Optional Prompt Values in BO

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…

Database Delegated Measures or Smart Measures in BO

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…