PBCS/ EPBCS: ASO Rank Function is Not Working as Expected
(Doc ID 2934445.1)
Last updated on MARCH 22, 2023
Applies to:
Oracle Enterprise Performance Management FreeForm Cloud Service - Version N/A and laterOracle Planning and Budgeting Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Formula with the RANK function on a member BILLABLE_HRS_WORKED with the formula below does not work.
Rank(BILLABLE_HRS_WORKED,Office.CurrentMember,Crossjoin({BILLABLE_HRS_WORKED},{Office.CurrentMember.Siblings}))
Notice on an ad-hoc sheet retrieval the rank is not calculates correctly.
Changes
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 |