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

How to avoid interactive PROMPT in DM Package

Hi,

I need to pass a fixed set of members to a data manager package during its excution. Since the members are fixed it does not make sense to prompt for entering the members. Like here

PROMPT(SELECTINPUT,,,,"%ENTITY_DIM%")

it prompts to enter member values for the ENTITY dimension. Let's say the entity dimension is TERRITORY and members are always A & B in a certain case e.g. I like to calculate something only for A & B territory. Then how to assign A and B to the default selection variable %SELECTION% bypassing this PROMPT command - any thought?

Thanks and best regards

DipM

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jan 27, 2010 at 04:08 PM

    Dip,

    You can use INFO statement to assign some value instead of using %Entity_Dim% and use a variable that is defined in INFO command to your Logic or Dumpload task.

    The other easy way is specify that entity in the logic script using *XDIM_MemberSet entity = A,B without using prompt.

    Then user doesn't need to select entity and it will calculate only for that entity.

    I hope it will help you.

    James Lim.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2010 at 04:32 AM

    Are you running custom logic w/the data manager package? If so, can you not set those constants directly in your logic?

    Otherwise, you could have a variable in your logic and then pass a constant into that variable through the REPLACEPARAM and EQU fields in your data manager package. (see the how to guide on passing dynamic parameters to script logic).

    I have done this in several packages - usually with prompting the user for a value(s), but I believe it works if you code a constant value as well. The caveat I've found is in some scenarios, script logic can only accept a single value into the variable (in a SELECT and XDIM_FILTER). But in a WHEN it will take as many values as you want to pass in.

    Hope that helps.

    -Amy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2010 at 06:54 PM

    Why not just filtering directly in your script using XDIM_MEMBERSET TERRITORY= ...

    D

    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.