Hyperion Essbase (MOSC)

MOSC Banner

Error when run calcscript with @Attributesval into FIX

edited Apr 19, 2014 12:00PM in Hyperion Essbase (MOSC) 1 commentAnswered

Dear All,


I have an application Hyperion Planning 11.1.2.3.500 with Entity dimension associates to a Text Attribute Dimension called PCurrency.

PCurrency contains the currency formatted as  : USD_; EUR_; RUB_ etc.

I want to use that information into a FIX statement through @ATTRIBUTESVAL function :


FIX(@MEMBER(@NAME(@SUBSTRING(@ATTRIBUTESVAL("PCurrency"),0,3))))


In that case into FIX I should to have "EUR" if the Entity that the system is processing has "EUR_" as text attribute.


The syntax check is ok.

When I try to deploy this calcscript via Calculation Manager the system shows the following error message : <<The dimension 'PCurrency' needs to be a text attribute dimension..>> but I'm sure that the Attribute Dimension is a Text Attribute dimension. If I force the deploy the calcscript doesn't work.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center