Skip to Content
author's profile photo Former Member
Former Member

How to map custom dimension to a constant valuin the system constants file

I have an application set containing a custom dimension.

I would like to know the syntax to use in the system_constants.lgf file to map the custom dimension to a constant.

This is the example of system_constant.lgf file:

// application constants (Planning Application)

//----


*FUNCTION CATEGORYDIM=CATEGORY

*FUNCTION TIMEDIM=TIME

*FUNCTION CURRENCYDIM=RPTCURRENCY

*FUNCTION ENTITYDIM=ENTITY

*FUNCTION ACCOUNTDIM=P_ACCT

*FUNCTION DATASRCDIM=P_DATASRC

Assume I have a custom dimension called P_PRODUCT and want to define a constant for it, what's the syntax to use?

I want to refer the dimension via that constant in the script logic.

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Sep 03, 2009 at 08:22 PM

    Hi Sanjay,

    the system constants file is for defining the names of dimensions by dimension type. For example you can define the name of the dimension of the type account as ACCT, the name of the dimension of the type entity as LOB etc. Looks like you want to define a constant dimension member for a custom dimension or in other words restrict the custom dimension to a constant value (which is the dimension member of that dimension). Is that right? If so, you can do so in the scoping statements of the logic instead of system constants.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.