Skip to Content
Author's profile photo Former Member

Quick Snap: Analysis for Office 2.5 Connection to SAP Analytics Cloud

Analysis for Office 2.5 is GA and available in the service market place.

Inspired by Tammy’s blog, I went about connecting AO2.5 SP01 to SAC.

The connection setup window is straightforward, (perhaps too simple):

 

Had a million tries taking different bookmarked SAC URL…None worked.

Stuck on this screen…I was expecting a login form:

The AO admin guide was not helpful.

Found SAP note 2460065: AO only works with a “Friendly” URL.

The “friendly” logon URL is expected to be *.<landscape id>.sapbusinessobjects.cloud or *.   <landscapeid>.projectorca.cloud.

Note: This restriction limits on-premise data source connections where reverse proxy URLs are used.

Once in,  the “select data source” window is familiar:

Right now this apparently only works with simple and native BOC models, aka models created from file uploads.

Even acquired models from SQL server do not work, nor do models uploaded from large excel files.

Having the Excel client immediately helps SAC in many aspects.

Almost a feeling of “Welcome Home” in my opinion:  SAC’s original name was Cloud for Planning….Under the cover,  SAC originated from a standard BPC engine that works better with formula-ladden excel clients.

Summary: Another inter-operability scenario in the SAP BI land.  At this point, a help SAC squarely needs to accelerate its maturity and adoption.

 

 

 

 

 

 

 

 

Assigned tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Blog Post Author

      One more thing to add:  convert to formula also works for SAC if you are into native excel cell reference all together.

       

      Author's profile photo Jonathan Mortlock
      Jonathan Mortlock

      Until you can connect to Live Data models coming from SAP Cloud Platform this feature is pretty much useless to us right now.