SAP BusinessObjects Analysis Office 1.3 – Create transient provider from Excel data
SAP BusinessObjects Analysis Office 1.3 – Upload data into Workspace as Transient provider
1. Launch AO 1.3 and Open the excel file containing the data to be uploaded.
2. Select the data range.
3. Click on Upload button in the DataSource ribbon.
4. Connect to the specific BW system.
5. Select a Workspace where the Transient Provider needs to be created.
6. AO automatically recognizes the column headers as Dimensions/Measures and also detects the corresponding datatypes.
7. Technical name has a default namespace @3 followed by set prefix (defined in Workspace).
8. We can modify the Technical Name, select the measures and change the datatype as we see fit.
9. We can also choose if we just need to create the transient provider or to insert it in current sheet or in a new worksheet.
10. Now a transient provider is created in BW system using a simple Excel data. We can perform all Analysis actions on this datasource, just like how we do it on any BW Query.
Nice blog!
I just have a question: I can not see in my analysis version buttons "upload" "reload". Did you do anything special to have them in you analysis toolbar?
Thanks,
Gabriel
Hi Gabriel,
Are you using AO 1.3? If so, it probably has been disabled by your administrator via the registry key "EnableWorkspaces" in
HKEY_CURRENT_USER\Software\SAP\AdvancedAnalysis\Settings\Workspaces\
You can take a look at the Administrator's Guide for more information about how to enable / disable the Workspaces and the required backend version.
Best regards,
Patrik
Thanks Patrik,
Do you know if settings are different with a 64 bits installation? Cannot find a AdvancedAnalysis folder under SAP in the registration key. I created it manually but buttons didn't appear.
I am using A0 1.3 Patch 6.
THanks,
Gabriel
Hi Gabriel,
as this could result in a extensive thread, could you please start a new discussion for this issue?
Thank you & best regards,
Patrik
Hi,
I believe I found the issue: Analysis Office in 64 bits seems not to have these options yet. To use this scenario, you need Analysis Office 32 bits.
Gabriel