Hyperion Essbase (MOSC)

MOSC Banner

ASO Allocation EXCLUDERANGE syntax question

edited Jan 4, 2013 8:52AM in Hyperion Essbase (MOSC) 9 commentsAnswered
I am developing an allocation script and need to be able to exclude certain members identified by UDAs from the allocation.  When I try to use the UDA function in the excludedrange specification I cannot find a solution to the requirement to have the excluded range statement in double quotes as well as the UDA value. Script is as follows:

execute allocation process on database app.db with
pov "Crossjoin({[Final]},
Crossjoin({[b701]},
Crossjoin({[c21001]},
Crossjoin({[i000]},
Crossjoin({[All Reports]},
Crossjoin({[All Channels]},{[a41510]})
)))))"
amount "[PD08]"
amountcontext "([l0999],[Act],[2013])"
target "([Alloc],[PD08],[2013])"
range "Attribute([Status_Open])"
excludedrange "UDA([Location], "Exclude_Alloc_1")"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center