- PGMID (Program ID) = “R3TR” and
- OBJECT (Object Type) = “ELEM”:
So far – so good.
Now, what are types of objects we create in Query Designer? Queries, obviously! But not only. If you think you remember that you can create as well Calculated Key Figures (CKF) and Restricted Key Figure (RKF) in the left pane of Query Designer. Going further, you can create Variables from Query Designer. And last, but not least, Structures once created in the right pane, can be saved as reusable, and appear in the left pane of your Query Designer.
All of them are called Re-usable elements or Components, as they are not query-specific, but rather linked to a cube (Query, CKF, RKF, Structure) or characteristic (Variable).
Based on the information above we know now what NOT query elements are:
- BEx Workbooks,
- Query Views (you do not create it using Query Designer!),
What is practical implication of everything that I wrote so far? It is that details of Components are stored in system table RSZCOMPDIR “Directory of reporting components”. Values in RSZCOMPDIR-COMPUID field are same as in TADIR-OBJ_NAME (“Object Name”). So if I select from RSZCOMPDIR my OBJ_NAME values from the transport, I’ll get some more meaningful data now:
It is just why I got only 3 records, if there were more then 100 object id’s that I copied from transport? Because this table shows you only Components, other words Re-usable elements.
We will discuss Non-Re-usable elements in the next part of this Weblog series.