For ADD_WORKDAYS we used a variable as last argument in the function: DECLARE V_SCHEMA CHAR(6);SELECT physical_schema INTO V_SCHEMA FROM "_SYS_BI"."M_SCHEMA_MAPPING" WHERE authoring_schema = 'ABAP';
Hi, I had exactly the same issue as you for the point 2 and I achieve to add 2 same datasets using an Open ODS View. For your 3rd point, why not recreate the navigational attributes directly into the second HCPR? At the end the generation based on a ...
