Skip to Content

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

5 Comments
You must be Logged on to comment or reply to a post.
  • 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