My Oracle Support Banner

BICS: Performance Tile is Incorrect (Doc ID 2303962.1)

Last updated on NOVEMBER 28, 2019

Applies to:

Oracle Business Intelligence Cloud Service - Version 14.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : Oracle Business Intelligence Cloud Service

Performance Tile is behaving  incorrect in BICS Analysis

Here is the Example defining the behavior

1. Take the Product, Revenue, Revenue, Revenue columns.

2. Click on Edit Formula (First revenue column )>> Click on Filter >> Double click on R1 Order Status>> Select the value >> "Cancelled".

3. Click on Edit Formula (second revenue column )>> Click on Filter >> Double click on R1 Order Status>> Select the value >> "Billed".

4. Click on Edit Formula (Third revenue column )>> Click on Column >> Calculate the ratio for the above two columns as below.

FILTER("Base Facts"."1- Revenue" USING ("Orders"."R1 Order Status" ='6-Cancelled'))/FILTER("Base Facts"."1- Revenue" USING ("Orders"."R1 OrderStatus" = '4-Billed'))

5. Click on column properties(Ratio column) >> Go to Data Format >> Treat Number as percentage >> Enable Scale for % (x 100) and select the decimal places >>2

6. Edit table >>Select the Measure >> "After" So that you can see total value.

7. Click on results >> select the view >> Percentage Tiles >> Results.

8. It shows 0.00% instead of 29.40

Changes

 NA

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.