SAP BW/4HANA cockpit is a Web-based interface used for administration of a BW/4HANA system. In BW/4HANA cockpit under the Data Management tab, you will find a tile named ‘Datastore Object’. By clicking on that you can do all the necessary administrative related to Advanced Datastore Object (ADSO)
So here comes a question what is an administrative task to an ADSO? Simple. It is just a replica of actions that you do when you choose to Manage option in your ADSO in the traditional SAP GUI. Along with this the web cockpit also provides you with much more features that you can play with your ADSO. It helps you with all the technical information about the contents of a Datastore object.
Let us get deeper about this tile.
When you select this tile, by default you can see few ADSO objects. You can search for the ADSO that you need by pulling down the arrow button and where you can see a search bar.
You can also filter based upon the aggregation status, which is basically Error, In progress, ok. When you have selected your ADSO, the screen displays the overall count of requests that have been loaded along with few other default tabs such as below:
These are nothing but the basic filters and you can add on a few more filters or remove this by clicking the settings icon where you can see a big list of filters:
These details can be exported as per your required format.
Viewing the Property
When you click on any empty space on the menu bar, you can see a pulldown showing the property of your ADSO.
After applying your filters, when you further click the space you can see a list of requests that have been loaded. By default, the system displays the last 10 requests. You can change this by choosing Last 10 Requests.
Under Select status, you can also display the deleted requests. Requests that have already been activated are not displayed.
By default, the display is updated automatically. If there are too many updates, you can deactivate them using Automatic Updates which you can see by clicking the Refresh button in the taskbar.
Working with the Data
To work on the data in your ADSO, you have the following options when you click the further options button:
- Display data
- Delete data
- Upload data
As the name says, this option enables you to display data in not only in a table form but also with different forms of charts shown below.
The Layout button helps you to customize your display rows and columns.
You are also provided to apply Conditions & exceptions when you display data as you do for the Query.
On the right side, there is an option to create comments for your ADSO which anyone who accesses the ADSO can view. Besides that, you see a filter option. When you click that, you can enter the data which you decide to display by entering through the ‘Adapt filters’ button.
E.g. If you decide to display data only for employee id 1, you can filter the same.
The icon in the top right corner enables you to do all the quick actions. The Open option here allows us to open any Query provided.
Besides that, you can see an option to send the data as an email or save this as a separate tile on your home page.
This tab provides you with the below three option to delete your data:
Selective Deletion is based on the input which you give to get deleted.
You can use selective deletion to delete records from the Datastore object with keys that no more data will be loaded for. This is the case for example if a product is taken out of a product range and no more data is loaded to its product number.
You might also want to delete data that is no longer needed, for example, because it is already over three years old or if the personal reference in the data requires deletion. You can also selectively delete data that has errors due to its processing in the BW system. On the other hand, data created with errors in the source system should not be selectively deleted. It should be corrected with reverse postings instead.
Delete Data from All Tables deletes all the data from new, active, changelog tables. Request Based deletion is based on the Request if you give if you know the Request Id.
This is one of the great features that the BWHANA Web cockpit has brought us. Would you imagine loading data to an ADSO without any transformations, lookups or other stuff? Well, it is possible now!
Simply click on the ‘upload data’ option and you will see a screen like this:
Only the file with extensions such as xlsx, xlsm, CSV is supported.
You can open your file to be loaded by clicking the browse button. After the file is imported, you must provide mapping with the columns in the file to match with your ADSO and then upload the file to your ADSO.
The best possible way to load your file is to click “Generate Template” button where the system generates an empty file with all the column names of your ADSO. You can type in your data that is needed and save the file. You can then browse this file and upload it to your ADSO! Simple as that!
You will see a separate request for this load in the manage page of your ADSO.
Working with Requests
If you click on a request ID, details of the request are displayed.
Under Processes, you can view history.
If you click on the entry in the Action column, a log of the request is displayed. Here, you can use Change Request Data to change the master data if the request has not been activated yet. If the request has already been activated, the master data can only be displayed. You can activate the request by choosing Activate. All previous requests are then activated as well. By choosing Copy Shortcut, you can send the log to Support for analysis.
Under Related Requests, you can see the load request. If you click on Load Request, you can see more information about the DTP under DTP Properties. If you click on the name of the DTP here, this takes you to the DTP display in the BW modelling tools if you have already opened the BW modelling tools.
A new interface
At the top left corner, you may see two tabs to view your request.
- Default view
- Advanced view
The default view is nothing, but which has a list of requests which we have discussed so far.
By choosing Advanced View and Highlight Relationships, you can view related requests. The related requests are highlighted with an icon. By choosing Range Slider at the top right, you can adjust the complexity of the display.
We have discussed all the features which are available for us from the Manage Datastore Object Tile in the Web Cockpit. Aren’t these interesting? Yes, definitely. Let us hope for many more features in the upcoming versions.