Personal


Comments

Post a Comment

Popular posts from this blog

SAP BO Universe Performance tunning guidelines

Below are Universe performance tuning guidelines : These guidelines need to followed with Webi performance tuning guidelines given separately on this blog to get good performance reports. • Always use aggregate functions i.e.  Sum, max, min etc with measure objects. • Set the proper query limits at the universe, especially “Limit size of result set to” & “Limit execution time to”. Setting the right parameters will result in a good universe by performance wise • Create aggregated tables for reports taking too much time to execute due to huge data set in underline tables. • List of values: Create LOV’s on small lookup/master tables instead of actual fact table. Avoid LOV on measure and date objects. Remove LOV from non required objects i.e. keep LOV on objects which are going to be used in filters. • Use conditional objects/filters on Universe level to filter out non required data from universe level instead of reports • Push complex calculation of object...
Read more

SAP BO Universe Best Practice check list

Below are best practice guidelines for Universe development • Universe Name & Universe Description should be defined with proper Business Name and description in the Universe properties. • Class name should be started in INIT cap. • Objects name should be started in INIT cap. • Object should be placed in alphabetical order in the class. • Measure Objects in any class should be placed after the dimensions/detail objects. • Always define every object with meaningful description so that it helps user easily understand the purpose of it which avoids going through heavy documentation. • Measure objects should be created with aggregate functions like sum, max, min etc. This will ensure that only required aggregated data is returned to reports instead of whole set of raw data. • Create the context with proper business logic names. It will help you to find out what context is used in a particular report. • Always place any derived tables or isolated tables down ...
Read more

SAP BO web intelligence reports performance tunning guidelines

Below are performance tuning guidelines for webi report development. These guidelines needs to be followed with Universe performance tuning guidelines given separately on this blog to get good performance reports. •  Avoid using larger number of reports in same document 10 reports per document is a reasonable number Do not exceed 20 reports per document • Don’t try to account for all scenarios in one document but rather focus on specific scenarios that add value to the consumer. 50,000 rows per document is a reasonable number Do not exceed 500,000 rows per document • Limit the number of Data Providers used Best Practice from the field is to use no more than 15 Data Providers per document Data providers run serially so run times add up Refresh time and merging of dimensions can cause some big delays on the Processing Server side • Create smaller, reusable documents   By creating smaller, reusable documents you: Reduce the time it takes to load the doc...
Read more