Hi All,

I am sure there are multiple blogs talking about how to consume application data stored in SAP tables using SAP Analytical applications. In this blog I will walk you through the steps on how we can consume classical Infosets directly within SAP BusinessObjects Design Studio in a BW on HANA scenario using BW Transient InfoProviders.

Let me start by defining a Transient Infoprovider, which I am sure intermediate and advanced BW users are already aware.

What is a Transient Provider: InfoProvider that allows analysis and reporting with BI tools on top of Business Suite applications. No data resides in BW and no modeling is required to access these artifacts.

Please also refer to the article What are Transient Providers?   See if you have BW inside your ERP System by Tammy Powlas to gain more insights

Note:

  • Transient Providers require ERP6.0 EhP 05.
  • Infosets and BW install should be in the same system
  • Only client-independent Infosets are available


Scenario:


We will create an Infoset on Flight connections (SFLIGHTS) and Flight schedule (SPFLI).

Map (join) the relevant fields, generate and release the Infoset.


There are 3 parts to this process:


Part-1: Create a classical infoset joining 2 tables and generate the Transient Infoprovider

Part-2: Create a Bex query to consume it in Design Studio

Part-3: Create Design Studio application to consume the Bex query


Part-1 Steps to create a SAP App-Server based Classical Infosets

  1. Log into the SAP instance where BW is also installed.
  2. Go to transaction code SQ02.
  3. Give an Infoset name and press Create

fig_1_1.PNG

4. Give a description and define the table name as SFLIGHTS and press the Green Check Mark to proceed.

fig_1_2.PNG


5. Next, we add another table and map the fields.



fig_1_3.PNG


6. In the pop-up dialog, enter SPFLI as the 2nd table name and press the Green Check Mark :

fig_1_4.PNG

7. Fields are automatically mapped :



fig_1_5.PNG


8. Click on the Infoset Arrow icon and in the pop-up, select “Include All table Fields” radio button option and press the Green Check Mark:

fig_1_6.PNG


9. In the next screen, choose “Generate” to generate the Infoset:


fig_1_7.PNG



10. Upon generation, a message in the status indicates that the infoset was successfully generated:

fig_1_8.PNG

11. Press the Back button to open the Infoset main screen.arrow.PNG

12. Final step in the process is to release the Infoset. From the menu, click on Environment–>BI Properties:

fig_1_9.PNG

Press the Green Check Mark to proceed.

fig_1_10.PNG

13. In this screen, choose the Infoset you have created by checking the BI Allowed property and specify a BW InfoArea (directory structure to group your objects), and press Save and Generate. This generates the Transient Infoprovider on the BW instance.

fig_1_11.PNG

14. The log screen pops-up once the generation is complete. Press the green check mark to proceed.


fig_1_12.PNG


This concludes Part-1

 

Part-2 Steps to Create a BEx Query


1. Go to Start–>All Programs–> Business Explorer–>Query Designer

fig_2_0.PNG

2. Key-in your credentials in the SAP logon and launch the query designer.

3. Press the Create icon to go to the Infoprovider selection screen. Select InfoAreas from the left panel and search for the InfoArea                                      (Design Studio Infoset) under which you generated the Infoset:

fig_2_1.PNG

4. Open the Infoset and select the required attributes and measures. Save the query with an appropriate technical name and description.

fig_2_2.PNG

fig_2_3.PNG

This concludes Part-2

Part-3 Consuming Transient InfoProvider in Design Studio

1. Launch SAP BusinessObjects Design Studio from the following path:

          Program Files –> SAP BusinessObjects –> Design Studio



2. Once Design Studio application is launched, go to Application menu and create a new blank application:

fig_3_0.PNG

3. Give a name and select Blank template and press create

fig_3_1.PNG

4. In the outline section, right click on Data sources and select Add Data Source..:

fig_3_2.PNG

5. In the next screen, choose your connection by browsing through the list of connections configured on your SAP Logon pad.

fig_3_3.PNG

6. Once the Connection is Active turns “GREEN”, browse for Data Source. Click on the Search tab and key-in the Technical name of the query which you      have created in the previous section.


fig_3_4.PNG

7. Once you have your query, press Ok and return to the previous screen. Press Ok.


fig_3_5.PNG


8. Right click on the data source in the outline section, and select “Edit Initial View”

fig_3_6.PNG

9. In the Initial View screen, right click on the members in Rows, and under “Totals Display” select “Hide Totals”. Repeat these steps for all the members:

fig_3_7.PNG

10. The final display should look like this:

fig_3_8.PNG

11. At this point, press the “OK + Create Crosstab” button at the bottom right hand corner.

fig_3_9.PNG

12. This is how it looks within the designer mode :

fig_3_10.PNG

13. Save the application and launch it in local mode to see how it looks in the browser:

fig_3_11.PNG

14. Browser view:

fig_3_12.PNG

This concludes the blog on how to consume application data within SAP Design Studio applications. There might be also other ways worth exploring, but this is one of the ways you can surface ECC based Application data within SAP Design Studio. I hope you find this blog useful.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply