What is query stripping and how it is been helpful for you in your report performance? To Know about Query stripping, you should aware the concept of microcube. Microcube is a kind of cache and each & every object that are included in your report query will be computed in the microcube, irrespective of whether…
Optional prompts concept only available in Webi reports and we cannot define the Optional prompts through universe predefined conditions / prompt and it can be done only at report level and also it cannot be shared with other report. If you want to use the same optional prompt for multiple reports, then you must create…
Many of us are not aware of this LISTAGG function in BO universe since this is an ORACLE 11g function and should work well in BO when you use ORACLE DB. List Aggregate (LISTAGG) LISTAGG is a built-in function that enables us to perform string aggregation natively. String aggregation is a popular technique, and there…
There are many tools available under SAP BO suite and I have listed most of the BI tools online tutorial (interactive / video formats) and it’s free for everyone to lean SAP BO tools and each tool has different components that are used in BO development. Please click the below tools whatever you want to…
SAP BO Web Intelligence is a query, reporting, and analysis tool used to build reports from relational and OLAP data sources and to analyze data using features such as filters, conditional formatting, and data tracking. Customizable Web Intelligence application interface In the CMC, the BI administrator can change how the Web Intelligence interface appears for…
BI launch pad – A Web-based application delivered as part of SAP Business Objects Enterprise and intended for users and content administrators (formerly known as InfoView). Business filter – A filter created in the business layer editor, made of expressions containing only objects in the business layer. Business Layer – Collection of objects (dimensions, hierarchies,…
A join is a condition that links the data in separate but related tables. The tables usually have a parent-child relationship. If a query does not contain a join, the database returns a result set that contains all possible combinations of the rows in the query tables. Cardinality Check Cardinalities further describe a join between…
SAP Business Objects BI 4.0 SP2 Server Installation process involved many stages and here I have explained all the stages. Run the setup.exe from Business objects 4 server Folder for 64 Bit. Click OK. Above screen verifies your system whether you have enough configuration to install SAP BO BI 4.0 server. If all the critical requirements are…
This blog describes the basic concepts of report design in Crystal Reports and helps you to decide what information you want to include in your report. The report design canvas is the area where you design the structure of your report. You can place various elements on the canvas including data objects, charts, and text…
The upgrade management tool (UMT) guides you through the process of exporting business intelligence content (user accounts, groups, folders, reports, universes, security, and other objects) and upgrading it to SAP Business Objects to SAP Business Objects BI 4.0. UMT is found under the SAP Business Objects BI Platform folder and is installed as part of…
DWBI castle 