Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

* Select part of variable in BPC 10 NW


Hi Experts,

Please help in  getting correct syntax  for below requirement.  may be easy one but i am not getting it.

i have entity as below

( PARENTh)    1000ENT

memebrs               1000A

                             1000B

                             1000C

                      2000ENT

                           2000A  

                           2000B

                           2000C

now i want to read Bas of 1000ENT(example) and write it to 1000A, it should dynamically work.

Script  what i got so far.   if %ENTITY_SET% = 1000ENT , %TIME_SET% = 2014.MAR

*SELECT (%ENT%, "[ID]", ENTITY, "[ID] = '%ENTITY_SET%'")

// Selects Entity ID.  in this case 1000ENT

//How to make the selection of left 4 of %ENT% ????

*XDIM_MEMBERSET ENTITY = BAS(%ENTITY_SET%)

*WHEN TIME

*IS %TIME_SET%

*REC(EXPRESSION=%VALUE%, ENTITY = ????A  )

System details : BPC 10 NW - HANA

Thanks in advance

Pavan

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question