How to Delete Unused Dimension Values from Info Cube in Process Chains

As a  BW developer you may need to remove some characteristics from cube’s dimension. This is needed in case of you do remodel your cube. You may even need to remove whole dimension(s) in some cases. 

OR 

In some cases if you want to restrict the list of values in Bex variable selections, to only the values in the cube.

To achieve this we created a simple ABAP program which uses the standard SAP function module with input selection screen. Using the input selection screen we can select the info cube(s) for which we want to delete the unused dimension ID's and create a variant so that we can scheudule this via process to keep our info cubes tidy.

0EMPLOYEE_ATTR Data Source Enhancements

As a BW Consultant, in your project you may require to enhancement the standard master data info objects as per your business requirements. This happens more often in HR space. Here I am providing you with an example of how easily you can enhance 0EMPLOYEE_ATTR data source with additional attributes.

I will not list all the necessary steps involved in this process. but i will provide you a working ABAP user exit code which you can use as a reference in your projects.

I've the requirement to enhance 0EMPLOYEE_ATTR data source in ERP side to extract the following additional information.

Pic-1 - Employee Attributes Data Source

As you can see from the above pic-1 i would like to enhance 0employee_attr data source with these additional attributes to make the data more meaningful. My scenario is to identify these additional attributes when an employee is acting on a different position (higher duties).

I wrote my ABAP code in an include program instead of directly in the CMOD include.