Skip to Content

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.

/wp-content/uploads/2013/06/1_234591.png

Step 2: You get a selection screen as shown below.

/wp-content/uploads/2013/06/3_234592.png

Step 3: Copy the program name for the screen using the menu System-> Status-> Program

/wp-content/uploads/2013/06/4_234597.png

Step 4: With the executed state of the program open a new session and goto T-code SE38.Copy the program and activate it.

/wp-content/uploads/2013/06/5_234598.png

Step 5: The selection screen will be displayed as follows.

/wp-content/uploads/2013/06/6_234599.png

Step 6: The necessary labels for the different fields can be enabled from the dictionary using the Goto -> Selection texts option.

/wp-content/uploads/2013/06/7_234600.png

/wp-content/uploads/2013/06/8_234601.png

Step 7: The selection screen gets modified as shown below.

/wp-content/uploads/2013/06/9_234603.png

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.

/wp-content/uploads/2013/06/10_234604.png

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.

/wp-content/uploads/2013/06/11_234605.png

Step 10: The program code and the corresponding setting in the selection screen are as shown below.

/wp-content/uploads/2013/06/12_234607.png

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.

/wp-content/uploads/2013/06/13_234608.png

Step 12: The selection screen gets modified for the settings as shown below.

/wp-content/uploads/2013/06/14_234609.png

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.

/wp-content/uploads/2013/06/15_234611.png

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply