Sorun Cevaplayalım

İşinizle ilgili öngörüler edinin, gerçek zamanlı bilgilere göre karar alın.

SAP Eğitim ve Sertifika Dönemleri

Uzmanlığınızı ve deneyiminizi SAP çözümleri kullanarak tasdik edin.

Çözüm Ekibi Başvurusu

Kullanıcılara hızlı ve pratik çözümler üreterek görev almak isteyenler.

SAP BLOG BPC Embedded Model Auditing Feature in aDSO and InfoCube

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,035
Tepki puanı
6
Auditing is an important feature for a planning solution.

In BPC NW standard model, auditing was supported since 7.0. The auditing data is stored in a system generated table with the prefix /1CPMB/.

In BPC NW embedded model, the feature is implemented differently. There are multiple different types of planning objects that can be used( InfoCube, Direct Update DSO, Planning type aDSO, Direct Update type aDSO ). Not all of them are supporting auditing today.

In this blog, I’m going to talk about auditing feature in aDSO and InfoCube. The other two types of planning capable objects — Direct Update type aDSO and Direct Update DSO so far still don’t support auditing.

Before we start, make sure you’re aware of below Note and it’s successfully applied in your system.

2341545 – Support Auditing for aDSO

InfoCube


In BPC Embedded model, auditing is supported natively by BW. Once you switch on the flag in settings, BW is going to attache one dimension called “Audit Dimension” which includes 4 InfoObjects:

  • 0ATIMSTMP
  • 0AUSER
  • 0AMODE
  • 0ASOURCE

2018-02-23_10-37-21-7.jpg


BW automatically updates the 4 InfoObjects when the cube is updated.

2018-02-23_10-37-21-8.jpg


When the InfoCube is imported into BPC, the “Auditable” field is automatically marked.

2018-02-23_10-37-21-9.jpg


In BPC, there is also a switch of the auditing feature. You can choose to switch on or off the audit.

2018-02-23_10-37-21-13.jpg


The switch is not switching off the BW auditing flag. Actually the BW setting will remain on. What it does is to make the value of 0AUSER and 0AMODE a blank when you post new data, but the time stamp is still recorded.

So when you review the data in system report -> Data Change, you can will see entries like below.

2018-02-23_10-37-21-14.jpg


To filter out the 0AMODE = OFF values in the audit report, you need to create BW query instead of using system report.



The Auditing will also impact the behavior of BW compression.

As the Auditing InfoObjects are just normal InfoObjects. BW compression will not be able to merge the delta records because even though all the other master data value are exactly the same, the 0ATIMSTMP will still be different . This actually also makes the “Zero Elimination” behave differently than a normal cube.

Without auditing, BW compression with zero elimination will delete this record completely from DB.

Now with auditing on, BW only clears the Request ID. You can see all 3 values remain in the DB. It’ll no longer be possible to display a blank cell in the query or report. Instead, there will always be a zero. Unless you physically delete the record from DB or BW.

Before compression

2018-03-02_15-48-24.jpg


This also means the number of the rows in active data table will always grow if there is no archive in place.

2018-03-02_15-50-40.jpg


Cube-like aDSO


So far InfoCube-like aDSO is the only type of aDSO that supports auditing feature.

Other than the InfoCube, the behavior here is a bit different. There is no setting or flag for a InfoCube-like aDSO, as the auditing is always on and not possible to be switched off. You’ll find that whenever you created an aDSO, regardless of the type, there will be a technical group named “__TECH_FIELDS__ ” created and attached to it. The group contains only one InfoObject which is 0REQTSN. 0REQTSN contains two navigation attributes which are 0AUSER and 0ASOURCE.

2018-02-23_10-37-21-11.jpg



When the aDSO is imported into BPC, the Audit is automatically on and cannot be switched off.

hen

The audit data is stored in the Inbound table along with the request information, in my example, it’s /BIC/AZADSOT1.

When you open the BPC Data Change system report, BPC will generate a composite provider under the name space of /1BW/, see below.

2018-02-23_10-37-21-17.jpg


Below is what a Data Changes report looks like.

2018-02-23_10-37-21-16.jpg




Activation is going to erase your auditing data


As audit information is part of the request, audit information will go away with activation. So to keep audit information one should never do data activation for the aDSO.

Side effect


As the auto merge and auto optimize compression is off, and the auditing doesn’t allow you to do data activation, you need to trigger it at DB level to ensure good performance on reporting.

Another potential side effect is, without data activation or compression, the size of the aDSO is going to grow quickly.

2018-02-23_10-37-21-18.jpg




Other objects


By far, Direct Update DSO and Direct Update aDSO don’t support auditing. Good new is there is a BAdi named BADI_RSPLS_LOGGING_ON_SAVE which can be used to used. You can refer to the SAP Help Portal for more detail.



Hope you find the blog helpful.

Okumaya devam et...
 
Üst