Pivot View Grand total issue from UNION queries in OBIEE

In OBIEE, if the report has to create based on the pivot view using UNION of 2 or more queries then there is possibility of pivot view grand total issue because server will compute and picks up random value shows in the pivot view grand total.

Issue with grand totals before changes.

To overcome issue, Click on the measures column in the pivot view edit and set aggregation rule to “SUM” instead of “default”.

After setting aggregation rule to "SUM" instead of "default" the results in pivot view Grand total calculates exactly as shown below.

Issue with Prefix Zero for a values when downloading a report in excel Format in OBIEE

In OBIEE , Generally we came the issue with the values having prefix Zero for any attribute.For examples, The report contains column called Item codes which have a value like "00715423".So when you download this report in the excel format then the values under the item code will looks like "715423".

Example: The report looks like as shown below.

When we downloads it to excel then the same will looks like below.

Here, we have noticed that values starting with zero causing the problem. Please follow the below steps to overcome this issue.

We have to change the format of this column to text explicitly by adding the code in the Edit formula section.

After adding the above code and now change the data format to HTML.

Now the run the report and extract to excel. The report will looks good with the values having prefix zero.

errors on logical columns for defining measures using absolete method in OBIEE

the scenario where we have errors on logical columns for defining measures using absolete method when we go for RPD consistency check.

To overcome this issue use the following command in the general section of NQSconfig file.

SUPPORT_OBSOLETE_MEASURES=YES;