BPC NW 10.0 - Data Manager>Prompt changing from SELECTINPUT to SELECT cleared values

[lisa_savinovich]

Dear BPC Experts,

We recently went from SP13 patch 4 to SP19 patch 1.  When we made changes in the PROMPT values in the Data Manager Organize>Package>Modify Script>PROMPT, we experienced different behavior switching from SELECTINPUT to SELECT in our development system than we did in our production environment.  In development, when we changed the value from SELECTINPUT to SELECT, the values entered for Variable name such as %SELECTION% in Property1 and "Select the members to CLEAR" in Property2, and %DIMS% remained.  However, when we changed from SELECTINPUT to SELECT in production system, the values for Variable Names and Properties were cleared out.  Does anyone know why in our developmet system values were kept but not in our production system during this type of activity?  I would like to understand the two different behaviors and what controlled it.  We prefer not to have the values for Properties clear.

Thank you in advance for your assistance.

Kind regards,

Lisa

[former_member186338 · Accepted solution]

Hi Lisa,

What do you mean by "However, when we changed from SELECTINPUT to SELECT in production system, the values for Variable Names and Properties were cleared out. "???

What is variable names value??? What properties you are talking about?

Vadim

P.S. Screenshot is the only solution to clearly explain the issue!

[lisa_savinovich · Accepted solution]

Hi Vadim,

Excellent point, I should have included images as that likely would have shown this odd behavior.

When I made the changes in our development system to a package to switch from SELECTINPUT to SELECT the values outlined in the image below were retained for Varialbe Name, Property 2, and Property 3 after we applied the SP19 patch 1.

When I made the same change in our system to a package in our production system after we applied the SP19 patch 1, the values for Varialbe Name, Property 2, and Property 3 were cleared per the image below.  The odd thing is that initially it looked like the values stayed.  It was only after you saved and went back in did you see that the values were gone.

Any help in understanding this behavior change would be greatly appreciated.

Thank you,

Lisa

[former_member186338 · Accepted solution]

Hi Lisa,

I never use this screen to change the advanced script! I always press the Advanced button:

and perform changes here:

Vadim

P.S. The real script is on the screen "Modify Script", the previous screen is just an attempt to parse script text to some table...

[lisa_savinovich · Accepted solution]

Hi Vadim,

Your advice to go to the Advanced button is very helpful.  When I use it to switch SELECTINPUT to SELECT, all values are retained.  I will change the script this way from now on.

Thank you!

Lisa

[former_member186338 · Accepted solution]

You just work with a text file with ability to copy/paste etc...

[Former Member · Accepted solution]

This message was moderated.