Read transactional data from a BPC cube

[former_member189599]

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!

[former_member189599]

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

[former_member186338]

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...

[former_member186338]

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/