Additional Blogs by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

Changes to BW objects and transporting those objects to another system is something that occurs quite often.

 So now what happens when let’s say an infocube is changed and collected in a request? The DTPs associated with it are turned inactive!! The Multi Providers that use this particular info cube are inactive!!

And when these objects are not collected along with the infocube and when the corresponding request is transferred, this in turn would make the dependent objects inactive in the Quality and Production systems!

So When objects are collected in a request, it is considered to be a best practice to check if the dependent objects are also collected in the request.

Here is a list of objects and their dependent objects.

Object

Dependent Objects

InfoCube

  • DTPs that load from and to this infocube
  • Transformations from the cube to further targets Transformations from the sources to this cube
  • Multi Providers which use the infocube

DataStore Objects

  • DTPs that load from and to this DSO
  • Transformations from the DSO to further targets Transformations from the sources to this DSO
  • Multi Providers which use the DSO

IOBJ

  • DTPs that load from and to this DSO
  • Transformations from the DSO to further targets Transformations from the sources to this DSO

InfoSources

  • Transformations from and to the infosources
  • All Dtps for targets associated with this infosource

DTP

Error DTP for this DTP

Transformations

All DTPs associated with the target

 

Now to identify the list of inactive objects in the system, I have listed below the tables that can be checked.

1)      Datastore objects

Goto table RSDODSOLOC and pass the input DSO name. (Let the objvers and activefl be blank when you pass values)

The DSO is inactive when:

 a)      When you find an entry with OBJVERS = “A”, OBJSTAT = “ACT” and ACTIVFL = “ “.

b)      When you find an entry with OBJVERS = “M”, OBJSTAT = “ACT” and ACTIVFL = “ “.

c)       When you find an entry with OBJSTAT = “INA”

For eg: The DSO ZTRDSO is inactive because an info object has been added.

 

The table RSDODSOLOC has the following entry for the DSO

 

As said earlier, the ACTIVFL flag is blank for the DSO that is inactive.

 

Case 2: Lets take another example – DSO DSO_SE is active

 Hence the table has the entry with ACTIVFL = “X”

 

Similarly for other objects you can verify the following tables:

All the objects have the same conditions to be checked for inactive status. If either of the below mentioned conditions satisfy, then the object is said to be inactive

a)      When you find an entry with OBJVERS = “A”, OBJSTAT = “ACT” and ACTIVFL = “ “

b)      When you find an entry with OBJVERS = “M”, OBJSTAT = “ACT” and ACTIVFL = “ “.

c)       When you find an entry with OBJSTAT = “INA”

  Infocube                        RSDCUBE

  MPRO                            RSDCUBE (with cube_type = “M”)

  InfoObject                      RSDIOBJ

  InfoSource                     RSKSNEW

  Transformation               RSTRAN

  DataSource                     RSDS

  DTP                               RSBKDTP

1 Comment