Real time cube data – Direct extract to file
Scenario: In Real time cube if the keyfigure values are changed by input ready functionality, two records will be created one with a negative sign to initialize the existing record and the other with the newly entered value. If we need both the records for further processing then it becomes a problem, because when we try to extract the data from the cube we get only the aggregated result set, hence we get only the value that was entered lastly.The only place where we can see all the records is during the Display data option in the cube.
This document explains the process of how to get the data into a file in local workstation. In a similar way the values can be updated to a database table or into a file in the application server.
Step 1: Goto T-code LISTCUBE. Provide the cube name as shown below and execute it.
Step 2: You get a selection screen as shown below.
Step 3: Copy the program name for the screen using the menu System-> Status-> Program
Step 4: With the executed state of the program open a new session and goto T-code SE38.Copy the program and activate it.
Step 5: The selection screen will be displayed as follows.
Step 6: The necessary labels for the different fields can be enabled from the dictionary using the Goto -> Selection texts option.
Step 7: The selection screen gets modified as shown below.
Step 8: The “Fld Selectn for Output” should be enabled for the desired fields to get it in the output. Presently the display will be as shown below.
Step 9: To make these fields enabled permanently during the execution of the program and to propose the preferred target location for placing the file, the following changes need to be made.In our case we will enable the single Characteristic Info object as shown below.
Step 10: The program code and the corresponding setting in the selection screen are as shown below.
Step 11: In our case as we are planning to place the file in the workstation, we will enable the Radio button “Store in file (workstation)” and provide the “Name of the table or file” in the text box provided.
Step 12: The selection screen gets modified for the settings as shown below.
Step13: On executing the program (ZCOPY_PGM) a new file is created in the local work station with all the 3 records from the cube.