随着Flash的结束，传统文件类型将在2020年12月消失。为避免中断，请开始将文件过渡到下一代。 学到更多

Error while we executes the Workiva chain

已回答
要求演示

Hello 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

 

0

评论

4 条评论

日期 投票数
  • Takkellapatikiran Kumar (Capgemini Norge AS,Oslo)

    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

    0
  • Jeff Hickey

    Hi 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.

    0
  • Takkellapatikiran Kumar (Capgemini Norge AS,Oslo)

    Hello 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

     

    0
  • Jeff Hickey

    Hi 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.

    0

请先登录再写评论。