Aller au contenu

Exploit - Remove requests from a cube

Supprimer une demande d'un cube

1 - Get Request Number

Solution 1 

1
2
3
SELECT icube 
FROM rsmonicdp INTO TABLE li_cube 
WHERE icube IN AAAAAAAAAAAAAAA AND qmstatus EQ SSSSSSSSSSSSSSS.

Solution 2 

1
2
3
4
5
6
7
8
9
CALL FUNCTION 'RSSM_ICUBE_REQUESTS_GET' 
    EXPORTING 
        i_infocube = AAAAAAAAAAAAAAA 
    IMPORTING 
       e_t_request = li_msg[] 
    EXCEPTIONS 
        wrong_infocube = 1 
        internal_error = 2 
        OTHERS = 3.
2 - Sort by Date to get the last request

3 - Remove request 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
CALL FUNCTION 'RSSM_DELETE_REQUEST' 
    EXPORTING 
        request = ZZZZZZZZZZZZZZZ 
        infocube = AAAAAAAAAAAAAAA 
    EXCEPTIONS 
        request_not_in_cube = 1 
        infocube_not_found = 2 
        request_already_aggregated = 3 
        request_already_comdensed = 4 
        no_enqueue_possible = 5 
        cube_in_planning_mode = 6 
        OTHERS = 7.

METHODE ALTERNATIVE

Goto Se11 --> enter table "RSICCONT" Monitor: Saving of the updated IC and ODS per request.

Enter DSO name in infocube name.

Execute

it will display the requests present in the DSO. -->select the request and from the menu "table entry" -->select delete(SHFT+F2).

the request will be deleted from the DSO.