Version 4.11.0 revision 29379 built 2020-09-19 version 4.11.0 revision 29380 built 2020-09-20 Preview Release Unstable! Version 4.13.0 revision 29486 built 2020-11-27: version 4.13.0 revision 29486 built 2020-11-27. Step by Step creation of Exit type Data Slice for Planning Cube. It is a very common requirement in SAP IP or BPC 10.1 Embedded or IBP project that data entry protection is required based on business requirement. The standard selection type data slice is not at all helpful to fulfill the business requirement.

1. 4 Level Data Slicer Attachment
2. 4 Level Data Slicer Tool
3. Data Slicers Excel
4. 4 Level Data Slicer As Seen On Tv
5. 4 Level Data Slicer Manual
6. Excel Slicer Data Model

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.

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.

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.

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.

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.

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.

See the class and method code implemented.

To create the class and method, please follow the bellow link.

• 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.

4 Level Data Slicer Attachment

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.

Unlock the data via Administrative template.

The unlock functionality worked, which means that the posting from input enable query is now possible.

• 4Development status

• This is a first generation mock-up for a database display/download schema for Slicer
• The NA-MIC download data can be used for prototyping.
• thumbnails should be extracted for now from the center slice of the volume. Mechanism to replace manually. Down the road, we will use the thumbnail from the mrml file.
• Annotation should be extracted from the DICOM headers, if available. We will need a painless way to edit the annotation (with wiki style history). Once the slicer annotation module is working (summer 2011), we can extract information from there.
• Pack as many thumbnails as possible horizontally (based on width of browser window and font size)
• Only list one or two lines of text, the rest pops up on rollover.
• Pack densly, use space sparingly

• Case 1, study 1
  • Lupus001
  • last update on 2010-04-12 14:32:11 (13.4 MB in 8 files)
  • Brain MRI study of a subject with slight Lupus Erythematodes.
  • Download this study: Just the data, data with a mrml file for Slicer 3.6

• lupus001_T1.nii.gz
  128x256x256 voxels
  registered and bias corrected T1 series
  5.7MB - uploaded on 2010-08-10 19:35:20 by XXX
  Download, download with mrml

• lupus002_FLAIR_reg+bias.nii.gz
  128x256x256 voxels
  registered and bias corrected Flair acquisition
  4.86MB - uploaded on 2010-08-10 19:35:20 by xxxx
  Download, download with mrml

• lupus003_T2_reg+bias.nii.gz
  192x256x256 voxels
  registered and bias corrected T2 wieghted image
  6.34MB - uploaded on 2010-08-10 19:35:20 by xxxx
  Download, download with mrml

• Case 1, study 2
  • Lupus002
  • last update on 2010-04-12 14:32:11 (13.4 MB in 8 files)
  • Brain MRI study of a subject with severe Lupus Erythematodes.
  • Download this study: Just the data, data with a mrml file for Slicer 3.6

• lupus001_T1.nii.gz
  128x256x256 voxels
  registered and bias corrected T1 series
  5.7MB - uploaded on 2010-08-10 19:35:20 by XXX
  Download, download with mrml

• lupus002_FLAIR_reg+bias.nii.gz
  128x256x256 voxels
  registered and bias corrected Flair acquisition
  4.86MB - uploaded on 2010-08-10 19:35:20 by xxxx
  Download, download with mrml

• lupus003_T2_reg+bias.nii.gz
  192x256x256 voxels
  registered and bias corrected T2 wieghted image
  6.34MB - uploaded on 2010-08-10 19:35:20 by xxxx
  Download, download with mrml

• A. Support for local customization

1. Add SQL schemas to link a resource to a template. Done

2. Add support for administrators to create/edit links between resources templates. Done

3. Modify the core MIDAS to support templates at the resource level. Done (communities, collections)

• B. Specific Customization for NAMIC datasets

1. Display of the download page at the “collection” level according to the layoutthe wiki.

-Layout : Done

-Download All: Done

-Download All with mrml: Done

4 Level Data Slicer Tool

-Download single bitstream: Done

-Download single bitstream with mrml: Done

-Download single resource: Done

-Download single resource with mrml: Done

-Show Items information: Done

-Show Bitstreams Metadata: Done

2. Support for manually replacing a thumbnails Done

3. Implementation of javascript support to extend description on mouse over. Done (community page)

• C. Testing phase Done

• D. Upgrade of the MIDAS server Done

Demo

Screenshots

Data Slicers Excel

• Community level

• Collection level

• Manage thumbnails

How to link a template to a resource

First, go resource edit page:

Then select the template you want to use:

You can recursively apply the template. (All the children of the resource will use the selected template)

How to upload new files

First, go a collection page and create an item:

Click on 'Upload Files':

Select the files you want to upload (you can select multiple files)

If Midas warns you that a file is too big, use the 'large files' tool:

4 Level Data Slicer As Seen On Tv

When your files are uploaded, you can ask midas to create resources. If you do that, Midas will analyze the selected files and try to find the metadata:

How to change a thumbnail

First, go the an item page:

Then go a the menu and click on 'thumbnails':

Select the thumbnail you want to change:

Upload a new image (the application will resize the image)

4 Level Data Slicer Manual

If you like the new thumbnail, click on 'Set thumbnail' to finalize the modification

Excel Slicer Data Model