Skip to Content
avatar image
Former Member

Calculation View Currency Conversion with BW on HANA

Experts,

We are on BW 7.5, HANA SP11.

I have a calculation view based on a generated analytic view from a BW cube.

When I try to use currency conversion in HANA calculation view, the "schema for currency conversion" does not show the BW schema i.e SAP"SID" to use the TCUR* tables. Is it an authorization issue? How can I use the BW TCUR* table to perform currency conversion in HANA?

Any hints is well appreciated.

Thanks and Regards,

Srinivas

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Apr 12, 2016 at 08:44 AM

    Hi Srinivas,

    1. Please Confirm, BW Schema name is SAP<SID>.

    Because It is possible to configure BW schema with other Names as well.

    (In my all systems, BW Schema Name is SAP<SID>.

    But one of my system, BW schema Name configured as "SAPABAP1")

    2. If your schema name configured as SAP<SID>, Then your HANA DB user might not have privilege for this schema. Please check SAP<SID> is shown under catalog node.

    If User does not have privilege for this Schema, Object Privilege has to be assigned.

    3. One more Option which will be used in Side car scenario is,

    Using Data Provisioning Tools (SLT/BODS), Replicate TCUR* Tables

    to User created schema of Target HANA system from Source ECC system.

    User defined schema has to be mentioned as Schema for Currency Conversion

    Regards,

    Muthuram

    Add comment
    10|10000 characters needed characters exceeded