Connectivity Design Studio & Analysis for Microsoft Office

[Former Member]

Hello,

I am new to SAP-World and working on my Bachelor-Thesis in a company.

I have build a Dashboard in Design Studio where a user can fill up parameters in a set form. Outgoing from these parameters I want to automatically create, for best practice, a report in Excel. There is a predefined query(datasource) which gets all table columns and data from the database. When inserting the query Excel automatically asks for a few start-parameters like date and so on, the start parameters in Design Studio are more complex.
So my goal is to automatically generate a Excel Report which the User can Store anywhere he likes by pressing a button with the start-parameters set by the user in Design Studio.

At the moment I am stuck in the connectivity between Design Studio and Excel(AfO) and clueless how to proceed. I would highly appreciate your help. Thanks in Advance!

[former_member276213]

Hi Muhammed,

I have recently created similar scenario, which might be helpful for you.

1.Open excel, click on file tab-----settings---plat form----select preffered platform as BI plat form--save excel

2.Restart the excel, click on analysis for office tab.

3.select the data source, it will ask user id and password provide it (also it will ask for BO server URL"http://<BOIP adress :8080/dswsbobje/services/Session" along with BO user id and password)

4.Now open bex report and put characteristics and key figures in your rows and colums, then save the excel report in BO server as analysis for office document (A open URL document will generate)

5.In now in your design studio report, lets say if you click a button then if your expectaion is to generate analysis for office excel report, please go to Button script editor

Write below script:

Application.opennewwindow("Analysis for office open URL") should open analysis for office excel in new tab.

Feel free to let me know if you need any further help.

BR,

Lakshmikanth Adharaprapu

[Former Member]

First, thanks for your wishes.

I was told that in Design Studio it is possible to generate a parameter enriched link which opens a "Report" file such as Crystal Reports or AfO while passing the parameters to filter the data-output.

I started with Design Studio because there is a requirement of an User-Self-Service Interface and Design Studio works best to display such a Dashboard.

The idea of using AfO is, that other departments which do their analysis on that data, have a good data-format basis for further processing.

Unfortunately Lumira is announced but there isn't a release date within our company yet.

[TammyPowlas]

OK, understood, I think you are referencing the OpenDoc link. But I don't think going from Design Studio to Analysis Office is the best for this; I would use Analysis Office and buttons/VB scripting to accomplish this.

[TammyPowlas]

Hi - good luck on your thesis.

Right now Design Studio does not export to Analysis Office; that feature is planned for SAP Lumira Designer 2.0

I'm curious, why start with Design Studio? Why not just code this in Analysis Office?

Tammy