Hardcode infoprovider for selection in /CPMB/LOAD_INFOPROV_UI

[Former Member]

Hello,

is it possible to hardcode the infoprovider from which data is loaded in the /CPMB/LOAD_INFOPROV_UI process chain?

I can of course replace the file parameter with the name of the infoprovider so data will be always loaded from the . What I need is that just the selection button appears without the need of specifying infoprovider in the line above the selection button.

Thanks for any clues

Jan

[Former Member]

Hi Jan,

If you look at the advanced script of this DM, there is a prompt statement which is used to ask for the infoprovider name and this is stored in a parameter and is then passed to the process chain. You can hardcode the value of this parameter in the process chain directly and you dont need to prompt for the infoprovider name.

Hope this helps.

[Former Member]

Hi,

thanks for your posts.

I don't know if I understood you correctly. This is the prompt for the selection in /CPMB/LOAD_INFOPROV_UI.

PROMPT(INFOPROVIDERSELECTION,%InforProvide%,"%SELECTION%",

I can hardcode the infoprovider instead of the %Inforprovide% variable, but the requirement to input infoprovider for the selection when running the package is still there.

Or should I use some other prompt instead of INFOPROVIDERSELECTION? Thought that this prompt makes the new selection possible.

Thanks in advance

Jan

[Former Member]

Hi Jan,

You can just hardcode the variable. You need not have any prompt statement.

Hope this helps.

[former_member200327]

I think what Jan is saying that even if he hard-codes the variable it doesn't show up in the the pop-up and hence he can't populate %SELECTION%.

[Former Member]

Exactly as Gersh is writing.

I can hardcode the name of the infoprovider so the load is always done from this particular infocube.

But the user still has to fill the name of the infoprovider to be able to restrict the selection. If he doesn't type in the name of the cube, he cannot get into the Set selection button.

Jan

[Former Member]

Hi Jan,

Thats correct. Can you kindly share the entore advanced script? I dont have access to the system. Is the selection going to change everytime?

[Former Member]

Hi Nilanjan,

here is the code:

It is standard, just the transformation and the merge, default logic and workstatus options are hardcoded.

As I wrote before, I would like just the set selection button to pop up, without the infoprovider field.

PROMPT(INFOPROVIDERSELECTION,%InforProvide%,"%SELECTION%",Vnesite u0161ifro kocke ZBPC_OA1 nato klik na Set Selection.,,)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\Liquidity_planning\MESECNA_APP\DATAMANAGER\TRANSFORMATIONFILES\TR_Analytical_plan.xls)

TASK(/CPMB/INFOPROVIDER_CONVERT,SUSER,%USER%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPP,%APP%)

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,%InforProvide%)

TASK(/CPMB/INFOPROVIDER_CONVERT,CLEARDATA,0)

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%SELECTION%)

TASK(/CPMB/CLEAR_DATA,INPUTNO,%TEMPNO1%)

TASK(/CPMB/CLEAR_DATA,CHECKLCK,0)

TASK(/CPMB/APPEND_LOAD,INPUTNO,%TEMPNO1%)

TASK(/CPMB/APPEND_LOAD,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/APPEND_LOAD,RUNLOGIC,0)

TASK(/CPMB/APPEND_LOAD,CHECKLCK,0)

TASK(/CPMB/APPEND_LOAD,CLEARDATA,0)

Jan

[Former Member]

Hi, Jan Pec.

May I know the usage of %INCREASENO% ? What is the value of it ?

Thanks,

Eddy

[RichHeilman]

Yes, in the data manager prompt script, you can remove the input box, and simply hardcode the value being passed to the TASK.

Regards,

Rich Heilman