Connecting AAO to HANA

[Former Member]

Hi Folks,

Quick question - probably an easy one. I'm wanting to play around with AAO (usually I work in HANA) and am not clear on how to connect to HANA.

In one version of AAO in on system, after clicking "Insert Data Source", shows three folders: Connections, Favorites and HANA. This version of AAO just seems to be called "Analysis for Office". I can connect to a HANA system fine with this version.

However, in another system, I have a laptop with "Advanced Analysis for Office" pre-installed. When I similarly try to insert a new data source, all I see are SAP connections - no options to connect to HANA.

Any ideas? Also, what's the difference between "Analysis" and "Advanced Analysis" for Office?

Thanks,

Jody

[TammyPowlas · Accepted solution]

The first version of Analysis Office was called "Advanced Office"

The advanced name was dropped

Also see

[Former Member · Accepted solution]

Thanks, Tammy!

[rama_shankar3]

Jody,

Also refer to the below how-to videos: hope this helps.

Insert a data source using an OLAP connection to SAP HANA: Analysis OLAP 4.x - YouTube

Insert a Data Source Using a Local Connection to SAP HANA: Analysis 1.1 - YouTube

Regards,

Rama Shankar

[Former Member]

Thanks Rama. Turns out I was just using an old version of AAO.

[Former Member]

Looks like this version is a bit old, 1.0.8 as opposed to the other system which has version 1.4.  So I'm assuming HANA access came at some point after 1.0.8