Analysis Workbook in Enterprise Portal

[Former Member]

Hey,

is there any chance to integrate analysis workbooks into Enterprise Portal?

Thanks

Christian

[Former Member]

Hi  Christian,

In portal having a special iview called Analysis for Microsoft excel/power point. This will be used for exposing the Workbook details in portal.

Please find the more steps to the below note.

1799515 - Launcher iView for Analysis Office

Thanks

patrick

[Former Member]

Hi Patrick,

the only drawback (as far as I understood) is, that you have to create a dedicated iView per AO workbook. I'm still looking for a possibility to select one AO workbook from the portal and the report parameter is passed dynamically to the iview....

Regards,

Andreas

[Former Member]

Hi Andreas,

Then You can create a transaction iview with SAP GUI windows format of RAAOE transaction.

From the screen you can select the workbook dynamically and expose to excel.

Thanks

Parick

[Former Member]

Dear Patrick,

this is one possibility, but having the in-between-step to select the report in RAAOE from a flat list is in my opinion not really user convenient...

Best would be if the report structure of the role menu would be shown in the portal and selecting one report from this role structure will launch RAAOE and passes the workbook ID as a parameter to the transaction.

Regards,

Andreas

[Former Member]

Hi Andreas,

I know this is quite an old Topic, but did you find a solution for this?

best regards

Dominik

[Former Member]

Hi Dominik,

we developed our own solution: We use a function module to read the folder structure of the underlying reporting/role menu in BW and then we apply some java scripting code to bring this to the browser in a nice tree structure. From here you can select the AO report, Excel will start and the report will be loaded. So it is no standard solution, but it finally works.

Kind regards,

Andreas

[Former Member]

Hi Andreas,

Please let me know about your solution as we are in the same requirement

[Former Member]

New iViews are being delivered specifically for Analysis:

http://service.sap.com/sap/support/notes/1799515

[UlfZeisberger]

Victor, you made my day!

I have just tested the RAAOE it; and it works on our BW 7.3 system.

Transaction RAAOE can be called on the BW system, opens Analysis for Excel.

In AAO, when you select the calling BW system as datasource, you do not have to log on anymore.

I will now try to create a transaction iview in the portal, like we had in the past for transaction RRMX / RRMXP.

I have not played with the parameters of tx RAAOE.

Regs

Ulf

[Former Member]

Hi Ulf,

By any chance hve you tried to call AAO from portal through transaction iview?

Regards,

Eashwar.

[UlfZeisberger]

Hello Eashwar,

I found something even better.

There is a SICF service in  BW ABAP stack called /sap/bw/analysis   which sends back a

analysis.sapaox  file to the browser. If the Analysis for Office is installed, it will execute the file.

I have found single sign on from portal to Analysis for Office to BW data source to be working this way.

I have not dug into details, but think that the transaction just does something similar. SSO also works this way.

However, you would need to get over the first selection screen with the help of OK code field or Application Parameters. I did not further try this approach.

Regs

Ulf

[Former Member]

Hi ,

In portal having a special iview called Analysis for Microsoft excel/power point. This will be used for exposing the Workbook details in portal.

Please find the more steps to the below note.

1799515 - Launcher iView for Analysis Office

Thanks

patrick

[Former Member]

You don't need BO for using Analysis (for Office). With release 1.3 of Analysis you should be able to save Analysis Workbooks on your Netweaver System. I'm now searching for an option to made these workbooks available to NW Enterpise Portal Users. (Click a link and Analysis will open - as it is possible with BEx Analyzer).

[Former Member]

Hi Christian,

No you do not need BO Platform for Analysis for Office. It depends on what your portal strategy is. Some companies use InfoView or BI Launch Pad as there reporting portals and integrate it into their enterprise portal.

With BussinessObjects platform you also have Analysis for OLAP which is the web version of Analysis for Office.

Again depends on your requirements.

[Former Member]

How about creating an iView to the RAAOE transaction? Maybe you can even parametrize that.

[sylvainchevalle]

Hi Christian,

have a look at the Official Product Tutorials... specific contents to AAO 1.3 working with SAP BW NetWeaver had been published.

Good Luck and Kind regards,

Sylvain

http://scn.sap.com/docs/DOC-7679

[Former Member]

Dear Christian,

have you finally found a solution for your problem.. We are facing the same issue, as we want to publish our AAO workbooks to the portal without creating dedicated iViews for each of the workbooks. As we want to store AAO workbooks in the BW repository, any access via the LaunchPad on the BI platform is not at all a solution for us...

Thanks and best regards,

Andreas

[Former Member]

Hi Cristian,

I have seen once Analysis on Web, my observation is we can do analysis same as in Excel on web, but with limitation that you can't use Excel functionalists (like Pivot which was required for my requirement).

But there are other alternative are provided for calculations like you can write your own formula's in workbook.

Regards,

Ganesh

[Former Member]

Hi Christian,

Just to add a bit more. I understand BO 4.1 will support Analysis objects and you will have the ability to schedule/broadcast Analysis 1.4 objects through the BusinessObjects Platform

[Former Member]

Hi,

I am assuming here that you save your worbooks in BI LaunchPad:

Did you already take a look at the integration options of BI4 with enterprise Portal?

http://wiki.sdn.sap.com/wiki/display/BOBJ/BI4+Integration+into+the+SAP+Entreprise+Portal+7.0.x

Else I believe you can create a URL iView to point to the Analysis WB (using OpenDocument).

Best regards,

Victor