This document will describe step by step procedure to implement Data Slice lock using BPC embedded Technology. This concept has been described using BPC 11 Embedded and BW4HANA technology.
- Administrator can Lock / Unlock Data via Analysis Office Template by clicking one button.
- Once Data Selection is being locked by administrator, no one can plan or post any data for that locked selection.
- Once Data is being unlocked by administrator, posting / planning can be possible within that unlocked data selection.
We assumed a generic architecture, which can be used by any planning scenario.
Normally for any Embedded Planning scenario, we have two distinct data flows. One is normally coming from BW Actual Data which is denoted in below diagram as ACTUAL – Data aDSO. The PLAN – Data aDSO denotes the Planning related data to be posted in this aDSO. The composite provider joins both Actual and Plan data. The Aggregation Level – Plan has been created on the top of Composite Provider and the Planning Query has been created on the top of Aggregation level. The Planning Sequence has been created on the top of Aggregation Level.
- Create a slicer visual for your report and then select a date value for the Field value. Select the slicer on your canvas and then the carat in the upper-right corner of the slicer visual. If the visual has date data, the menu will display the option for Relative. For the relative date slicer, select Relative.
- Power BI provides slicers for single columns, but there are scenarios where it could be useful to consolidate alternative filters for multiple columns into a single slicer. Technically, this is not possible in Power BI through the standard visualizations, but you can use a particular data modeling technique to obtain the desired result.
- Slicer 4.10.2 released. 3D Slicer is an open source software platform for medical image informatics, image processing, and three-dimensional visualization. Built over two decades through support from the National Institutes of Health and a worldwide developer community, Slicer brings free, powerful cross-platform processing tools to physicians.
We introduced another aDSO, named LOCK aDSO which will store the Lock unlock information. The lock and Unlock will be two planning functions one will make an entry with some Flag value as Locked and another planning function will change the Flag value as unlock. The Below figure shows the diagram.
The Data module acts as a central data-organizing point in Slicer. It shows the data loaded into Slicer in various views. The Subject Hierarchy view shows the data in an easy-to-explore way, and offers operations on the data nodes, while Transform Hierarchy supports exploring transformation chains, and the All Nodes view shows all nodes in an. Step 4: New slicer is created with a list of names having selection boxes before them. Step 5: Drag and resize the elements present on the canvas to make room for the slicer. Step 6: Select the names that are present on the slicer and make a note of the effects on the other visualizations on the page.
Sometimes the Lock / Unlock information can be stored in within same Plan aDSO. The Composite provider can be created on the top of all 3 aDSO’s: Actual aDSO, Plan aDSO and Lock aDSO.
The below figure shows the diagram.
In our example we have a transaction data for Actual and Planning as below.
We want the below mentioned selection is relevant for locking mechanism. For any entry with a flag value ‘1’ is locked and the same selection with flag value is ‘0’ for unlock.
Direct Update Planning aDSO to be created.
For storing the Lock / Unlock information we created a separate aDSO which is planning enable and it is also direct update in settings.
![4 level data slicer tool 4 level data slicer tool](/uploads/1/1/9/6/119608804/800313260.jpg)
In our example, the below characteristic are the lock relevant.
We maintain the primary key as it is direct update aDSO.
Aggregation Level for lock to be created.
We need to create the Filter, Planning Function and Planning Sequence for Lock / Unlock Functionality. We added all lock relevant characteristic in Lock / Unlock Aggregation level.
Planning Filter for Lock / Unlock to be created.
We are going to use the same Planning filter for Lock operation and same planning filter for unlock operation. Normally administrator will first lock and then unlock for a particular selection.
In our example, Administrator will lock or Unlock based on Account and Posting Period Value.
Planning Function for Lock to be created.
We are going to create a planning function which will be created by FOX code. Dynamically we will read the planning filter value via FOX code and add the lock entry in direct update aDSO.
The FOX code shown below will generate an entry for lock. We are adding one entry with Flag value as ‘1’ which represent the Lock entry.
Planning Sequence for Lock to be created.
We will call this Lock function from Analysis Office Template, so we are going to create a planning Sequence.
Planning Function for Unlock to be created.
To unlock, we are going to modify the Flag value to ‘0’. We are going to create a Planning Function for unlock functionality.
See the settings.
The FOX cod would be as below.
Planning Sequence for Unlock to be created.
To call the planning sequence from Analysis Office Template, we need a planning sequence.
Analysis Office Work book to be created.
We are going to create Two Buttons in our example, one is Lock and one is Unlock. We need a have user selection where user wants to see whether the particular selection is locked or unlocked. The Template Looks like below.
4 Level Data Slicer Attachment
If you click, lock button and entry for lock will be generated. If you unlock the button then same entry flag will be modified to ‘0’. Let’s press lock button and see the changes.
Chinon sound 7000 manual typewriter. See the lock entry.
Let’s press the unlock button and see the changes.
Exit to be created.
This Exit class will read the value dynamically during planning posting in planning cube and stop posting data if the value is locked. Need to create a class and write the code to read the value from aDSO.
![Data Data](/uploads/1/1/9/6/119608804/948567701.jpg)
See the class and method code implemented.
To create the class and method, please follow the bellow link.
Repair or replace the control valve (sub). 5 Normal Hydraulic pump at fault. Hydraulic pump fault. Faulty Foam in the hydraulic tank. OVERALL MACHINE TROUBLESHOOTING V-9 TL140 1. Inspect the hydraulic oil level. Machine Configuration, Hydraulic. The Takeuchi TL140 manual is intended for persons who engage in maintenance operations, and explains procedures for disassembly and reassembly of the machine, check and maintenance procedures, maintenance reference values, troubleshooting and outline specifications, etc. TAKEUCHI TL140 CRAWLER LOADER service manual & repair manual can easily help you with any repairs that you may need to do. Many people are scared to touch their machine because it seems difficult. This is only true when you do not have the resources. Takeuchi tl 140 service manual.
Data Slice to be activated.
Now the exit class to be linked with data slice where planning can be done.
Go to RSPLAN and select the PLAN aDSO name.
You can refer the below link for step by step creation.
Test the Data Slice.
We have a planning Query which will input data in our system. Our intention is to check the data slice working principle.
a) First step, we will push the data from input enable query.
We open the input enable query and we have seen it is input enable so we can change the data.
b) Second Step, we will lock the selection from administrative template.
Now we are going to lock the data via administrative template.
c) Third step, Try to push data in system via same input enable query. The posting of data is not allowed.
To lock the mentioned selection, we run the lock button providing the same selection.
We do not have any values as we have not pressed the button. Press the Lock button so the lock entry will be generated.
See the locked entry is grayed out, that means the input is not possible. Planning is not available for this selection.
d) Last step, unlock the data selection and try to post the data again via query.
4 Level Data Slicer Manual
Unlock the data via Administrative template.
4 Level Data Slicer Tool
The unlock functionality worked, which means that the posting from input enable query is now possible.