What's new in Customer Journeys?

Connect and learn more! ×
OTBI computed field and graph — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI computed field and graph

Question
43
Views
0
Comments

Summary

creating computed field and graph

Content

Hi all, 

I am very new to Oracle Fusion business intelligence. 

Background:

  • Fusion 19C 
  • try to analyze the company's employee expense reports by taking the "Expense - Expense Transactions Real Time" subject area
  • Analyses report include these fields: "Report Number", "Report Status", and "Expense Report Total"
  • Computed fields: 
    • "Report Threshold", formula: CASE WHEN "Expense Report Amounts"."Expense Report Total" >= 500  THEN '>=500'   ELSE '<500' END
    • "Report Count", formula: ABS(1)*1
    • as you can see in the attached picture #1 - "Report Threshold" has the "measure" type icon, and the "Report Count" has the dimension type icon.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!