BPC NW 7.0 script logic

[Former Member]

Does anyone have experience with playing around with script logic in BPC 7.0 for NW?

I'm trying out some simple things but several functionalities do not seem to work or I'm missuing them.

eg *SELECT(%PACCT%, ID, P_ACCT, [YTDPLONBS] =Y)

*XDIM_MEMBER_SET P_ACCT=%PACCT%

this selection criterium is not withheld, instead all P_ACCT members are in result.

further I'm looking for statement instead of *XDIM_MEMBER_SET P_ACCT<>INVALID, which does not seem to be accepted.This should force the logic to look across all memebers of the selected dimension at all time.

Any help is appreciated.

thks

[Former Member]

Several of the Script logic key words have not been finalized in to the 7NW product, but work continues to add the information. I don't have the full list in front of me, but common BPC for Microsoft words are not yet enables. Each Service PAck in NW will address certain key words. I will look for the list.

Hope this helps.

[Former Member]

Petar

If there would be a list available with the up to date script logic statements available per SP under BPC 7 for NW, with eventual details around eventual changed syntax or functionality this would be helpful.

If you have such a document I would be interested in having a look at it.

thks

[Former Member]

Here are the items available for NW SP00,01. Soory I dont have details on each, but assume that may be found in the HELP files posted on the SAP marketplace.

Technical Keywords

*CALL_CUSTOM_LOGIC for ABAP programming

START_BADI/END_BADI for ABAP programming

*XDIM_MAXMEMBERS

*COMMIT

RUN_PROGRAM/ENDRUN_PROGRAM

RUN_ALLOCATION/ALLOCATION/ENDALLOCATION/RUNALLOCATION

WHEN/IS/REC/ENDWHEN As of 7.0 SP01, Dimension.Prop Usage is not supported currently.

Scope Definition / Defining a region of the cube

*XDIM_MEMBERSET

*XDIM_MEMBERSET AS {variable name}, = {member set} *SCOPE_BY *XDIM_ADDMEMBERSET {added member set} *XDIM_FILTER = dimension.properties("property") = "value" AND ...

*XDIM_GETMEMBERSET (work with other keywords: *App, *XDIM_MEMBERSET, *XDIM_CRITERIA)

*XDIM_MEMBER = {member A} TO {member B} *XDIM_DEFAULT = {member set}

*XDIM_MEMBERSET = BAS({member name})/DEP({member name})/ALL({member name})

Condition

IIF construction

*SELECTCASE / *ENDSELECT

Variable Handling

*SELECT as variable

Text Concatenation / Code replication

*BEGIN / *END

*FUNCTION [ / *ENDFUNCTION]

*SUB (Param1,Param2,u2026.) / ENDSUB

*INCLUDE

FORu2026NEXT

ADDu2026ENDADD

*SYSLIB

*USE

%USER%

%APPSET%

%APPLICATION%

%YEAR%(+/-n)

%_SET% %_Dim%

%block_status%