Keep Only Function In Smart View Retrieval Not Working as Expected
(Doc ID 2994086.1)
Last updated on DECEMBER 21, 2023
Applies to:
Oracle Enterprise Planning and Budgeting 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
Keep Only Function In Smart View Retrieval Not Working as Expected
~~
Dynamic Calculations in Hybrid Aggregations Are Not Working As Expected
~~
There have been issues with smart view retrieval with in this application while retrieving an account member that is dynamic and has a member formula. When we use "Keep only" function of smart view with refresh it only keeping data values for the first child value even though the data exists for all of these members.
Example
IF(@ISMBR("Jan"))
1;
ELSEIF(@ISMBR("Feb"))
2;
ELSEIF(@ISMBR("Mar"))
3;
ELSEIF(@ISMBR("Apr"))
4;
ELSEIF(@ISMBR("May"))
5;
ELSEIF(@ISMBR("Jun"))
6;
ELSEIF(@ISMBR("Jul"))
7;
ELSEIF(@ISMBR("Aug"))
8;
ELSEIF(@ISMBR("Sep"))
9;
ELSEIF(@ISMBR("Oct"))
10;
ELSEIF(@ISMBR("Nov"))
11;
ELSEIF(@ISMBR("Dec"))
12;
ENDIF
~~
Another example:
When retrieving dynamic member and YearTotal data displays as #missing for account. However if we add either is not dynamic in the same retrieval sheet, data displays correctly.
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 |
| Cause |
| Solution |
| References |