Business Objects 4.0 SP2 Webi Report Repointing Issue and Solution

[former_member203716]

Business Objects 4.0 SP2 Webi Report Repointing Issue and Solution

Issue :

When we try to repoint report which is having more than one data provider/query from existing universe to New Universe, after repointing the Report Cells/Variables will get distorted.

Reason :

When we repoint the report to the New Universe all the Merge Dimensions from different queries will Unmerge and then Repoint to the New universe and then these dimensions will Merge back. Because of this, after repointing, all the cells of the report which are using these merge dimensions will be showing "??" instead of actual Merge Dimension. Also all the Variables using these merge Dimensions will be showing "??" instead of actual Merge Dimension.

Solution :

Step 1: Before we repoint note all the variables and Cells using Merge Dimensions. Also note down the logic Used by these Variables and Cells.

Step 2: Repoint the Report to New Universe.

Step 3: Replace all the Variables which are using Merge Dimension with the Logic that you have noted before Repointing.

Step 4: Replace all the Cells in the report which are using Merge Dimension with the Logic that you have taken Before Repointing.

After this you will get the same Report, repointed to the New Universe without any errors or Issues.