SAP Knowledge Base Article - Public

3074333 - Failed to create story with specific DWC view in SAC

Symptom

Got the following error when trying to consume DWC view in SAC:

"SQLScript internal error: Unexpected type: NVarchar[] "

Environment

SAP Analytics Cloud 2021.13.3

Reproducing the Issue

  1. Log on to SAC tenant.
    2. Create story and click add data.
    3. Select data source -"SAP Data Warehouse Cloud" live connection.
    4. Select space and select specific view.
    5. Select view  "GV_DPP_ANALYSIS_AUDIT_LOG" and click OK.
    6. Try to create table or chart with measure and any dimension.

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System,dwc, DWC, live, view, char, data type,
nvarchar , KBA , LOD-ANA-LDC , SAC Live Data Connection , Problem

Product

SAP Analytics Cloud 1.0