Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OAC calculation formula simplification

Needs Votes
71
Views
0
Comments

Description

Simplify the ability to use and create pre-existing calculations for use in other desired formulas similar to Excel functionality. for example, when calculating a ratio that divides formula 1/formula 2 - in excel you simply take cell number where formula 1 output is located and divide by cell number where formula 2 is located to calculate a ratio regardless of the complexity involved in the first two formulas. In OAC, this functionality does not exist and creates the occasional need to take data out of OAC and put in Excel to easily modify and create additional calculations -or- construct in OAC re-creating complex calculations that are already in place..

 

 

Use Case and Business Need

The premise of this idea is to more easily allow direct use in OAC of calculated numbers in subsequent calculations. Ratios are very common in analytics, dashboards, and KPI measurement so I expect this idea will enable users across industries to better leverage direct and singular use of OAC to meet needs when complex formulas are involved.

More details

I occasionally need to take data out of OAC and work with Excel to save time.

Original Idea Number: 55370bb8fd

2
2 votes

Needs Votes · Last Updated