SAP Knowledge Base Article - Preview

3319559 - Unable to retrieve data error in SAC BW Live Data Story after adding a new dimension to a BW Query or CDS view

Symptom

You have a CDS view or BW Query and after adding a new dimension and transporting to the system used in SAC some widgets may present the following message:  "Unable to retrieve data from datasource.". 

In the browser network you may see the following:

  1. {Messages: [{Type: 2, MessageClass: "", Number: 0, Text: "Service cannot be used",…},…]}
    1. Messages: [{Type: 2, MessageClass: "", Number: 0, Text: "Service cannot be used",…},…]
      1. 0: {Type: 2, MessageClass: "", Number: 0, Text: "Service cannot be used",…}
        1. ExceptionClass: "CX_BICS_SERVICE_NOT_APPLICABLE"
        2. MessageClass: ""
        3. Number: 0
        4. OlapMessageClass: 0
        5. Text: "Service cannot be used"
        6. Type: 2
      2. 1: {Type: 2, MessageClass: "", Number: 0, Text: "Service cannot be used",…}
        1. ExceptionClass: "CX_BICS_SERVICE_NOT_APPLICABLE"
        2. MessageClass: ""
        3. Number: 0
        4. OlapMessageClass: 0
        5. Text: "Service cannot be used"
        6. Type: 2
      3. 2: {Type: 2, MessageClass: "BRAIN", Number: 635, Text: "Query <Query Name> could not be opened.",…}
        1. ExceptionClass: "CX_RSR_QUERY_OPEN_ERROR"
        2. MessageClass: "BRAIN"
        3. Number: 635
        4. OlapMessageClass: 0
        5. Text: "Query <Query Name> could not be opened."
        6. Type: 2
      4. 3: {Type: 1, MessageClass: "BRAIN_DEV", Number: 36,…}
        1. ExceptionClass: ""
        2. MessageClass: "BRAIN_DEV"
        3. Number: 36
        4. OlapMessageClass: 0
        5. Text: "Query has been changed and generated after current session was started"
        6. Type: 1


Read more...

Environment

SAP Analytics Cloud
SAP Business Warehouse
SAP BW/4HANA

Product

SAP Analytics Cloud all versions ; SAP BW/4HANA all versions ; SAP Business Warehouse all versions

Keywords

SAP Analytics Cloud, Dimension, No data, Unable to retrieve data, new dimension, modification, BW, BW Live Connection, Query, CDS, CX_BICS_SERVICE_NOT_APPLICABLE, CX_RSR_QUERY_OPEN_ERROR , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.