cancel
Showing results for 
Search instead for 
Did you mean: 

DM Package (Clear) for a specific CATEGORY but allow User defined on others

0 Kudos

Hello Experts,

We are running Netweaver, Version 10.0 SP13

We are trying to create a DM Package that will clear data for a specific and non-selectable CATEGORY Member ID but allows Users to make their own selections on several other Dimensions.

By locking the Package down to a single CATEGORY we can offer our End Users the flexibility to clear different intersections of their own data (as and when required) but mitigate any risk that this type of activity can pose to the rest of the data in our Model.

For some Dimensions, this could default to <ALL> so it would not be necessary for the End User to see these Dimensions in the PROMPT box.

This table shows our Dimensions and how we would like to handle each Dimension:

DimensionDimension TypeDM Package Requirement
ANALYSISS<ALL>
BRANDUUser must be able to select
CATEGORYC

Fixed/Non Selectable

Member ID: ACT_MKT_ID

CUSTOMEREUser must be able to select
DATASRCDUser must be able to select
INDUSTRYU<ALL>
METRICA

User must be able to select

(Ideally limited to just MC_MKT and MC_RT)

PRODUCTUUser must be able to select
RPTCURRENCYR<ALL>
SUPPLY_SITEU<ALL>
TIMETUser must be able to select

Please explain how we could do this.  Any help or suggestions would be very much appreciated.

Thanks

Jo

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hello Vadim

Thank you, the information on SELECTINPUT and COMBOBOX is really helpful.  I am looking forward using COMBOBOX in other packages that we use.

I am almost there with my script below - it correctly clears data from a fixed CATEGORY, restricts METRIC to just two members and is User defined on ENTITY, DATASRC and TIME.

INFO(%SELECTION_KEYDATE%,)

INFO(&PREFIX%,@@@SAVE@@@@@@EXPAND@@@|)

INFO(%CATEGORY_SEL%,DIMENSION:CATEGORY|ACT_MKT_WK|)

PROMPT(COMBOBOX,%COMBEL%,Select METRIC from dropdown,0,MC_MKT,MC_RT,METRIC)

PROMPT(SELECTINPUT,,,"%ENTITY_DIM%,%DATASRC_DIM%,%TIME_DIM%,%ACCOUNT_DIM%")

TASK(/CPMB/CLEAR_CUBE,CHECKLCK,%CHECKLCK%)

TASK(/CPMB/CLEAR_CUBE,SELECTION,%SELECTION%%CATEGORY_SEL%,DIMENSION:METRIC|%COMBESEL%|)

TASK(/CPMB/CLEAR_CUBE,DUMPLOADMODE,3)

TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,SELECTION,%SELECTION%)

TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,ENABLETASK,%ENABLETASK%)

TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,CHECHLCK,%CHECKLCK%)

Despite reading lots of information on this, I just cannot figure out how to include BRAND and PRODUCT so that they appear in the SELECTINPUTscreen, both are Dimension Type U. 

Any ideas? 

Thank You

Jo

former_member186338
Active Contributor
0 Kudos

Hi Jo,

In your advanced script you don't need the line:

INFO(&PREFIX%,@@@SAVE@@@@@@EXPAND@@@|) - Remove it!

Second - PROMPT(SELECTINPUT...

I have already explained you: "In the dimensions list you can put REAL dimension names or pseudo names like %TIME_DIM% (but only for standard dimension types)."


Use:

PROMPT(SELECTINPUT,%SELECTION%,,,"CUSTOMER,DATASRC,METRIC,TIME,BRAND,PRODUCT")

Or

PROMPT(SELECTINPUT,%SELECTION%,,"%ENTITY_DIM%,%DATASRC_DIM%,%ACCOUNT_DIM%,%TIME_DIM%,BRAND,PRODUCT")

Vadim

P.S. U-type dimensions are specified by real name only (without %xxx_DIM%)

former_member186338
Active Contributor
0 Kudos

P.S.

Error here (comma in red!):

TASK(/CPMB/CLEAR_CUBE,SELECTION,%SELECTION%%CATEGORY_SEL%,DIMENSION:METRIC|%COMBESEL%|)

Use without comma!

TASK(/CPMB/CLEAR_CUBE,SELECTION,%SELECTION%%CATEGORY_SEL%DIMENSION:METRIC|%COMBESEL%|)

Error here (selection scope for comments):

TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,SELECTION,%SELECTION%)

Have to be

TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,SELECTION,%SELECTION%%CATEGORY_SEL%DIMENSION:METRIC|%COMBESEL%|)

Vadim

0 Kudos

Hi Vadim

Your follow up examples helped me to make sense of what you meant by 'start with real dimension names', this is much clearer now thank you.

I can also now see how the 'selection scope for comments' was incomplete and by example, which has unlocked a better understanding.

I have corrected the code as above, the package runs perfectly!

Thank You for your assistance

Joanne

Answers (2)

Answers (2)

0 Kudos

Hi Vadim

Thank you for such a quick response.

My first attempt (using the logic that I posted previously) worked out pretty well, it cleared the correct intersection but did not display BRAND or PRODUCT as selectable Dimensions in the Prompt screen.  Do you know if this is because they are User defined Dimensions?

Thank you for your suggestion, I have tried but I seem to have interpreted it wrong:

PROMPT(SELECTINPUT,%SELECTION%,,,"CUSTOMER,DATASRC,METRIC,BRAND,PRODUCT")

INFO(%CATEGORY_SEL%,DIMENSION:CATEGORY|ACT_MKT_WK|)

TASK(/CPMB/CLEAR_CUBE,SELECTION,%SELECTION%%CATEGORY_SEL%)

TASK(/CPMB/CLEAR_CUBE,DUMPLOADMODE,3)

TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,SELECTION,%SELECTION%)

TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,ENABLETASK,%%ENABLETASK%)

TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,CHECKLCK,%CHECKLCK%)

But the Prompt only pops up with:


Thanks

former_member186338
Active Contributor
0 Kudos

Sorry, but:

PROMPT(SELECTINPUT,%SELECTION%,,,"CUSTOMER,DATASRC,METRIC,BRAND,PRODUCT")

Will NEVER generate the prompt:

Please read SELECTINPUT help: SELECTINPUT Prompt() Command - SAP BusinessObjects Planning and Consolidation - SAP Library

In the dimensions list you can put REAL dimension names or pseudo names like %TIME_DIM% (but only for standard dimension types).

Vadim

0 Kudos

Please see first attempt, Advanced Logic Script below:

INFO(%SELECTION_KEYDATE%,)

INFO(%PREFIX%,@@@SAVE@@@@@@EXPAND@@@|)

INFO(%CATEGORY_SEL%,DIMENSION:CATEGORY|ACT_MKT_WK|)

PROMPT(SELECTINPUT,,,,"%ENTITY_DIM%,%DATASRC_DIM%,%ACCOUNT_DIM%,%TIME_DIM%,%BRAND%")

TASK(/CPMB/CLEAR_CUBE,CHECKLCK,%CHECKLCK%)

TASK(/CPMB/CLEAR_CUBE,SELECTION,%SELECTION%)

TASK(/CPMB/CLEAR_CUBE,DUMPLOADMODE,3)

TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,SELECTION,%SELECTION%)

TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,ENABLETASK,%%ENABLETASK%)

TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,CHECKLCK,%CHECKLCK%)

former_member186338
Active Contributor
0 Kudos

Hi Jo,

Start with (with real dimension names):

PROMPT(SELECTINPUT,%SELECTION%,,,"CUSTOMER,DATASRC,METRIC,TIME,BRAND,PRODUCT")

...

then:

TASK(/CPMB/CLEAR_CUBE,SELECTION,%SELECTION%DIMENSION:CATEGORY|ACT_MKT_WK|)

or

INFO(%CATEGORY_SEL%,DIMENSION:CATEGORY|ACT_MKT_WK|)

TASK(/CPMB/CLEAR_CUBE,SELECTION,%SELECTION%%CATEGORY_SEL%)

...

etc

TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,SELECTION,%SELECTION%%CATEGORY_SEL%)

Vadim

former_member186338
Active Contributor
0 Kudos

P.S.

METRIC - "Ideally limited to just MC_MKT and MC_RT"

Can be done using COMBOBOX prompt with 2 values: MC_MKT and MC_RT

The result of user selection append to %SELECTION% with:

DIMENSION:METRIC|%COMBSEL%|

Vadim