Friday, July 15, 2011

Dimensions not allowing drill down in PerformancePoint OLAP Grid

This is just a quick note that I want to make before I forget it. I recently ran across an incident that I hadn't before and I just wanted to mention it in case it might help someone. The incident was that my dimensions in my OLAP grids were not providing me with the drill down little plus signs that you would normally see next to them. This grid was for a cash flow developed for a business, and since a cash flow is a calculation involving values from the Balance Sheet and Income Statement the Cash Flow SSAS cube included a lot of calculated values.

What happened was that these calculated values were not properly defined for every level of the hierarchy so Analysis Services did not know how to roll these values up to their parent level. I revised all the calculations and the dimensions worked fine.


No comments:

Post a Comment