Create DataSource in Sap Business One Excel Report and Interactive Designer

[rahuljain257]

Hello Everyone,

I am having trouble creating a query that can be used in Excel Report and Interactive Analysis. I followed the steps in this guide How to work Excel Report and Interactive Designer, but the query is not showing up. I want the data source to be visible in the Select Data Source tab. Can anyone help me with this issue?

As per the documentation, How to work Excel Report and Interactive Designer, I followed the below steps -

Snaps from the documentation.

SAP B1 HANA Model Management

[rahuljain257 · Accepted solution]

The issue has been resolved, Please find the link - https://answers.sap.com/questions/364252/customized-views-in-excel-report-and-interactive-a.html

Snap from the Post - I've solved this by changing view name. It should end with Query to be shown in excel report. Before renaming, please configure Hana Studio to accept lower case character.