Skip to Content

Analytical app, Design Studio - Could not instantiate data source "DS_1" for query

Hi

I'm trying to open the Fiori reporting app "Cost Centers - Plan/Actual", but get below error.

I have configured S/4HANA Analytics as per SAP note 2289865.

System has an embedded gateway (no frontend system) and I get the same issue through the web dispatcher and on the backend system. SAP note 2664717 don't seem to apply, as the Gateway is Embedded.

Following errors in Chrome:

Console:

Network:

Kindly advise. Errors in Gateway log, not sure if it is related. Odata service C_ACTUALCASHFLOWANALYTICS_CDS is activated.

1.png (68.6 kB)
2.png (74.6 kB)
4.png (54.7 kB)
3.png (49.7 kB)
5.jpg (27.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 03 at 02:37 PM

    Hi Willem,

    You should check if your BI content for simple finance is active. (not activated by default)

    We had the same issue at a customer, after activating the BI content the apps work fine.

    In customizing:

    Switch business Category to 03 (Business Functions) and check the status for /ERP/SFIN_PLANNING (don't mind the red flag in the screenshot, we were not able to activate this in one time and had to start the process several times to get it fully activated):

    Be aware this needs to be done in the development system and takes a long time.

    Best regards,

    Geert-Jan Klaps


    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03 at 10:35 AM

    Hello Willem, have you reviewed SAP Note https://launchpad.support.sap.com/#/notes/2356997 (config steps)?

    Also I would look at SAP Note https://launchpad.support.sap.com/#/notes/0002563303 and try the RSOR steps on your query just to check

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03 at 01:44 PM

    Hi Tammy

    Thank you, I use alias LOCAL and don't see a fix in SAP note 2356997. I tested the INA URL which open successfully.

    https://<hostname>:44300/sap/bw/ina/GetServerInfo;o=S4FIN?sap-client=100

    As per SAP note 2563303, I'm not sure how to find query Bex Query /ERP/SFIN_M01_Q2001 in RSOR

    2-1.png


    2-1.png (208.2 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03 at 01:54 PM

    Please also see when trying to check the query in RSRT.


    3-1.png (36.0 kB)
    Add comment
    10|10000 characters needed characters exceeded