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

Numbers assigned to user defined dimensions

Dear Experts

I have created application set from APPSHELL and created three user defined dimensions viz., A, B and C

Then removed all not required dimensions including 'P_ACTIVITY' which was a User defined dimension.

System has assigned numbers as U4, U8 and U9 to these dimensions on its own (I do not know what is the logic system is following to assign numbers to these dimensions)

Questions:

1. What is the logic system is following for assignment of the numbers to User defined dimensions?

2. Can I change these numbers to U1, U2 and U3 (for ease in ad-hoc reporting). If YES how can I do that?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    Posted on May 31, 2010 at 01:23 PM

    Hi,

    As per my knowledge. Its system defined and we cant change it.

    Please correct me if I am wrong.

    Regards

    Raman

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 01, 2010 at 04:20 AM

    Hi Amar,

    1. When you create user defined dimensions, the system assigns U1, U2, U3 and so on.... Thus User defined dimension has type Un, n points to the number of user defined dimension in the application set.

    2. Since it is assigned by the system, I dont think we can change it.

    Hope this helps.

    Regards,

    Shoba

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 01, 2010 at 05:55 AM

    Hi,

    The userdefined dimensions are named Sequentially as they are created and these are not constant for them, the same dimension may have different names in different applications.

    Also the user defined dimensions are named as Ua to Ux in NW.

    For example, in App1 some dimension X may be named as Uc, the same dimension X in App2 may be named as Ud or some other.

    We need to manually work betweeen "a to x" with the below macro to find the exact name for the user defined dimension in the application.

    "MNU_eTOOLS_MEMBERSELECTOR_X"

    Eg:

    MNU_eTOOLS_MEMBERSELECTOR_Ua

    Also as suggested in earlier replies i dont think this naming can be changed.

    Hope this helps,

    Regards,

    G.Vijaya Kumar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 01, 2010 at 12:51 PM

    HI Amar,

    The Naming Conventions are very simple.which are defind by system..you cant change it..

    In every application it changes it seqence which is defind by system it self..

    But when it comes to NW7.5 no numbering exists..

    Regards,

    Naresh Reddy.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 01, 2010 at 01:46 PM

    Thanks Experts for the quick and helpful reply

    I got the answer that I can't touch the numbers by any way. But still I am surprised how system is assigning those numbers.

    Instead of assigning the numbers in sequence system has assigned U4, U8 and U9. Thats surprising.....

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi CSD

      Thanks for the reply

      I have created application set as copy of APPSHELL

      APPSHELL contains just 1 User Defined Dimension - P_ACTIVITY

      I have created three user defined dimensions I have created viz., FuncArea, ProfitCenter and TransType

      and removed the P_ACTIVITY

      Then the assignment was U4, U8and U10 respectively.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 05, 2010 at 01:55 PM

    Thanks experts

    SAP confirmed that this will be modified in the next release.

    As of now BPC randomly assignes the numbers to user defined dimensions

    Thanks you all for the help

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2010 at 04:08 PM

    Amar or others - how did you discover the number(s) associated with your user-defined dimensions (in MS version 7.0, for another few days)? Also, for setting up a macro, I assume the same logic as the NW version would work, where one could use MNU_ETOOLS_MEMBERSELECTOR_Un (where n is the number of the user-defined dimension). I have tried guessing the number of our user-defined dimension, and it keeps adding the file name as an .htm shortcut to the beginning of the Macro, then saying the file cannot be found. If I don't put a number after it and just use U, it shuts Excel down.

    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.