Automatic Generation of HANA Views from BW into HANA
we face the following problem on my current project. We are generating automatically HANA Virews from InfoObjects. As part of the automatic generation there are also come currency fields and their description is coming from TCURT table which is MANDT dependent. The problem is that during the JOIN between our main master data table and the TCURT table, the master data are being multiplied by the number of clients existing in this table. For example if we have three MANDT we get the same master data three times which in turn creates many problem when we JOIN our master data with any transactional data.
The solution we have implemented is that we copy the generated model, we filter with a projection on the MANDT we need and then it is fine. But in this way we lose the connection to the original object and then every time the object will be re-activated we lose the information for the newly generated view.
Have you faced sth similar? Do you know how SAP recommends to proceed with these problems?
HANA information views have a client handling feature (check SAP HANA Developer guide for section "Cetting Up the Analytic Model" of find "session client" word pair), so you have to set the client parameter for the user you use for data consumption. I have no multiclient installation to check, but try the next steps:
1. Execute SQL: alter user my_user set parameter CLIENT = '100'. Client value is a string literal for required MANDT. You must have the apropriate privilege to change this.
2. Try to read data from this view with this user. It must be client-specific.
View property that allows you client-dependant data is highlighted at attached screenshot (BW-generated view has this property set to "session client").
Information about user parameters you can find here.
Please, let me know of test results.