Other

How do you combine universes in Business objects?

How do you combine universes in Business objects?

Merge Common Dimension Objects

  1. CTRL + click the dimension objects you want to merge in the Available Objects pane.
  2. Right-click one of the objects and select Merge from the menu.
  3. Repeat steps 9-10 to create additional merged dimension objects.

What is Extend merged dimension values?

The “Extend merged dimension values” is designed to provide more flexibility in how Web Intelligence handles merged data. In Desktop Intelligence we have for years complained that there is no way to control the merge (join) process.

How do you Unmerge in Business objects?

To unmerge a group of objects, right-click a merged dimension and click Unmerge from the contextual menu.

How do you create a combined query in Business Objects?

To build a combined query

  1. Open a Web Intelligence document in Design or Data mode.
  2. In the Data Access tab, in the Data Providers subtab, click Edit.
  3. Create an initial query in the Query Panel.
  4. Click the Add a Combined Query icon on the toolbar to display the Combined Queries panel beneath the list of query objects.

How do I change a merge size in WEBI?

Posted April 21st, 2016 by dmytro & filed under Web Intelligence. In BO XI 3.1, to edit a merged dimension, we could right click on a merged dimension, and select “Edit merged dimension” from pop up menu, this would open a dialog for editing merged dimensions.

What is query stripping in SAP BO?

Query stripping is a feature that will remove unused (the objects which are not present in report structure) objects from a query automatically to improve performance and reduce the data contained in the microcube.

What is ForceMerge in WEBI?

Webi function ForceMerge can help in this situation. ForceMerge forces Web Intelligence to account for synchronized dimensions in measure calculations when the synchronized dimensions do not appear in the calculation context of the measure.

What is merge dimensions in WEBI?

Merge Dimension. This is a feature in Web Intelligence which allows linking of two or more data providers( queries). Basically we merge objects from two or more queries in one webi report, so that we can use them in same block. Mandatory condition to merge objects is to have same data type.

How do I create a combined query in WEBI?

Procedure

  1. Open a Web Intelligence document in Design or Data mode.
  2. In the Data Access tab, in the Data Providers subtab, click Edit.
  3. Create an initial query in the Query Panel.
  4. Click the Add a Combined Query icon on the toolbar to display the Combined Queries panel beneath the list of query objects.
  5. Click Add a query.

What is a dimension in Business Objects?

A dimension object is the object being tracked; in other words, it can be considered the focus of the analysis. A dimension can be an object such as Service, Price, or Customer.

Author Image
Ruth Doyle