Page tree
Skip to end of metadata
Go to start of metadata

'Classic' BW Query based on CDS Cube with Parameter 

In the following we discuss the possibility to create a BW query on top a CDS cube(see CDS views: HowTo use in BW contexts ) which uses a parameter. 

CDS Cube

Adhoc Query in RSRT

When we run the so called adhoc query in RSRT, a corresponding generated variable popup appears which has to be filled in.

In transaction RSRTS_ODP_DIS we can check the details of the transient CDS Provider, e.g. there we can find the technical name of the parameter on the BW Provider level:

BW Modeling Tool

When you want to define a BW query on such a CDS Cube, you need to activate the function'Search for TransientProvider' in order to be able to search for CDS Providers:

The parameter can only be used to define fixed filters, otherwise you get the following error(BRAIN 409):

We define a BW variable based on the parameter and use it in the Fixed Values section:

When we run the query in RSRT, the variable popup appears which has to be filled with a value.

In case query isn't restricted regarding the CDS parameter it terminates(BRAIN 470):

  • No labels