cancel
Showing results for 
Search instead for 
Did you mean: 

BPC MS *XDIM_MEMBERSET <DIM_NAME> AS %VAR_NAME% = BAS(NODE_X)

GFV
Active Contributor
0 Kudos

Hi guys,

I need to Base Members of a given Node into a Variable.

Using *SELECT is not an option, because you cannot use "BAS(NODE_X)" as filter.

In this post about BPC NW I've seen that a new form of *XDIM_MEMBERSET can be used:

*XDIM_MEMBERSET <DIM_NAME> AS %VAR_NAME% = BAS(NODE_X)

the addition "AS %VAR_NAME%" assigns the value to the %var_name%, without changing the scope of <Dim name>.


Unfortunatelly the same syntax seems not to be valid in BPC MS:

We cannot symple use:

*XDIM_MEMBERSET <DIM_NAME> = BAS(NODE_X)

Because this would change scoping and member ids won't be listed into a variable.

Any idea or suggestion?

Thanks in advance

GFV

Accepted Solutions (1)

Accepted Solutions (1)

GFV
Active Contributor
0 Kudos

In order to solve the issue we used:


*MEMBERSET (%VAR_NAME%,DESCENDANTS([<DIM_NAME>].[NODE_X],99,LEAVES))

Answers (1)

Answers (1)

former_member210696
Active Contributor
0 Kudos

May be something like below -

*SELECT(%ACC_SET%,"[ID]",ACCOUNT,"[PARENTH1]='PL600'")

Haven't tried this in system but give it a shot and see if it works?

Regards,

Ashish

GFV
Active Contributor
0 Kudos

Dear Anish

but what about in multilevels hierarchy?

Suppose PL600 has no base member under itself, but other nodes ...