0ANALYSIS_PATTERN: standard web template SAP BI

The initial setup of your Web template is critical to what the final structure of the report will be. SAP offers a number of helpful activities and approaches that make the configuration process in the WAD much easier for you. SAP also provides a great standard Web template, 0ANALYSIS_PATTERN, within the WAD. SAP offers quite a few of these standard-delivered Web templates, but 0ANALYSIS_PATTERN is the granddad of them all. It incorporates over 90 percent of all the Web items into its format and offers a number of different approaches to its use. For example, if a customer requests a very unique format, I start by copying the
0ANALYSIS_PATTERN template and then deleting the parts the customer doesn’t need. This approach is easier than building from scratch the components that are needed. 0ANALYSIS_ PATTERN also controls about 80 percent of everything that you can do from the BEx Web Analyzer, so getting used to and comfortable with the functions and makeup of this template is very important. Also remember that since it is standard business content in most cases it will be very effective in terms of performance of the report.

Because 0ANALYSIS_PATTERN is the most comprehensive template in the WAD, we will review some of its features to wrap up this chapter. As you will see, many of the other Web templates that are delivered standard in the WAD are incorporated into this template.For example, the Print function available via the
0ANALYSIS_PATTERN template is actually controlled by another template that is embedded into this template; 0ANALYSIS_ PATTERN_EXPORT controls the Print function and the features available for printing.

For the Web application, the placeholder for the data provider is filled during runtime, and Web items, data providers, and commands are generated at runtime based on the data provider chosen. This allows the use of the Web template by multiple data providers. The 0ANALYSIS_PATTERN template, for example, is used by all default BEx Web Analyzer reports, so this requires that the data provider be filled in at runtime by the current query being executed. In the Web template, you determine from which data provider and in what way (based on the inserted Web items) the BI data is displayed. When a request is sent from a Web application to the application server for ABAP, a Template object is generated, from which the structure of the requested XHTML page is derived. The data provider and Web items are the objects generated on this basis.

We will be working our way through all of the different Web items displayed by the 0ANALYSIS_PATTERN template in later, but at this point I want to introduce some of the components of the template and show you what is possible if you get into the details of the WAD. The following illustration shows just one portion of this Web template.


First notice that some errors and warnings are already listed in the Errors and Warnings screen area. These refer to the fact that, in this particular Web template, no data providers are assigned. We don’t really have to worry to much about this since we’re using this Web template for the standard process for all of our BEx Web Analyzer queries.

NOTE We will discuss in more detail what a data provider can do for you in terms of chart and graph functionality, but at this point the definition of a data provider has been reviewed in our previous discussion.

I recommend that, initially, you use this standard Web template until you understand its functionality fully. Then, if necessary, you can tweak this template based on what your company wants to display. If tweaking is required, you might decide to use a Z template rather than change the 0 template. A Z template is a copy of the 0ANALYSIS_PATTERN template with the addition of your company’s personalization information. If you decide to go with this approach, you have to make the Z template the default template for all your queries. Again, this is something to review and discuss before configuration, because whatever changes you make will affect all the Web reports for your company. You really want to avoid having multiple Web templates as defaults for different divisions or groups within your corporation. Supporting numerous templates requires too much maintenance and effort. If you can’t avoid having multiple Web templates, you can assign the support role for these templates directly to the individual departments, based on the setup of the companies Competency Center for BI.

If you determine that you need to adjust the 0ANALYSIS_PATTERN template for the entire company to meet a critical requirement—such as a disclaimer at the bottom or a corporate logo at the top of all your reports—you need to go into the IMG and insert the required template into the configuration. Normally, the
0ANALYSIS_PATTERN template is the default, but now you want yours to be the default. To do this, go to IMG | SAP Reference IMG | SAP NetWeaver | Business Intelligence | Settings for Reporting and Analysis | BEx Web | Set Standard Web Templates. You will see several options for different templates, but the one you are interested in is the Ad Hoc Analysis field, shown in the following illustration. Inserting your Z template, which is a copy of the 0ANALYSIS_PATTERN template with the customized changes, into the field will replace the 0 Web template for all BEx Web Analyzer reports.

Change view set standard web templates details

Let’s talk for a moment about some of the different components of this standard Web template. The initial screen template that is generated by0ANALYSIS_PATTERN is shown in the following illustration. This is the Web display of the configuration found in the WAD. This toolbar is what the business user will see based on the standard 0ANALYSIS_PATTERN template we are working with and any changes we might have made. This toolbar offers an impressive amount of functionality that are the standard delivered options built into the Web and available for you from the start of your configuration.

Change view set standard web templates details

Let’s look at just one of the areas of this template to see all the work that goes on behind this toolbar:

1.Scroll down the template configuration about a quarter of the way until you see two containers labeled CONTAINER_LAYOUT_TOOLBAR and TOOLBAR_RIGHT_AREA, as shown next. These two objects control the Web items that you see across the standard template toolbar. Additional Web items are displayed within each of these container areas.

Additional Web items are displayed within each of these container

2.Click BUTTON_TOOLBAR_2 in the bottom-left corner and take a look at what is behind the scenes to support this functionality. The Properties screen area changes to show the components of this one item, as shown in the following illustration.

changes to show the components of this one item

3.In the list of Text items on the Web Item Parameters tab, click the third button to open the Edit Parameter dialog box, shown next. In the far right of the row labeled Command (under Action), click the button with a dot on it.

Edit Parameter dialog box

4.The Edit Command dialog box opens, shown next. This shows the actual components that make up just that one button on your template toolbar—Print Version. This shows that the Print action will be to a PDF (Default) file and that you need to review another template to see in what format this PDF will be generated. This template is listed at the top of the screen, 0ANALYSIS_PATTERN_EXPORT. As you know, in SAP terminology there are some headings that don’t seem to be logical in terms of the English interpretation of the task. In this case we see that the dialog box shows Export Web Application (EXPORT) at the top. Well, this is the SAP-defined term for downloading or exporting the information to a PDF file. You can also see that the PDF is noted on the field for Export Format.

Edit Parameter dialog box

Now we can continue to drilldown on this portion of the template but needless to say this can be a very complex process. If you drilldown on the template noted above you will see that the format of the PDF will start with some basic information about the variables, then the report name and finally a report of the information. The PDF will not generate a graph or any additional information. If you decide that this is not sufficient for your requirements or that you need to adjust the current format of the PDF, you have two options: tweak the standard content 0ANALYSIS_PATTERN_EXPORT template, or create another template that you have customized and then replace the standard template with your own. This can get a bit tricky, and you may have to go through a few iterations to get this right. Basically, it’s just a bit touchy in terms of either changing the standard template or reassigning a new template, but in either case you can alter the look and feel of the Print version of your report.

As a second example, follow the preceding list of steps, but when you get to Step 3, choose the fourth button instead of the third button in the list of Text items. In the Edit Parameter dialog box that appears, shown next, you can see that this is also an Export action of some sort. Again, click the single-dot button in the far right of the Command row.


As you can see in the Edit Command dialog box, shown next, this is a bit different from the Print version command but does something similar—export to Excel, as indicated in the Export Format row.


Interestingly, the format of the Excel document is listed in the Data Binding rows above the Export option versus the PDF option. We had to drilldown on another Command to get to the template with these settings. As shown, the Excel document will display a chart, an analysis (report), any exceptions and then the query title. You can easily switch these Web items directly from this dialog box or add to them by using the Web Item Line currently marked Default.

As a final example, go back to Step 2 in the first example, but this time click LINK_SETTINGS (shown in the lower-right corner of the illustration following Step 2). This Web item shows what is behind the functionality of the Settings link on the far right of the toolbar that the business user sees in the Web reports using the standard template. The configuration object for this link is shown in this illustration.


Scroll down the screen a bit and you can see that the SETTINGS_TAB lists a series of different Web items, including PROPERTIES_ANALYSIS, PROPERTIES_CHART, EXCEPTIONS, CONDITIONS, and PROPERTIES_DP, as shown in the following illustration.

PROPERTIES_DP, as shown in the following

If you go to the basic template toolbar and click the Settings link, you will see that each of these Web Items appear as a tab, as shown next.

PROPERTIES_DP, as shown in the following

Notice all the different components available for adjusting the settings for just the TABLE object, including the ability to switch the layout and configure both cell- and data specific settings. This entire configuration is standard delivered by this template. You can now see why using this template and making a copy of it to start any additional formatting is probably not a bad idea.

The preceding examples highlighted just a few of all the items stored within the standard Web template 0ANALYSIS_PATTERN. In the case of this standard Web template, we could go on for quite some time reviewing and digging deeper into the details of each of the Web items. The purpose of these basic examples was to emphasize that you will need to get very familiar with this template to support your configuration. If you are going to create a Z template for some reason, a good approach is to start with this standard template, make a copy, and then filter out any of the objects that you don’t need. This is better than starting from scratch and trying to build all of this functionality into another template.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP BI Topics