![]() If I again have to automate the end to end process with VBA in this case where on click of a button my VBA code connects with ABAP CDS and download the data in excel as pivot so that I can process it further. This also involves some manual UI steps like logon, connect etc. Part 2 - If CDS is part of ABAP, as per my understanding we use SAP business objects Analysis for connecting to view from excel and downloading the report. Also will we have to write a MDX within VBA code to mention measure and dimension.Īny sample code or guide for the same will be quite helpful.Ībove case is when calculation view are in SAP HANA DB. ![]() Can we do the same with excel VBA so that i can automate the end to end process within excel from connecting to selecting calculation view to providing measure and dimension to download report as pivot in excel. Prerequisites Console Add a connection Windows connection string: server:port Linux For example, if the SAP HANA server is running on the host MyServer, as instanc. Part 1 - If I just need to extract data from information views of SAP hana in excel, I know we can do it manually with UI where we establish connection, select DB and view, then select measure and dimension and data is downloaded in excel as Pivot.
0 Comments
Leave a Reply. |