Categories
Archives
- February 2014 (6)
- January 2014 (1)
- November 2013 (1)
- October 2013 (3)
- September 2013 (3)
- August 2013 (1)
- July 2013 (5)
- June 2013 (2)
- May 2013 (3)
- April 2013 (3)
- March 2013 (4)
- February 2013 (2)
- December 2012 (1)
- November 2012 (4)
- October 2012 (1)
- August 2012 (1)
- July 2012 (1)
- June 2012 (2)
- May 2012 (7)
- April 2012 (3)
- March 2012 (1)
- February 2012 (1)
- January 2012 (2)
- December 2011 (2)
- November 2011 (1)
- September 2011 (4)
- August 2011 (4)
- June 2011 (2)
- May 2011 (3)
- April 2011 (2)
- March 2011 (4)
- February 2011 (2)
- January 2011 (5)
- October 2010 (2)
- September 2010 (1)
- August 2010 (1)
- May 2010 (2)
- January 2010 (1)
- December 2009 (1)
- October 2009 (2)
- September 2009 (1)
- April 2009 (2)
- January 2009 (1)
- December 2008 (1)
- November 2008 (2)
- August 2008 (1)
- July 2008 (4)
- March 2008 (1)
- February 2008 (1)
- January 2008 (4)
- December 2007 (5)
- November 2007 (5)
- October 2007 (13)
- April 2007 (1)
- March 2007 (1)
- February 2007 (3)
- January 2007 (13)
- December 2006 (7)
- November 2006 (2)
- October 2006 (7)
- September 2006 (5)
- August 2006 (4)
Recent Comments
- Jens Vestergaard on Teradata based Data Source Views in Analysis Services
- Sudipta on Teradata based Data Source Views in Analysis Services
- Jens Vestergaard on Subtle differences in Teradata and SQL Server
- Rasmus Reinholdt on Subtle differences in Teradata and SQL Server
- Kenneth M. Nielsen (@DoktorKermit) on Never loose your server list in SSMS again…
Tags
.Net 3rd. ed. AMO Analysis Services BI Business Intelligence Bønner C# Certificering Coffee D&D Espresso FAIL Fejl Humor Kværn MCP MDX MSConnect NFL Personal politik Roleplay Security SQL SQL2008 SQL2012 SQLBits SQLBits X SQLPASS SQLServer SQL Server SQL Server 2005 SQL Server 2008 SQLTip SSAS SSIS SSIS 2008 SSMS SSRS T-SQL Teradata vandkøling VS2008 VS2010LinkedIn
If you want to see my LinkedIn profile, click on this button:
Subscription Options:
My Klout Score
Tag Archives: SSAS
Teradata based Data Source Views in Analysis Services
Now here’s a catch. I was trying all night long to figure out why Visual Studio was hanging on me, every time I wanted to add a Teradata based relational data source. Turns out that the list of available objects … Continue reading
Using Powershell to view Partition Slice Information in Excel
Challenge In a blog post written by Chris Webb (b|t), years ago, Chris displays how to query the ASSP.DiscoverPartitionSlices(…). I stumbled upon the post while investigating solutions to problems with partition slicing. But since there were about 20 cubes, each containing … Continue reading
Using Powershell to create Local Users from AW Customers
As a part of my upcomming presentation at SqlSaturday Cambridge, I will probably be needing a lot of users to demo some aspects of security in Analysis Services. Therefore I have created a Powershell script, my first actually, to generate … Continue reading
Same members declared in both Sub Select and Where clause of same MDX
What to make of it? Currently I am conducting a review on all existing solutions. These solutions have seen their share of developers over the years. Hence there are several “trademarks” to be found. One such trademark threw me off a bit. … Continue reading
“Quick” Dimension Attribute Settings Report
This week I needed to check up on the design of several cubes, in several environments. As I somehow failed to install the SQL Server 2012 Best Practice Analyzer (BPA) properly, I wasn’t able to use that tool. So I build a … Continue reading