Crazy error today. In Analysis Services, (SSAS), some jobs got hung, sync command got hung, and what ended up happening is a cube on the default instance was totally unusable. Try to delete, rename, resync, redeploy, anything, and I would get the error.. Errors in the metadata manager. The dimension with ID of.. Couldn’t do…
About Steve
Welcome to stevienova.com. Since 2004, I have enjoyed blogging about programming, business intelligence, SharePoint, Microsoft, Google, Apple and everything to do with technology. Thoughts on life, the world or my new favorite brew, may also be shared. I currently work at Trek Bicycle Corporation, managing both the BI team and .NET software dev groups. The opinions on this blog are solely my own.
I live in Sun Prairie, WI with my girlfriend and our 2 year old daughter. Besides my love for family and technology, I am passionate about music. I play the piano, guitar and I also sing. Everyday I learn something new, and I hope to share it with you.Sponsors
Category Archives: SQLServerPedia Syndication
SSIS – Custom Control Flow Component – Execute SQL Job And Wait
Sometimes you have some pretty complex ETL’s going in SSIS, and you might have multiple projects/solutions that need to call other SSIS Packages or SQL Agent Jobs and you have a pretty big production going on. You might have an ETL solution that needs to kick off other packages, and you can either import those…
SQL 2005: SSIS – Pushing Data to MySQL using Script Component Destination
Sometimes, I just wonder why things that are useful in previous versions of things get removed. In SQL 2000, in DTS, there was an ODBC destination, you could write (insert, update, etc) to a foreign (non MSFT SQL) system easily. DB2 – no prob, MySQL – heck yea. For whatever reason, in SQL 2005 Integration…
Office 2010: Excel 2010, What-If Analysis aka Microsoft Finally has Built in Cube/OLAP Writeback!
Digging into the blog post from earlier this summer I wanted to see what was new and exciting in Excel 2010. Recently I have been working on an cube and we want to be able to budget right from the cube. There are also many other cubes/scenarios where the ability to writeback to the cube…
SSASMeta – C# App to Log Info About SSAS Objects
I manage some servers that have many cubes. OK, a lot of cubes (60+ on one). I needed some way to output a report of last processed time, last schema update, etc. Now, there are about 5 different ways to do this (one being the SSAS Stored Procedure Project), but this is what I came…
Office 2010: Excel 2010 – New Buttons on Ribbon for Pivot Tables – Custom Named Sets!
Just this week I blogged about adding Named Sets in VBA. Well lo and behold, in Excel 2010, there is a button “Fields, Items, & Sets” that lets you define your own Named Sets. Either with MDX or based on rows/columns you have on your pivot table Works pretty slick! There goes the need for…
T-SQL: Using CROSS APPLY to Turn 2 Queries Into 1
Parent/Child. Order/Line. Header/Detail. Report/Sub-Report. We have all ran across these database designs and have had to write queries off of them. You usually end up having the parent id, and you need to get the children. Or you have a list of parents and need to loop through them, looking up the children records and…
SSAS 2005/2008: Creating Sub-Cubes Using XMLA, Variables, and Named Query Where Statements
I blogged a few weeks ago about creating Local Cubes with XMLA and ascmd.exe, and that is pretty cool, works great. There are some snags though if you use a server that is 64 bit. You can’t connect to the local cubes via .NET, Excel, or any other way. There are no drivers for local…
Using CTE’s to Create Dynamic Pivot Tables in SQL 2005/2008
One of the cool new commands introduced in SQL 2005 was the PIVOT command (and UNPIVOT). One thing that has always irked me about PIVOT was that you need to “hard code” the column names you want to actually pivot on. This is usually fine for a static report, say you want to pivot on…
Excel 2007, OLAP Cubes: Customizable, User Defined Named Sets in Excel 2007 using VBA
In a perfect world, your master data and master data management (MDM) is set up so everyone can see things how they want. Categories of Items, Regions, etc, etc are all defined in your dimension data, and you can create hierarchies, etc that make sense and everyone is happy. But, this is not a perfect…