Chapter 8. Data Integration

In this chapter, we will cover the following topics:

• Using report script to extract data to a text file

• Using the DATAEXPORT function to extract data into a text file

• Using the DATAEXPORT function to extract data into a relational source

• Exporting data using column format

• Using MaxL to extract the outline in XML format

• Using @XREF functions to move data between BSO cubes

• Partitioning data from BSO to ASO cubes

• Using MDX for extracting data using API