Tag Archives: obiee

“Ready for Input” BEx Variables and MDX

When a front end tool wants to set values for “Ready for Input” BEx Variable via an MDX query, it will use the SAP specific MDX statement: “SAP VARIABLES”.

Here’s the syntax for the SAP VARIABLES clause:

SAP VARIABLES <sap_variables> INCLUDING|EXCLUDING <unique_member_name>


Note: I am working on a project involving OBIEE reporting on top of SAP BW BEx Queries.  OBIEE queries are sent to BW via the MDX query language.