3396583 - Error using ADD_WORKDAYS function in Datasphere

When ADD_WORKDAYS function in used within an underlying view to the Analytic Model, one of the following error occurs during the preview: 

• "The query executed with errors. Caught exception : exception 70002048: column store error: exception 334060: Could not read working days information from TFACS table "SPACE#XXX"."TFACS" - invalid table name: Could not find table/view TFACS in schema [....]"
• "The query executed with errors. Caught exception : exception 70002048: column store error: exception 334060: Could not read working days information from TFACS table "SPACE"."TFACS" - insufficient privilege: Detailed info for this error can be found with guid 'xxxx' at Authorization/insuffPriv/impl/InsufficientPrivilegeThrow.cpp:343" 

SAP Datasphere

Wrap the table TFACS in a view and mark this view as exposed for consumption. Reference this view in your corresponding calculation. 

When naming the view, follow the procedure described to syntax element <table_name_suffix>- place a suffix in the view (e.g. TFACS_ABC). 

Preliminary Currency Conversion in SAP Data Warehouse Cloud

dwc, WORKDAYS_BETWEEN, priviledge  , KBA , DS-MD , Modeling (Data Builder) , Problem