Skip to Content
avatar image
Former Member

Read transactional data from a BPC cube

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 15, 2017 at 07:31 AM

    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/

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 19, 2017 at 04:26 PM

    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

    Add comment
    10|10000 characters needed 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...