cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

BPC Standard 10.1 NW Script Logic Issue

sberam
Explorer
0 Kudos
685

Hi Experts,

We have a requirement to extract the members of a dimension based on transactional data as a list using a script logic. Requesting your expertise in giving a solution for the below issue (explained in detail)-

BPC Version- SAP BPC Standard 10.1

SAP BW 750 SP 16

Ø We have a BPC model BPC_NRS with the below list of dimensions:

Account

Category

Entity

Time

Currency

Ø Purpose of the script- To be executed using a data manager package

Use Case: Having the following records sitting as transaction data in the BPC Model. I want to read Account Dimension values (1000, 1001 etc.) in a variable or list where Entity Dimension Value = “E2” and Time Dimension Value = “2022.Nov”.

Our Trials:

1. Investigated if we can make use of *SELECT Statement

But Select statement only allows to work against the master data of one dimension. However, my requirement is to read the dimension members list (and not signed data) from the transaction data.

2. *LOOKUP

Lookup also is used to lookup “values(signed data)” and returns/manipulates “values” instead of member list.

Appreciate your suggestions and thank you in advance.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

Short answer: you can't fill script logic variable based on transactional data.

Workarounds can be discussed after understanding of requirements!

sberam
Explorer
0 Kudos

Hi Vadim,

Thank you so much for your input. I have tried to come up with a clear explanation of the requirement. The script provided is currently not working and we are getting an error which is attached beside the script. The script is written to obtain Step-3 using data from Steps 1 & 2.

Happy to provide more details if needed.

Thank you in advance.

former_member186338
Active Contributor
0 Kudos
sberam

Explanation is still not clear.

Your script is incorrect - you can't use SELECT inside FOR/NEXT