Multiple default schemas

[justin_molenaur2]

In calc views and stored procedures, we of course have the option to select a default schema. This allows tables to be referenced without specifically mentioning the schema (DEV, QA, PRD for example). During import, schema mapping will handle the conversion from the logical to the physical schema.

With the above in mind, it seems that there is only support for one default schema, say ECC DEV/QA/PRD. What happens when another schema is actually required, say from a CRM system? Is it possible to have dynamic logical schemas that refer to two different schemas?

Thanks,

Justin

[lbreddemann]

Hi Justin,

Currently this is not possible.

The requirement - multiple application schemas in one SAP HANA system that should be mixed during reporting - is not the use case the SAP HANA reporting features are designed for.

As of today, the multi source integration either has to be done into a shared SAP HANA schema via SLT or SAP DataServices or by using SAP BW on HANA.

Obviously there is so much more to consider when mixing different schemas than just the schema name. Personally I don't think that this would be a good feature to have. I believe it would more add to confusion than help with anything.

my 2 ct

- Lars