How does the MicroStrategy SAP BW connector work?
MicroStrategy 8 Intelligence Server contains a new MDX Generation Engine that accesses SAP BW using SAP’s OLAP BAPI’s. MicroStrategy automatically imports cube definitions into the MicroStrategy metadata to speed development. When users create and execute reports against the SAP BW cubes, MicroStrategy 8 dynamically generates MDX, executes it against SAP BW, and retrieves and formats the result set. All OLAP functionality such as pivoting, filtering, adding derived metrics, and drilling within cubes is available to end users.
