SBOP SDK

BI4 RESTful SDK / Excel : WebIntelligence Documents : Change dataproviders

Synopsis: In this series of Blogs, I’ll explore how we can use RESTful Raylight Web Services in Excel with VBA. Previous Entry: List documents using an universe Howto change universe in dataproviders on a lot of webo documents ? With RESTful SDK and Excel ! We got the list of documents in the previous chapter, we can select the ones we want to change. For more information you can see …

Read More »

BI4 RESTful SDK / Excel : List documents using an universe

Synopsis: In this series of Blogs, I’ll explore how we can use RESTful Raylight Web Services in Excel with VBA. Previous Entry: Get content of an universe Sample I didn’t found a simple url to get the documents using a specific universe. We have to browse all documents, and see if they have dataproviders based on this universe. Workflow The workflow is : get universe’s id from excel worksheet logon, …

Read More »

BI4 RESTful SDK / Excel : Content of an Universe Sample

Synopsis: In this series of Blogs, I’ll explore how we can use RESTful Raylight Web Services in Excel with VBA. Previous Entry: List universes sample We’ll use the previously list of the universes ; we’ll enter an Universe’s id and get the content with a new macro. It’s not user-friendly, but remember, it’s just a sample ! Sample result with efashion universe : 1) Workflow The workflow is : get …

Read More »

BI4 RESTful SDK / Excel : List Universes Sample

Synopsis: In this series of Blogs, I’ll explore how we can use RESTful Raylight Web Services in Excel with VBA. Previous Entry: logon/logoff sample Ok, we can logon/logoff, now let’s try to get the list of the universes … Workflow The workflow is : logon, get the token create an object for HTTP request define the URL, set parameters of the HTTP request put the token in header of the …

Read More »

BI4 RESTful SDK / Excel : Logon/Logoff Sample

Synopsis: In this series of Blogs, I’ll explore how we can use RESTful Raylight Web Services in Excel with VBA. Previous Entry: http://scn.sap.com/community/restful-sdk/blog/2016/10/03/bi4-restful-sdk-excel-is-back It’s the first REST sample to do, like the “Hello World” in java & co. I’ll not explain the workflow and how SDK works, you like see the official documentation or Ted Ueda’s blog for this. We write a VBA macro refresh() in an Excel document (see …

Read More »

BI4 RESTful SDK : Excel is back !

Well, I’ll write some posts for people like me, VBA’s nostalgics. Remember, there was a great time for older versions of Business Objects, when you can get or create wonderful tools with Excel and VBA. These tools were open, and we could improve it easily, with a minimum of VBA’s knowledge. But VBA didn’t evolve with BI4. And I haven’t found specific Excel tools for BI4, to describe an unx …

Read More »

Using Azot tool to play with RESTful API

Introduction In this post, we will see how you can test quickly RESTful API by using Azot. Azot is a small open source tool which help to execute easily a set of HTTP calls in a workflow without coding. Azot can be downloaded from here: download link It required to have at least JRE 6 installed in your computer to work.To process an Azot workflow, defined into an XML file, …

Read More »

How to get data source details from webi document properties

I am writing this blog to give detail on how the data source information can be retrieved for a webi report through the SI_WEBI_DOC_PROPERTIES using BusinessObjects Enterprise Platform Java SDKs.   Using the query builder(AdminTools Application), and executing the below query Select si_name,si_id,si_webi_doc_properties from ci_infoobjects where si_kind=’webi’ and si_instance=0, we get the list of top 1000(default) webi reports for the environment we are connecting to. (Note: For getting list greater …

Read More »

JAVA Enterprise BE 12 List Objects in Inbox

This document provides a way to get the list of objects in users inbox using Business Intelligence platform Java SDK. For more scripts and information on how to run these scripts refer to the blog avaiable here: http://scn.sap.com/people/shawn.penner/blog/2013/06/04/scripts-and-samples Below is the Java Server Pages (JSP) sample Notes: I am attaching the three files in .txt format as SCN doesn’t allow to upload zip files. Download the three files and save …

Read More »

Attaching documents to Purchase Request

Hi people! Just these days I involved in web application manteniance as web consultant and hit some “rocky-code” to send multiple attached documents, searching in CN I find sections of code but no fit with my code style, no counts error on run… With patience and research found a suitable solution and then presented: // objSAP is Company interface connected objSAP.StartTransaction(); Documents req = (Documents)objSAP.GetBusinessObject(BoObjectTypes.oPurchaseRequest); req.DocType = BoDocumentTypes.dDocument_Items; req... // …

Read More »

Do you want to Get SAP Courses?

Get SAP Courses and Training, Videos, Other Useful Resources
Join Now
Written by SAP Expert TEAM.
close-link
New Registration