1

I am trying to build reports using RESTful API for Business Objects 4.2. In the "SAP BusinessObjects RESTful Web Service SDK User Guide for Web Intelligence and the BI Semantic Layer", section "6.5.1 Parameter Response Body Schemas" mentioned that parameter may be a context, prompt or sapVariable. I was able to create a report with context selection and prompt. But what is sapVariable?

<parameters>
    <parameter type="context|prompt|sapVariable" optional="Boolean" dpId="string">

How is it possible to create a variable that will require an input from the user?

Thanks in advance.

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
kungfux
  • 35
  • 1
  • 5

2 Answers2

0

I'm not sure what a SAP variable is (It's hardly described in the IDT guide, mostly to do with HANA variables in the context of semantic layer). Seeing that there is no mention of Sap variable in the context of parameters, business layers etc., it's quite conceivable that it's a Universe feature that didn't make the cut in 4.2, but may become available later. In which case, I suppose it could give the ability to leverage HANA variables in the business layer directly.

I'm not sure if I understand your question regarding creating a variable that requires a user input, since you mentioned that you have already created a report that supports context and prompts. There is a UserResponse function in Webi you can use to get the prompt values. Alternatively, you can also create a universe object with @Prompt that you can incorporate in the result of your query, and manipulate that directly into your report.

Eric
  • 154
  • 6
  • Thank you, @Eric. Regarding my question on how to create a variable that requires a user input, I meant that SAP variable prompt type. Sure, I tried to build various reports using prompts, contexts and UserResponse function. In addition, we already have prompts in our universe but they appear as usual prompts in the REST. I forwarded the question to SAP support. Will share the info once received. – kungfux Jun 08 '17 at 23:15
  • 1
    SAP Variable prompt kind are prompts coming from BEX queries. – Arnaud Develay Jun 09 '17 at 09:41
  • Thank you, @ArnaudDevelay. I will check but seems we do not use BEX applications. I appreciate your comment. – kungfux Jun 09 '17 at 11:33
  • I would prefer to see you comment as an answer to be able to mark it as accepted, @ArnaudDevelay. Because I've received an answer from SAP support and they replied with following: `In this context, a SAP variable is a parameter that is a part of the original query. For example, if your webi report is based off of a BW query, the SAP Variable would be a parameter that was created on the BW side and was passed along as part of the query. Sort of like a stored procedure parameter. A SAP variable cannot be created programatically as it originates from the database side.` – kungfux Sep 26 '17 at 18:34
  • I have added a new answer as requested. – Arnaud Develay Sep 27 '17 at 07:06
0

SAP Variable prompt kind are prompts coming from BEX/BW queries. This prompt is a parameter inherited from the BW Query and automatically passed to the end-user during the refresh process.

Arnaud Develay
  • 3,920
  • 2
  • 15
  • 27