on 09-17-2014 8:15 AM
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
In order to solve the issue we used:
*MEMBERSET (%VAR_NAME%,DESCENDANTS([<DIM_NAME>].[NODE_X],99,LEAVES))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.