Error while we executes the Workiva chain
BeantwoordHello All
We have connected SAP BW 7.5 which is in HANA database to Workiva. All the confifuration is done. Now when we run/execute the chain using the BW connector calling/reading the data from BW query we are getting the error. Below
--------TYPE:E ID:BRAIN NUMBER:605
MESSAGE:The requested query / does not exist on the current server
Return Code: 3
Exit message: Error executing function: RSR_MDX_GET_FLAT_DATA ---------
We do not see any authorization issues and also we have checked Trace and could see the RSR_MDX_GET_FLAT_DATA is successfull.
So wondering if any of you have got chance in calling an BW query in Workiva and had any problem like this.
Thanks
-
Do we needs to enter the BW Query name which looks like this in ZXYZ_Q0001 or Should we write the MDX query with the select statements
In the Execute MDX query template,
Thanks
0Hi Takkellapatikiran Kumar (Capgemini Norge AS,Oslo), you will want to write in the MDX query as the Execute MDX Query Command requires an MDX query to execute. You can create the query by running a report with the desired data in SAP BW and then capture its MDX syntax. If you continue to receive errors from SAP BW, it is recommended to consult with your SAP BW administrator to ensure both the SAP BW Connector and Execute MDX Query Command are configured properly.
0Hello Jeff
Thanks for checking it and replying over the issue.
Actually all the querys we are able to execute it them in SAP reporting. But when we execute them in for MDX script which all querys with in system is not able to generate any script for MDX.
We are also checking with SAP as well for this issue, if there is any limitations or any thing we are missing out..
Thanks
0Hi Takkellapatikiran Kumar (Capgemini Norge AS,Oslo), if the report works in SAP BW and you're using the MDX syntax from the working report in the Execute MDX Query Command and receiving an error "does not exist error", this points to a misconfigured Connector and/or remote access/permission issue. With help of the SAP administrator, review that the SAP BW Connector Prerequisites are met, and that the set up has been done correctly. There are several troubleshooting steps to review as well.
0U moet u aanmelden om een opmerking te plaatsen.
Opmerkingen
4 opmerkingen