Skip to Content

Hana Studio modelling

Nov 07, 2016 at 04:55 AM


avatar image


I am looking for data modelling in hana studio. As I am confuse as fellow.

1. If i had hana studio connected to r/3 system i.e if i had hana database by using hana studio can i develop data modelling directly sap standard table for e.g can i develop attributed view or calculation view by using mara , makt etc table or i have to sift the data other server than i have to create modelling on that and BO can be use for reporting.

2. Can data modelling can be done directly on sap standard table or we have go for bw and than modelling and than go BO for reporting

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

JACK LIOR Apr 20, 2017 at 03:46 AM

1 If the version of ERP is S/4 HANA, then you can model by using HANA Studio through connecting hana studio to ERP HANA DB.

You can use all the tables .

2 Of course you need all the tables ,no matter tables are standard or further developed. they are both ok when you report tables by BO or by other ways.

10 |10000 characters needed characters left characters exceeded
ANUP KULKARNI Dec 13, 2017 at 06:51 PM

If you are having Suite on HANA, consider reusing HANA live content (which can be downloaded and installed as a package).

If you are having S/4HANA, there are plenty of Released CDS views on most of standard tables. Consider reusing them or extending them.

As far as consumption of HANA view or CDS views is concerned, you have three options:

1. Report directly in BO using HANA online - user security has to be implemented in database

2. Expose CDS view or HANA view as transient provider in Bex - you can apply BW analysis authorizations

3. HANA views can also be used in composite provider which can be reported via Bex - again, BW analysis authorizations can be used.

Hope that helps

10 |10000 characters needed characters left characters exceeded