ASO calculation issue — 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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

ASO calculation issue

edited Jun 29, 2020 1:12PM in Planning 4 comments

Summary

Webform doesn't open

Content

Hi

In PBCS application, ASO cube,

  1. Period dimension is dynamic
  2. Account dimension is dynamic as well, and we want to compute account as average for Total Year (for example FTE)

We wrote this first formula :

IIF(IsUda([Indicateur].CurrentMember,"MOYENNE"),Avg([M01]:[M12]),Sum([M01]:[M12]))
When I try to open the Webform (which call this formula) it's stuck because the calculation process is too long (more than 15' and I killed it)
For the record, the formula is correct and working for few employees but it doesn't work anymore for my all database (200 records)
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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