Odbo OLE DB for olap.
5.2 Using Excel for Reporting on SAP hana.
Odbc Open DataBase Connectivity, microsoft-driven specification for relational reporting, database requests are made via SQL (Structured Query Language).
SAP BusinessObjects Analysis, sAP BusinessObjects Explorer, sAP Lumira.Asking a non-technical user to use hana Studio is not really practical.Common driver technology used by SAP BusinessObjects Analysis, Office Edition for connectivity to SAP NetWeaver.Finally it will be non-technical end users (for example manager, sales executive, board members etc.) who will consume presse papier multiple mac os x the modeling views to visualize different business scenarios.SAP Business Objects Crystal Reports, sAP BusinessObjects Dashboards, reporting on SAP hana Clients and Connectivity Options: SAP hana supports different connectivity options such as sam and cat episode 16 MDX, SQL, bics etc.Thats why we need separate reporting tools which can connect to SAP hana, take the data from modeling views and show in a nice, easy to understand format.
In the next session we will see how to use Excel for reporting on SAP hana.
Heavily adopted in industry, no longer Microsoft-centric Unix and Linux drivers exist.
Click here to go to Next Chapter. .Below image shows the different connectivity options supported for frontend tools and SAP hana.Requests are sent to the database via MDX (MultiDimensional eXpression language).It provides jdbc and odbc drivers which are standardized programming interfaces to access relational databases.Popular on Unix platforms.Reporting on SAP hana can be done in most of SAPs Business Objects BI avg 2012 update file Suite of applications, or in tools which can create and consume MDX queries and data.