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:
- {Messages: [{Type: 2, MessageClass: "", Number: 0, Text: "Service cannot be used",…},…]}
- Messages: [{Type: 2, MessageClass: "", Number: 0, Text: "Service cannot be used",…},…]
- 0: {Type: 2, MessageClass: "", Number: 0, Text: "Service cannot be used",…}
- ExceptionClass: "CX_BICS_SERVICE_NOT_APPLICABLE"
- MessageClass: ""
- Number: 0
- OlapMessageClass: 0
- Text: "Service cannot be used"
- Type: 2
- 1: {Type: 2, MessageClass: "", Number: 0, Text: "Service cannot be used",…}
- ExceptionClass: "CX_BICS_SERVICE_NOT_APPLICABLE"
- MessageClass: ""
- Number: 0
- OlapMessageClass: 0
- Text: "Service cannot be used"
- Type: 2
- 2: {Type: 2, MessageClass: "BRAIN", Number: 635, Text: "Query <Query Name> could not be opened.",…}
- ExceptionClass: "CX_RSR_QUERY_OPEN_ERROR"
- MessageClass: "BRAIN"
- Number: 635
- OlapMessageClass: 0
- Text: "Query <Query Name> could not be opened."
- Type: 2
- 3: {Type: 1, MessageClass: "BRAIN_DEV", Number: 36,…}
- ExceptionClass: ""
- MessageClass: "BRAIN_DEV"
- Number: 36
- OlapMessageClass: 0
- Text: "Query has been changed and generated after current session was started"
- Type: 1
- 0: {Type: 2, MessageClass: "", Number: 0, Text: "Service cannot be used",…}
- Messages: [{Type: 2, MessageClass: "", Number: 0, Text: "Service cannot be used",…},…]
Read more...
Environment
SAP Analytics Cloud
SAP Business Warehouse
SAP BW/4HANA
Product
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.