Ad Hoc Values Change After Adding Another Account When Using “@ISACCTYPE()” Function
(Doc ID 3002757.1)
Last updated on FEBRUARY 06, 2024
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
Ad Hoc Values Change After Adding Another Account. Only difference between the two is the second includes an additional account both include three other accounts. When refreshing the worksheets, the values in the common accounts are different between the worksheets. The only difference is the retrieval of an extra account, which happens to have no data. (In this case the member is a member formula that presents the value of the account accumulated to date.)
Changes
ESSBASE RETURNS DIFFERENT DATA VALUE WHEN ANOTHER MEMBER ADDED ON COLUMN
SELECT {[Project Gross Margin].[Total Cost of Goods Sold],[AXX0401]}
DIMENSION PROPERTIES MEMBER_UNIQUE_NAME ON COLUMNS
SELECT {[Project Gross Margin].[Total Cost of Goods Sold]} DIMENSION
PROPERTIES MEMBER_UNIQUE_NAME ON COLUMNS,
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 |