SAP Business Objects / BI 4.0 would cover all the topics about Business Objects Universe Design, Reports (WEBI, WEBI Rich Client), CMC (security), Infoview, Scheduling, RCT and Translation Management Tool.
Problem Description: Daily transactions are loaded into database on daily basis along with Date. There is a requirement to schedule the reports on each and Every Quarter end and display the data for 3 separate tab for each month of the quarter and send it to users. Example -1, Refresh the report on April 01,…
Derived table is not a physical in database however its logical table created in Business Objects Universe using SQL. Derived table can be considered like views in database where its structure is defined using SELECT statement. Create Derived table in universe Designer: Either goes to Insert – Derived table or right click in the universe…
Duplicate Context Imagine you have a context which has huge number of joins selected and you want to create another context for same joins along with some more joins. Click the existing context and right click from any of the joins selected. New context pop up window will appear along with all the selected joins.…
Hierarchies and Drilling are inter-related wherein hierarchies should be defined in universe to do drilling in the report. Drilling hierarchy determines the drill path from high-level summary data to low-level detailed data. Drilling is used to perform analysis based on trends in the required data that can be recognized when looking at low-level detailed data.…
Information Design Tool (IDT) is a metadata design environment that enables a designer to extract, define, and manipulate metadata from relational and OLAP sources to create and deploy Business Objects universes. Universes created using the information design tool can be used by the following SAP Business Objects data analysis and reporting applications starting with version…
This was a strange issue when we open a excel format report (Deski report converted to excel through scheduler) “File Error: data may have been lost.” Tried to analyze the issue and checked the option available in the scheduler. Currently we have been using “xls” for the report and tried to change to “xlsx” and…
Merge Dimension / Data Synchronization Merged dimensions are the mechanism for synchronizing data from different data providers. If the report has 2 data providers with common named dimension and same data source, those objects would merge automatically in Deski & Webi report (auto Merge option should be enabled in Webi). Webi report has more option…
Row security is one of the powerful restrictions by user or Group level and it’s frequently used in restricting the region / country wise data when management level decision making reports. Row Level Security can be done at universe level in universe designer. The restrictions can be any one of the below reasons. 1. Restrict…
Query Builder is one of the powerful administrative tools in Business Objects and it’s used to query your BO repository to get all kinds of information which is not even available in CMS. It is available only in BO XI R2 and adobe versions. BO repository has set of tables to store BI information such…
Aggregate Aware is one of the powerful functions in BO and very common / famous function in Business Objects Designer and reports. It will speeds up the execution of queries, improving the performance of SQL transactions using database Aggregate Tables. Note: When you have Daily & Monthly tables with same set of columns, you can…
DWBI castle 