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
- Transient Providers require ERP6.0 EhP 05.
- Infosets and BW install should be in the same system
- Only client-independent Infosets are available
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
- Log into the SAP instance where BW is also installed.
- Go to transaction code SQ02.
- Give an Infoset name and press Create
4. Give a description and define the table name as SFLIGHTS and press the Green Check Mark to proceed.
5. Next, we add another table and map the fields.
6. In the pop-up dialog, enter SPFLI as the 2nd table name and press the Green Check Mark :
7. Fields are automatically mapped :
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:
9. In the next screen, choose “Generate” to generate the Infoset:
10. Upon generation, a message in the status indicates that the infoset was successfully generated:
12. Final step in the process is to release the Infoset. From the menu, click on Environment–>BI Properties:
Press the Green Check Mark to proceed.
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.
14. The log screen pops-up once the generation is complete. Press the green check mark to proceed.
This concludes Part-1
Part-2 Steps to Create a BEx Query
1. Go to Start–>All Programs–> Business Explorer–>Query Designer
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:
4. Open the Infoset and select the required attributes and measures. Save the query with an appropriate technical name and description.
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:
3. Give a name and select Blank template and press create
4. In the outline section, right click on Data sources and select Add Data Source..:
5. In the next screen, choose your connection by browsing through the list of connections configured on your SAP Logon pad.
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.
7. Once you have your query, press Ok and return to the previous screen. Press Ok.
8. Right click on the data source in the outline section, and select “Edit Initial View”
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:
10. The final display should look like this:
11. At this point, press the “OK + Create Crosstab” button at the bottom right hand corner.
12. This is how it looks within the designer mode :
13. Save the application and launch it in local mode to see how it looks in the browser:
14. Browser view:
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.