Dear Samrat Devkota,
There are multible possibilities.
In Excel and also PowerBI you can connect to the database where the SAP B1 Instance is running and query all the tables and Views.
For example: In Excel you can go to the data tab and click Get-Data from SQL Database. Same on PowerBI.
Kind Regards.
Dear Samrat,
you should have at least two options:
1) For HANA you can try Interactive Analyses.
https://help.sap.com/docs/SAP_BUSINESS_ONE/68a2e87fb29941b5bf959a184d9c6727/b21f38ad5c82426296d2c9f9...
2) Or you use direct queries to the hana database. For that you would need a HANA DB User with "select" permission to execute the query.
In Excel you can also select HANA as a database.
Best Regards
| User | Count |
|---|---|
| 98 | |
| 8 | |
| 6 | |
| 6 | |
| 5 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.