Analysis for Office connection with SAC (Sap Analytics Cloud)

[arpangupta]

Hi Experts,

I am on AO 2.8 SP 3. In this release it is possible to connect to a SAC model and see the result in analysis for office.

I am able to connect it as shown below.

Now,We want to now roll it out to all users, So that they need not to configure it in the connection list manually. How should I proceed? which config file should contain this entry?

Regards,

Arpan

[former_member186338]

Look on the following files:

[arpangupta]

Hi Vadim,

Thanks a lot for your reply!

I explored this file already. The SacCredentialStore.xml is generated once we create the "SAC Connection" manually in AO in the local connection. But as an administrator, I want to roll this out for 1000+ users. What I am looking for is, Users need not to create new SAC connection manually.

I also tested it like this: I create the SAC connection manually > The SacCredentialStore.xml is generated > I deleted the connection > Restarted the AO, just to check if SAC connection is again created because the xml file is still there > but no, the connection was not there.

Any idea, how to roll it out for users?

[former_member186338]

Please read about configuration files and locations here:

https://help.sap.com/viewer/ca9c58444d64420d99d6c136a3207632/2.8.3.0/en-US/b8cc13367d6e48fab890629ef...

[arpangupta]

Hi Vadim,

I checked the document but I did not found the required information. As an admin, where should I define the SAC connection details and in which setup file, so that every user need not to configure it manually.

Regards,

Arpan

[yogananda]

Hi Arpan,

There is help documentation and you can get more information to it.

https://help.sap.com/viewer/product/SAP_ANALYSIS_OFFICE_CLOUD/2.8.4.0/en-US

[yogananda]

Hi @Arpan Gupta

Open SAP Analysis for Microsoft Office (we used version 2.5) and click on “Select a data source”

You will be prompted with the “Select Data Source” dialog box. Right-click on the window and select “Create New SAC Connection”

• A new window pops-up where you need to enter the connection details – URL and the description. There is one important thing we need to keep in mind while entering the URL – SAP Analysis for Office accepts only a “friendly” URL which should be in the following format https://<LANDSCAPEID>.sapbusinessobjects.cloud or https://<LANDSCAPEID>.projectorca.cloud .

Please make sure you follow this exact format so that you don’t run into connection issues.

[arpangupta]

Hi Yogananda,

I have already done this and I am able to set up the connection. But my question was, if we have to do it for 1000 users, where and in which config file, I can maintain this connection-string entry, So that users need not to do it manually.

Thanks,

Arpan

[yogananda]

Hi arpangupta

yes its possible and below link will help to solve your problem

https://blogs.sap.com/2020/01/23/analysis-for-office-2.8-on-sap-analytics-cloud-observed-differences...

[arpangupta]

Hi Yogananda

I checked the link but I am not able to find anything related to configuration of SAC for all users. Could you guide me?

Regards,

Arpan