Hi. Thank you very much for this useful video. 2 questions that I hope you can help me with. (1) can we load the information for multible databases(companies) and if possible include the corresponding database name as a column in the table with the data (2) Which table/tables do I use to load general ledger(journal entries posted) data? Thanks again.
Hi Demetris, the answer is yes, you can do this. The way it's shown in this example is that the database of interest (IE schema) has been pre-selected through the excel power query framework. In theory, you can do a different query with different data source specifications to have similar queries coming into excel. There is more than one way to do this, and it may be hard to explain it succinctly. We might consider doing an explanation in a future video.
thank you very much you have no idea how this video help in simple words it let me keep on my job seriously thank you.
We're glad it lead to job security!
Really nice explanation,
this is exactly what i need... Thank youu
Glad you found it helpful!
nice work from pakistan
HI, please, where can I find the driver to see the option Hana in Excel?.. many thanks
Hi. Thank you very much for this useful video. 2 questions that I hope you can help me with. (1) can we load the information for multible databases(companies) and if possible include the corresponding database name as a column in the table with the data (2) Which table/tables do I use to load general ledger(journal entries posted) data? Thanks again.
Hi Demetris, the answer is yes, you can do this. The way it's shown in this example is that the database of interest (IE schema) has been pre-selected through the excel power query framework. In theory, you can do a different query with different data source specifications to have similar queries coming into excel. There is more than one way to do this, and it may be hard to explain it succinctly. We might consider doing an explanation in a future video.
Hey, this info is just great. One question, is it possible to build this connection but have both show data and also input data back to the HANNA DB?
This basic connection is a read-only type of thing.
Thank you.
how do we do it if we access sapb1 from a remote desktop? is that why I cant see the hana database in excel?
Hi Sir I cannot see HANADB in Excel get data why it is not showing can you please help me out
Nice One
Thanks for watching
Hi Sir. How do we download MDX? I can't find it
TKS
ODBC😉😉