4
Votes

Write a parser for pivot table to access the multi-dimensional data (OLAP) from SSAS cube.  Following OLAP related features need to be considered,

1. Explore the cube properties

2. OLAP Browser for slice and dice

3. KPIs

4. Named sets

5. Paging

5. Calculated members and measures

6. Measure grouping

7. Filtering (header, excel-like filter)

 8. Sorting