-
Archives
- February 2018
- December 2017
- February 2013
- January 2013
- December 2012
- March 2012
- August 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- November 2010
- October 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- August 2009
- July 2009
- May 2009
-
Meta
Category Archives: OLAP
I am positive that measure is not negative – Weird Analysis Services Cube Behavior
I ran into a situation recently that had me stumped for a bit, and there didn’t seem to be any other posts about this when I searched. I was working with a cube containing a very straightforward measure. This was … Continue reading
Posted in Analysis Services, Business Intelligence, MDX, OLAP, SQL Server
Leave a comment
Solution to “Very strange results from MDX Query”
The solution to “Very strange results from MDX Query” It turns out that there was both a psychological component and a technical one. The sleuth who help me discover these issues was none other than my friend, former and occasionally … Continue reading
Posted in Analysis Services, Business Intelligence, MDX, OLAP
Leave a comment
Strange results from MDX Query
I am currently working on adding forecasting capabilities to an existing customer cube. The MDX to do this is based on calculations in an existing spreadsheet model. The spreadsheet works very well in terms of modeling the business accurately, but … Continue reading
Posted in Analysis Services, MDX, OLAP
1 Comment
Time (Not Date) Dimension Table SQL code
I am seeing more call for Time Dimensions. By that I mean Time-of-Day Dimensions. So now I have to retrain myself to call Date Dimensions “Date” and Time Dimensions “Time”.As a follow up to this post, here’s some DDL and … Continue reading
Posted in Modeling/Architecture, OLAP
Leave a comment
Brilliantly stupid MDX debugging technique
Whenever I do something really stupid, rather than keep it to myself, I prefer to blog about it for the entire world to see. Even better – I came up with a debugging technique to save myself from my own, … Continue reading
Posted in Analysis Services, MDX, OLAP, SQL Server
Leave a comment
Do as I say, not as I do
Perhaps that should be – Do as I say, not as Adventure Works and Project Real do SSAS modeling question: What’s the best approach to handling header/detail records? Approach #1) Use Measure Groups Approach #2) Consolidate via either ETL or … Continue reading