Manipulating grids – Pivot and page-by
A little time ago someone posted a question on a MicroStrategy forum; it was something along the lines of: "Do you think that Excel is the ultimate BI analysis tool?".
The topic did not get a lot of attention, but the question was really legitimate and caught my eye. No matter how fast, interactive, user-friendly, eye-candy, and flash-powered your report is, there will always be a manager asking you to e-mail it in an Excel sheet. We cannot win this battle, I have assumed this, and resigned to the workbook vision of the world.
But, what does a user do with a report when he/she finally gets to squeeze it into a spreadsheet?
Nine times out of ten: a Pivot table!
Getting ready
In this recipe, we will learn how we ...
Get Business Intelligence with MicroStrategy Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
