on 02-21-2013 3:56 PM
Hey,
is there any chance to integrate analysis workbooks into Enterprise Portal?
Thanks
Christian
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
New iViews are being delivered specifically for Analysis:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.