It is possible to modify the display of Business layer objects by using Business layer views to restrict the number of objects displayed in the Business Layer pane. Use business layer views to group objects that share a business relationship.

Business layer views can be selected in the Query Panel. You can use business layer views to define security to grant or deny the use of business layer objects to certain users or groups.

Creating Business Layer View

To create or edit Business Layer view, open Business Layer editor by clicking on Business layer in the local project.

Click Manage Business Layer view option in the Business layer view pane.

sap 8 1

When the ‘Edit Business Layer’ view dialog box opens, to add a new view, click on “New” button. Edit the view name in the Name textbox.

In the Objects in view box, select or clear the checkboxes next to objects in the business layer to include or exclude them from the view.

To work with only the objects already included in the view, select Show selected objects only as shown in the following screenshot.

Enter or edit a description for the view in the Description textbox.

sap 9 1

Click OK to save the changes.

Note − You can’t change Master view.

Parameters

You can create a parameter in Business Layer or Data Foundation that requires a user input or predefined input value.

A Parameter can have the following input types −

User input as a response to prompt.
A predefined fixed value.

Prompt to users	If selected, the user is prompted to enter a value at run time. If cleared, a pre-defined value is entered at runtime for the parameter.
prompt Text	The text for the prompt question or directive if Prompt to users is selected.
Set Values	Available when the prompt to users option is unselected. Lets you enter one or more values to be used for the parameter at the run time.
Data Types	The data type required for the answer to the prompt.
Allow multiple values	If selected, lets the user take multiple values from the list of values.
Keep last values	If selected, the last value chosen by the user is kept when the prompt is re-run.
Index aware prompt	If selected, the key column is included in the prompt to restrict the values in a list. The key column is not visible to the user.
Associated list of values	A list of values to provide values for the prompt.
Select only from list	If selected, the user is forced to select a member in the list.
Select default value	Lets you select values to be used as default

Inserting and Editing Parameters

When you define a parameter in Data Foundation, they are directly inherited to business Layer on top of Data foundation. These parameters can’t be edited in Business Layer and you have to edit them in Data Foundation.

To insert a parameter, click on parameters and LOVs tab in the browsing pane → Click on Insert Parameter icon.

sap 10 1

Parameters properties are shown in the right pane. You can use various properties as defined in the previous topic.

sap 11 1

To edit an existing parameter, select the parameter from the list and edit it.

LOVs and Properties

Using LOVs, you can select the value of a prompt from the list of values associated with an object. It allows a data set to be restricted to the selected values.

You can use LOVs for an object in Data Foundation or Business Layer. Different types of LOVs can be used.

LOVs based on Business Layer Objects − In this case, LOV is based on other query or on a hierarchy that includes

Static LOVs − It includes List of specified values manually or imported from file.
LOVs based on SQL − It is value return by specific SQL expression.

Inserting and Editing LOVs

To insert or edit an existing LOV, go to Parameters and LOVs tab in the editor. Click on Insert + sign in the LOV pane −

sap 12

The properties of LOVs appear in the right pane. To edit an existing LOV, click List of Value in the list.

The Properties tab in LOVs properties lets you edit the column properties on LOVs. You can edit the following properties by clicking the property column in the table of properties −

sap 13 1

Column Name − You can edit the name of the column.

Key Column − You can select a column to be index aware key.

Data Type − You can select the data type for the column.

Hidden − If you select this option, the column will not be displayed.

Queries in Business Layer

A Query panel is used to create queries and query objects are associated with the Business Layer. These are normally used in IDT to validate the Business layer.

Inserting and Editing a Query

To insert a new query or edit an existing query, click the Query pane in the Business Layer pane.

sap 14 1

Click Insert Query to add a new query. This will open the Query panel. You can create a new query or edit an existing query and click OK. Select the objects in Query panel → OK.

sap 15 3

Enter the name and description of Query. You can edit the objects in query by clicking Edit query option. To execute the query → Execute Query.

sap 16 3

Aggregate Awareness

Using aggregate awareness, you can use pre-aggregated data in tables in the database. It is used to improve query performance by processing less number of rows.

When you add an aggregate aware object in query, the query generator retrieves the data from the table with the highest aggregation level.

For example − Consider a Sales Fact table where sales is aggregated by per month. If your query asks for sales per month, the query generator will retrieve the data from aggregated table.

Setting Up Aggregate Awareness

To use aggregate awareness, first the aggregated table has to be loaded to database and then add the table to Data Foundation.

Define aggregate aware objects. These are the objects in the business layer for which you want queries to use the aggregate tables when possible, instead of performing aggregation using non-aggregate tables.

In the SQL expression for the object, define the SELECT statement to use the @Aggregate_Aware function −

sap 17 3

@Aggregate_Aware(sum(aggr_table_1), …, sum(aggr_table_n))Select the object in Business Layer → go to SQL Assistant → under Functions → Aggregate Awareness.

sap 18 2

So, this brings us to the end of blog. This Tecklearn ‘Business Layer View in SAP IDT’ blog helps you with commonly asked questions if you are looking out for a job in SAP Business Object and SAP Domain. If you wish to learn SAP IDT and UDT and build a career in SAP domain, then check out our interactive, SAP Business Objects Certification Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/sap-business-objects-certification-training/

SAP Business Objects Certification Training

About the Course

Business intelligence tools and features are used by multiple companies and firm for the effective results their large flow of data. The completion of this SAP Business Objects training will be helpful in landing yourself a good paying job. With this Business Objects online training, you will gain considerable proficiency in SAP BO architecture, data warehousing, use of Information design tool, create multiple reports and the implementation of Web intelligence and Efficiency in solving the issues of data sources and Crystal dashboard design.

Why Should you take SAP Business Objects Training?

The Average salary of SAP Business Objects Business Intelligence Analyst is $94,000 per annum – PayScale.com
Business Objects is an enterprise reporting tool and Scalability is one of the primary reasons large corporations choose Business Objects for their BI needs.
Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.

What you will Learn in this Course?

Introduction to Business Objects

History and Version of Business Object
How Business Objects works in SAP family
SAP BO-Business Intelligence package and tool list
Data warehousing concept from SAP perspective

SAP Business Object Architecture

SAP BO Architecture
Various tiers in architecture: Client, Processing, Intelligence

SAP Web Intelligence

Web Intelligence Overview
Variable in Web Intelligence environment

Using Universe Designer Tools (UDT)

Overview of the Universe Designer Tool
Working with shared, secured and personal connections
Understanding of the Semantic layer

SAP BO Reports

SAP BO Reports
Chart Reports, Table Reports, Sorting and aggregating of Reports
Various elements of Reports, graphs, text elements
Reports and Filters
Section Report
Break Report
Alerts Report
Scope of Analysis Panel
Conditional Reporting
Ranked Report
Drill Report

Advanced Formatting

Advanced methods of formatting in SAP BO
Identifying Chasm trap and resolving Chasm traps with various methodologies
Detection and resolving of loop

Information Design Tool (IDT) Integration

Introduction to SAP BO information design tool
Extracting data from various sources using OLAP methodologies
Creating of Universe with IDT
IDT Vs UDT
Working with IDT as an Integration tool

Getting started with Crystal Dashboard

Data visualization tool for creating interactive dashboards
Point-and-click Features
Various dashboard features and interface

Live Office

Live office
Detailed design of Crystal Dashboard

SAP BO 4.2 Features

Got a question for us? Please mention it in the comments section and we will get back to you.

594