In the following we discuss some technical details of a transient provider(and transient query) based on an ABAP CDS View. The delivered information(under Tips&Tricks) should help you to check/analyze such providers in case they do not work as expected.
General Information to this Topic
Identify objects for transient queries/provider based on CDS views
Sample: Bex query name: 2CISDBILLGDOCITMC/2CCSDREVNFRMINVCQ
The DDL source of the query is found under Query Definition: C_REVENUEFROMINVOICEQRY.
The transient provider (TRPR) and its DDL source can found under General Data: 2CISDBILLGDOCITMC and I_BILLINGDOCUMENTITEMCUBE.
With the report RUTDDLSSHOW2 in SE38 the definition of the query and provider can be displayed quickly also in the SAP GUI:
The query CDS view itself has no transient provider, so nothing can be found in transaction RSRTS_ODP_DIS for C_REVENUEFROMINVOICEQRY.
With the SQLVIEWNAME the transient provider can be idenitifed in transaction RSRTS_ODP_DIS:
- TransientProvider 2CISDBILLGDOCITMC
- Software Component: VDM_SD_ANALYTICS,
- Model: I_BILLINGDOCUMENTITEMCUBE
- SQLviewName: ISDBILLGDOCITMC 'Billing Document Item Cube'
The connection between DDLSOURCENAME and SQLVIEWNAME can also be found in table RSODPABAPCDSVIEW
- DDLSOURCENAME: I_BILLINGDOCUMENTITEMCUBE
- SQLVIEWNAME: ISDBILLGDOCITMC
Check whether query is run in the correct client
As described in the example of CDS Access Controls, when a query based on a CDS view is executed, the system automatically adds a filter with the client the user is logged onto. It is not possible to restrict a BW query based on a client dependent CDS View, on another client that the one the user is logged onto.
Check the restrictions derived by authorizations assigned to the user
If the authorization check is active for a CDS view (@AccessControl.authorizationCheck: #CHECK), the authorized values are added to the WHERE clause of the SQL statement. This can lead to unexpected query results, see CDS Access Controls for further details on how to check such queries.
Using TransientProviders based on CDS Views in Query Designer
TransientProviders based on CDS Views using the data category annotation #CUBE (@Analytics.dataCategory: #CUBE) can be opened using either the BEX Query Designer or the Modeling Tools Query Designer. This Wiki page explains where the technical names and descriptions shown in Query Designer come from and how it is possible to control this behavior.
Important SAP Notes and KBAs
|2274570||Performing the "DCL Initial Load"|