Currency tables: Using your own SCHEMA

1484 Views

I would like to use currency tables in my own schema creating them in a project.

HANA revision v 56 (Amazon developer edition)

Steps I've done so far:

1. Created a project.

2. Created the hdbschema, hdbtables, hdbtim, hdbtid, hdbrole objects - using the SAP_HANA_EPM_DEMO as the guide. Activate and import data into the tables. Assign the roles to the SYSTEM user.

3. Create a calculation view with a measure (type: amount with currency)

In the properties of the calc view, the currency schema is set to my schema (CURRENCY). The system only shows CURRENCY and SAP_HANA_EPM_DEMO as valid choices to select the schema. The client is set to 001 as loaded in the files.

The problem.

When I try to use the currency translation in the measure by following these steps

Select - Enable for conversion.

Click the target currency selector.

Choose "Fixed".

I get the error

System tables for currency conversion is missing in the default schema.

This doesn't happen with the SAP_HANA_EPM_DEMO schema - even though the tables and permissions are identical.

As anyone successfully created currency tables prefixed with a package name in any other schema?

Further notes:

I was able to get it working by recreating the tables without the package prefix i.e.

CREATE TABLE "CURRENCY".TCURC as (SELECT * from "CURRENCY"."CurrencySet.data::TCURC");

CREATE TABLE "CURRENCY".TCURF as (SELECT * from "CURRENCY"."CurrencySet.data::TCURF");

CREATE TABLE "CURRENCY".TCURN as (SELECT * from "CURRENCY"."CurrencySet.data::TCURN");

CREATE TABLE "CURRENCY".TCURR as (SELECT * from "CURRENCY"."CurrencySet.data::TCURR");

CREATE TABLE "CURRENCY".TCURT as (SELECT * from "CURRENCY"."CurrencySet.data::TCURT");

CREATE TABLE "CURRENCY".TCURW as (SELECT * from "CURRENCY"."CurrencySet.data::TCURW");

CREATE TABLE "CURRENCY".TCURX as (SELECT * from "CURRENCY"."CurrencySet.data::TCURX");

So it works when the currency tables do not have a package prefix.

Any insight appreciated!