script logic issue??

[former_member225916]

Hi All,

1)  *XDIM_MEMBERSET ACCOUNT = <ALL>

     *XDIM_MEMBERSET ACCOUNT = %ACCOUNT_SET%

What is the difference between above two statements??

2) with out using GET statement can we get the data in MS BPC 7.5??

eg:

*REC(EXPRESSION=GET(TIME="2013.APR"))

*REC(EXPRESSION=[TIME].[2013.APR])

What is the difference between above statements??

Thanks and Regards,

Naidu

[former_member210696 · Accepted solution]

Hi Naidu,

*XDIM_MEMBERSET ACCOUNT = <ALL>  - Initial scope is set to all the dimension members

*XDIM_MEMBERSET ACCOUNT = %ACCOUNT_SET% - With every dimension name, _SET is a reserved keyword which can be utilised if you want to pass the members for that dimension on run time. So, this statement will restrict the inital scope to account dim members which you will pass while running your package.

*REC(EXPRESSION=GET(TIME="2013.APR"))  - You won't probably use such a statement in your script. Your *REC will be accompanied by *WHEN/*ENDWHEN and in that case, you would have already fetched a certain record.

However, a statement like this makes sense to me -

*REC(EXPRESSION=%VALUE%+GET(TIME="2013.APR"),TIME="2013.MAY") - It means the data fetched already should be added to what is stored in 2013.apr and then write it to 2013.MAY.

So basically, with the help of GET, you can apply another value other than the one fetched already and use it in Factor or Expression statments.

*REC(EXPRESSION=[TIME].[2013.APR]) - I don't think this is valid instruction, will have to check it in the system once to give you a confirmation on this.

Regards,

Ashish

[Robert_Jan_Bron · Accepted solution]

*REC(EXPRESSION=[TIME].[2013.APR]) is a statement that would work in the NW version of BPC. Does basically the same as *REC(EXPRESSION=GET(TIME="2013.APR")).

[former_member225916 · Accepted solution]

Hi Ashish and Robert,

Thanks for your suggestions.

Regards,

Naidu

[former_member210696]

Just a thought, you always close your thread as "Assume Answered"..why not by marking "Correct Answer"?