Data Visualization Calculation Column Using Count Function Displaying Wrong Results
(Doc ID 2713044.1)
Last updated on SEPTEMBER 23, 2020
Applies to:Business Intelligence Suite Enterprise Edition - Version 18.104.22.168.0 to 22.214.171.124.200714 [Release 12g]
Information in this document applies to any platform.
In OBIEE 126.96.36.199 Data Visualization (DV), calculation column is displaying wrong results when set the column formula with count(Column) function. This issue can be reproduced by the following Steps:
1. Create a new Project in DV.
2.Create Data Set by uploading the following excel file data and add to the project.
3.Right click on "My Calculations" and select Add Calculation..
4.Add new column named "TestCol", and set formula to: COUNT(CATEGORY).
5.Click Save button.
6.Click on "Visualize" tab.
7.Add all the columns to a table or pivot.
8.Then can see the wrong results in column "TestCol" is displaying as below:
The product expected results should be as below:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document