Neler Yeni
Hoş Geldiniz,

SAPOfis Türkiye üzerinde yer alan içeriklere erişim sağlayabilmek, projelerinizde karşılaştığınız sorunlara birlikte çözüm üretebilmek adına üye olunuz. Unutmayalım ki, bilgi paylaşıldıkça değer kazanır.

SAP BLOG SAP BW: How To Create And Use Precalculated Value Sets (Buckets)

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
354
Beğeniler
4
Puanları
6
#1
Precalculated Value Sets (Buckets)




Applies to:

SAP BW



Summary :

To make SAP BW BEx queries more flexible & interactive, SAP Has given numerous functionalities in BEx Designer and Analyzer. BEx variables is one of those. There are multiple types of variables provided by SAP .

This document helps you to understand BEx variable with precalculated value set (Buckets) along with creation and use of it in BEx query.



Author : Pradip Nikam

Company : Cognizant Technology Solutions

Created on : 28 Nov 2018



Author Bio :

Pradip Nikam is working with Cognizant Technology Solutions. Pradip has worked on various SAP BW implementation & support projects.



Table of Contents

  • Introduction
  • Step By Step Procedure
    • Bucket Definition
    • Variable Creation
    • Use in Query



Introduction:

This Article describes how to create Pre-calculated value set functionality in SAP BW & use it in BEx query.

A bucket is a pre-calculated value set that is stored either in a database table or in an index in SAP BW Accelerator and can be used as a filter in a BEx query.

The filter is defined in a BEx query as a variable of type Pre-calculated Value Set and executed at runtime.

Use of Precalculated Value Sets (Buckets) results in significant runtime improvements if large amounts of data are processed in the bucket.



Step By Step Procedure to create & use Precalculated Value Set (Bucket):

  • Bucket Definition

Transaction Code – RSBUCKET

proxy.php?image=https%3A%2F%2Fblogs.sap.com%2Fwp-content%2Fuploads%2F2018%2F11%2FBucket1.jpg&hash=8af92aa1c503b3931f9de139bf3f071e


Specify the characteristic for which you want to use Precalculated value set.

Also specify the name of Bucket.

You can also enter a description.

To fill a bucket with data, you can either use a reference table or add the data directly.

If you want to use an existing reference table, select Use Existing Sources. You can select the reference table under Existing Table or Index. The system can read the data either from a specified column in a database table or from a column in an index in SAP BW Accelerator.

Here we use reference table Data.

proxy.php?image=https%3A%2F%2Fblogs.sap.com%2Fwp-content%2Fuploads%2F2018%2F11%2FBucket2.jpg&hash=a9e1b40fe4665972ad178e84720f1385


Specify whether the reference is an ABAP table or an index in SAP BW Accelerator.

Choose either key values or SID values.

In the Field Name in Table/Index field, specify the column that you want the characteristic values to be read from.

Save the settings.

  • BEx Variable Creation:

Create the characteristic value variable with type pre-calculated value set on the same characteristic on which bucket has been defined.

proxy.php?image=https%3A%2F%2Fblogs.sap.com%2Fwp-content%2Fuploads%2F2018%2F11%2FVariable.jpg&hash=b48e1dee583bbc2d1db4e8af23e09c88


  • Use the same variable in the query:

proxy.php?image=https%3A%2F%2Fblogs.sap.com%2Fwp-content%2Fuploads%2F2018%2F11%2FQRY_DESIGNER.jpg&hash=92191979c0ed5e8404b89db855f01246


Upon query execution

proxy.php?image=https%3A%2F%2Fblogs.sap.com%2Fwp-content%2Fuploads%2F2018%2F11%2FQRY_ANALYZER.jpg&hash=68ecff6560800b262d4e90e467a094bd


You can see the same bucket you defined for characteristic.

Conclusion:

The system has precalculated the required value set, which is now available in the form of a bucket. If you have updated bucket values manually, you can add, change, delete the bucket values.

A variable that refers to buckets can only be used as a filter in characteristic restrictions.



References:

SAP Help Portal

Okumaya devam et...
 
Üst