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>

Referenceshttp://lbsackett.typepad.com/larry_sackett/2008/07/mdx-for-netweaver-bi-variables.html

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.