Skip to Content
Author's profile photo Bharath Ramamurthy
Bharath Ramamurthy
July 24, 2012 1 minute read

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.

IMG1.png

4. Connect to the specific BW system.

IMG2.png

5. Select a Workspace where the Transient Provider needs to be created.

IMG3.png

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).

IMG4.png

8. We can modify the Technical Name, select the measures and change the datatype as we see fit.

IMG5.png

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.

IMG6.png

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.

IMG7.png

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Patrik Maag
      Patrik Maag

      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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Patrik Maag
      Patrik Maag

      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

      Author's profile photo Former Member
      Former Member

      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