Is it possible to use Status Tracking System in SEM-BPS if BPS has multi?

[Former Member]

Is it possible to use Status Tracking System in SEM-BPS if BPS has multiplanning areas? If Yes how? if no do we have any alternative?

SAP study material clearly mentions that Status Tracking System can not be used if BPS has multiplanning areas.

Thanks and Warm Regards,

[former_member93896 · Accepted solution]

Hello Santoshkumar,

first of all there are situations where checking locks on multi planning areas would not work well. This is why we do not deliver this as a standard solution.

You can implement the following modification to check the locks for all basic planning areas if you execute something on the multi planning area.

* The standard STS locking is purely based on normal planning areas. 
* If you build a STS subplan on a multiarea the system will not lock the data. 
* With the modification the system will look-up the locks on all normal areas that 
* are part of the multiarea.

* NOTE: The modification works with SEM/BW-BPS but not with BI-Integrated Planning!

FUNCTION ups_check_package. 
... 

*--------- Sonderkoding für Stabscontroller ------ 
*--------- Diese haben immer Änderungsberechtigung für Daten 
*--------- unabhängig von evtl. existierenden Locks im STS -- 
  AUTHORITY-CHECK OBJECT 'R_STS_SUP' 
           ID 'ACTVT' FIELD '16'. 
  IF sy-subrc EQ 0. 
    EXIT. 
  ENDIF. 

*-- 1. Bestimmen des Teilplans/der Teilpläne ------- 

  SELECT * FROM ups_tp_hierarchy INTO TABLE lt_tp_hierarchy 
              WHERE area = i_area. 

*>>>>> START OF DELETION 
*  CHECK sy-subrc EQ 0. 
*<<<<< END OF DELETION 

*>>>>> START OF INSERTION 
  DATA lt_area            TYPE upc_area OCCURS 0. 
  DATA ls_area            TYPE upc_area. 
  DATA lt_i_area          TYPE upc_area OCCURS 0. 
  DATA ls_i_area          TYPE upc_area. 
  DATA lt_aream           TYPE upc_yto_area_key. 
  DATA ls_aream           LIKE LINE OF lt_aream. 

  TYPE-POOLS: upc1. 

  IF sy-subrc NE 0. 
*---If no subplan was found for the given basis area, 
*---go and look if area is contained in multiple area and 
*---to those are attached any subplans. 

*---Get all multiple areas in the system 
    SELECT * FROM upc_area INTO TABLE lt_area 
      WHERE 
        type = upc1_cs_area_type-multi. 
    LOOP AT lt_area INTO ls_area. 
      REFRESH lt_aream. 
*-----Get all basic areas in the multiple area 
      CALL FUNCTION 'UPC_AREA_GET' 
        EXPORTING 
          i_area       = ls_area-area 
        IMPORTING 
          eto_aream    = lt_aream 
        EXCEPTIONS 
          no_existence = 1 
          locked       = 2 
          OTHERS       = 3. 
*-----Is the given actual area contained in these? 
      READ TABLE lt_aream INTO ls_aream WITH KEY area = i_area. 
      IF sy-subrc = 0. 
        APPEND ls_area TO lt_i_area. 
      ENDIF. 
    ENDLOOP. 

*---Look for attached subplans 
    LOOP AT lt_i_area INTO ls_i_area. 
      SELECT * FROM ups_tp_hierarchy APPENDING TABLE lt_tp_hierarchy 
                  WHERE area = ls_i_area-area. 
    ENDLOOP. 

    CHECK NOT lt_tp_hierarchy IS INITIAL. 

  ENDIF. 
*<<<<< END OF INSERTION 

*--- 2. Lesen aller Headerkombis zu den Teilplänen und finden eines 
*--- passenden 
  LOOP AT lt_tp_hierarchy INTO ls_tp_hierarchy. 
    SELECT * FROM ups_header INTO TABLE lt_header 
          WHERE teilplan = ls_tp_hierarchy-teilplan. 

For BI-IP no modification is required: Copy class CL_UPS_LOCK_DATASLICE into your own class and adjust method CONSTRUCTOR accordingly.

See also: http://help.sap.com/saphelp_nw2004s/helpdata/en/43/548bafbc0f357ee10000000a11466f/frameset.htm

Regards,

Marc

SAP NetWeaver RIG

[Former Member · Accepted solution]

Hi Marc,

You mention in the above quite old thread:

"For BI-IP no modification is required: Copy class CL_UPS_LOCK_DATASLICE into your own class and adjust method CONSTRUCTOR accordingly. "

I am trying to use multi cube planning area and I am already using the above standard class which I ahev activated on the cubes dataslice. I have three cubes in the planning area. But the lock does not work.

You said to copy the class and adjust the Constructor method, can you elaborate on this please? Do I need to make any amendments here to be able to use mutli-cube planning areas?

Many thanks

Sulman

[Former Member · Accepted solution]

Marc,

I have made the following modification to the class constructor:

IF sy-subrc = 0.

IF l_s_upc_area-type = upc1_cs_area_type-multi.

• multi planning area

l_area = l_s_upc_area-area. " I ADDED THIS LINE

ELSEIF l_s_upc_area-type = upc1_cs_area_type-basis.

• basis planning area

l_area = l_s_upc_area-area.

ENDIF.

ENDIF.

and added the class in the IP planning modeller to all cubes involved, but still the data does not lock?

any suggestions?

Thanks

SMS

[Former Member]

hi santosh,

you can create the STS application on the plan cube(plan area) and not on multiplanning area.Now it does not matter even if you have the mutiplanning area.

if your design has mutiplanning area we must remember that plan data is always stored in the planning cube.its like the concept of data slices and charateristic relationship.the option to create both is not possible on a mutiplanng area.hence we create them on the plan-plan area.so you should create your STS on the plan area included in your mutiplanning area.it will certainly work.

regards

Sai Vishnubhatla

[Former Member]

Thx a lot. It was a very helpful suggestion. Can you post some links by which I can download pdfs containing informaion regarding STS configuration in sem-bps?