Monthly Archives: February 2011

Microsoft SQL Server 2008 R2 Update for Developers Training Course “Dependency Check Exception” “AuthorizationManager check failed”

Like many of us, it’s a constant struggle, er, — opportunity — for me to keep up-to-date on the latest and greatest techniques. One of the things that Microsoft and its partner ecosystem do particularly well is make plenty of … Continue reading

Posted in Business Intelligence, Microsoft | Leave a comment

Is BI ready for Cloud Computing? Is Cloud Computing ready for BI?

The discussion today at the ITA BI Roundtable was “Is BI ready for Cloud Computing?  Is Cloud Computing ready for BI?” It was a lively discussion, with participants from both BI Backgrounds and Cloud Backgrounds. We used this following materials … Continue reading

Posted in Business Intelligence, Community, Modeling/Architecture, Virtualization | Leave a comment

MDX Query to show number of child members in a Dimension

I was validating some assumptions about my dimensions’ data distribution and hierarchies and wrote some MDX to confirm the number of members. You could also do this by writing a SQL query against the relational table, but in this case … Continue reading

Posted in Analysis Services, Business Intelligence, MDX, SQL Server | Leave a comment