How to extract a BEx Query and a BW Hierarchy with SSIS / Xtract IS from SAP BW and build them in SSAS

In this blog I will use Xtract IS to extract a BEx query and a BW hierarchy from an SAP BW system and load them into SQL Server. Then I will show how to build a cube in SSAS upon the BEx query and the BW hierarchy.

How to load a BW Hierarchy into QlikView using Xtract QV

In this blog I will use Xtract QV to extract a BW hierarchy from an SAP BW system and load it into QlikView.

SAP BW hierarchies are modeled as parent-child hierarchies. I will show how to convert it to a naturalized Hierarchy to use in QlikView.

How to load a BW Hierarchy into PowerPivot using Xtract PPV

In this blog I will use Xtract PPV to extract a BW hierarchy and a BEx query from an SAP BW system and load them into PowerPivot. Then I will show how to build the relation between the Hierarchy and the BEx query in PowerPivot.