The BWCube component enables you extracting a BEX query or an InfoCube via the MDX Interface.
The MDX interface of the SAP BW system has a known restriction, if the Result contains too many cells (more than 1 million cell).
SAP officially states: "In general the MDX interface is not suitable for accessing mass data".
In this blog I will show you how to proceed in this case.
Mittwoch, 7. Dezember 2011
How to load SAP-data with Xtract Universal to Microsoft Access (and Excel)
Xtract Universal is since 2011 the newest member of the Xtract product line. Eight different SAP extraction types allow the BI architect to create an optimal, stable and fast data layer between SAP and different consumer applications.
Xtract Universal essentially consists of two components: a server component and a designer (client). The server component is responsible for the actual extraction. The consumer application communicates with the Server component, and these in turn with SAP. You use the Xtract designer for the design and configuration of the extractions.
Fore more information refer to the products page: http://www.theobald-software.com/en/products.htm
or to the help page: http://help.theobald-software.com
In this blog, I will show you how to load SAP-data with Xtract Universal to Microsoft Access.
Xtract Universal essentially consists of two components: a server component and a designer (client). The server component is responsible for the actual extraction. The consumer application communicates with the Server component, and these in turn with SAP. You use the Xtract designer for the design and configuration of the extractions.
Fore more information refer to the products page: http://www.theobald-software.com/en/products.htm
or to the help page: http://help.theobald-software.com
In this blog, I will show you how to load SAP-data with Xtract Universal to Microsoft Access.
Abonnieren
Posts (Atom)