Skip to Content
0

Read transactional data from a BPC cube

Jul 14, 2017 at 08:28 PM

65

avatar image
Former Member

Hello Experts!

I'm using SAP BPC 10.0

I need to read a data stored in a BPC cube to retrieve the currency in which a particular record was created.

I already have key to search the registry.

Then I need to filter records for that currency to process and perform calculations.

The statements I have found, are all for filtering master data, but I need to filter on transactional data (cube).

Example:

Source record from which I must take the currency (from the cube)

Where should I apply the filter.

I know that it can be done through BADI, but it is too late to implement that solution in the project, but that question is whether there is any sentence that will return that value. Thank you in advance!

registro-cubo.jpg (48.7 kB)
script-logic.jpg (50.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Jul 15, 2017 at 07:31 AM
0

I am unable to understand calculation logic you want to achieve...

Please read: https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jul 19, 2017 at 04:26 PM
0

Hi Vadim.

Sorry for not describing the problem well.

I need to assign to a variable the value that has the dimension: "CURRENCY" of a particular records that was loaded into the BPC cube.

I already know which is the key that identifies the desired record, but I do not know the sentence to read the value.

I hope I have been clearer in the description.

And from now, thanks for your patience.

Regards

LUCAS

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Sorry, but still not clear!

"I need to assign to a variable the value that has the dimension: "CURRENCY" of a particular records that was loaded into the BPC cube." - looks like you didn't read the link I provided.

Please start from the very beginning with a clear sample.

P.S. I am unable to get the logic from the script you posted...

0