Could not load file or assembly ‘Microsoft.AnalysisServices.AdomdClient, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or one of its dependencies. The system cannot find the file specified.

You need to install the “Feature Pack for Microsoft SQL Server 2005” which you can find here: http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en

Now, the blog I did before, I talked about creating them with Excel, and that works great for end users. But what about automating the process? What about filtering dimension members, or measure groups, etc?  Now that you can use the Panorama Gadget for Google Apps/iGoogle (http://google-pivot-tables.blogspot.com/2008/04/panorama-analytics-gadget-for-google.html) you can upload .cub files and do BI in the cloud, how cool is that!

Well, one option is purchase CubeSlice – http://www.localcubetask.com/  and use that to create your .cub files. CubeSlice works great, and is a good option if you want something with a ton of options and ease of use.

You can also create .cub’s using CREATE GLOBAL CUBE syntax in MDX, and you can also use XMLA to create a .cub. Options galore! Chris Webb blogged a few years about about using XMLA to create .cub’s here – http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!877.entry  He was using the MDX Sample App (I believe that comes with SQL 2000?)

What I was looking for was an easy way to us GLOBAL CUBE or XMLA and automate it, CubeSlice is nice, but there has to be a way to replicate (at least in a basic way) what they are doing. Thinking about XMLA – as to me it seems more powerful, that was the route I chose. I didn’t want to install the MX Sample App from SQL2K, and what Chris Webb says in his blog, and other things I read, basically the problem with using XMLA to create you .cub in SQL Server Management Studio is that you can’t specify a connection string, you have to connect to an SSAS instance. Using the MDX Sample App, you can specify a local file, and then run the XMLA and it will create the .cub file. So I just need to replicate that. 

I have also blogged about using ascmd.exe here . ascmd comes with the SSAS Samples with SQL 2005 (usually located here: C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\Administrator\ascmd) . You just need to compile it and you can use it to execute XMLA. So I decided to try that. I created an XMLA file to create my cube, and then executed it with ascmd.exe

ascmd -S c:\MyOfflineCube.cub -i c:\MyOfflineCube.xmla

In seconds, you have an offline cube. Now, in your XMLA you can have filters, etc. You could create an XMLA file that has some kind of variable, and you could create a replace task to replace that with what you wanted filtered, think maybe based on location, or employee, etc, and then kick out personal cubes for users, etc.

One thing I didn’t really get into is how to get your XMLA script. You could figure it out for yourself, but I actually just used CubeSlice for this example. You can create an offline cube with CubeSlice and actually see the XMLA code and use that. Maybe creating the XMLA script manually/yourself would be good info for another blog post :)

Ob-La-Di, Ob-La-Da.mp3 (2792 KB)

Always wanted to learn this. Few screw ups, but I just started learning this about 2 hours ago. No vocals, maybe do one with some time in the future. With the syncopated left hand and the reggae right hand, and keeping the lyrics and where are you are straight is like skipping on one foot, sending an sms message, and brushing your teeth all at the same time. Life goes on… :) Happy Fathers Day all dads out there.

Posted via email from scaleovenstove’s posterous

5 Years ago today, I started this blog. June 19th 2004. I wish I would have started earlier. I was addicted to reading them (like crack) from like 2001-2003, and finally bit the bullet and started one in 2004. First on Blogger, then moved to WordPress (wow I jacked my SEO on that one), but then a few hosting providers later, even my own server, and here I am. Media Temple is my current hosting and I have never been happier with a hosting provider.

I do need a new theme, I wish someone would help me out! I would even pay – 50 bucks? Who wants to? I did add the “ads” about a year or so ago, and surprisingly it brings in decent money, not huge $$ but enough to pay for hosting for the year for sure.

I love blogging, I love my blog too. Why? Because it’s mine. I can blog about whatever, and it’s mine. It has been with me through 7 apartments, 3 girlfriends, 5 cities, 5 computers, 4 OS’s, 1 baby, 5 jobs, and much more. It’s always there.

People say “blogging is dead” and I don’t agree. Blogging may be dead, for the lazy. I can “tweet all day” but if I have something to really say, or put out there and think through and share, the blog is the place. I see so many A-list bloggers just let their blogs die because of Twitter/FriendFeed. For Shame. Don’t you have anything share that is longer than 140 characters? Come on.

Anyways, this blog will be around for a while, looking back I just wish I would have blogged more. Make it a ritual. Share knowledge. Share with the community (does that make me a communist? oh noes!) Have fun!

Thinking back 5 years ago, I can’t even remember much of what I was doing. in St. Cloud, MN. Working for St. Cloud Wireless Holdings. Doing ASP Classic/SQL 2000. Reading blogs with RSS Bandit and other tools. Using a PPC 6601 as a phone. Driving a Chevy Silverado 1500. Had a 1 bedroom apt, bachelor pad. Was starting to play guitar again. Never thought I would be where I am right now, never. And 5 years from now, I bet I will say the same thing :)

Happy Blogging! :)

I also pump out the output from my MacBook to the MacBook and AppleTV through iTunes so I get total surround sound.

So the Apple Remote app, iPhone, iTunes DJ = ultimate geek iPhone party! Who’s game?

There are a few things I wish I could tweak though. Like with Yammer, the ability to choose a group before it hits the page. Also with the Yammer bookmarklet there is about a 50/50 chance the URL/title wont come through so you have to do it manually.

With the Gmail This one, on Safari, it opens in a tab instead of a popup, and loading Gmail is kind of slow (IMHO) when you want to just write a mail from out of no where.

What bookmarklets do you use? Are you a share-a-holic?

What is funny though, is that using VMWare Fusion, I have reformatted or redone my Windows VM’s multiple times because of issues. Is that just how things are? I think so.

This is probably the longest time EVER that I have had a machine without reformatting it. I think back when I was eleven years old, like 1991, reformatting our 386 25Mhz Packard Bell every 6 or so months with Windows 3.11

I have to say, the MacBook Pro is an awesome machine. Every time I use it, I wish I could just run a Windows VM for work on it, off a USB drive, just take it back and forth, and that is one less physical machine I would have to worry about.. someday..

What is the longest you have went without reformatting, voluntary or involuntary?

Photo Courtesy of Alistair Israel

Create a job step that is a T-SQL type, and

DECLARE @forecast VARCHAR(10)

    SELECT  @forecast = CAST("[Measures].[Forecast-Part]" AS VARCHAR(10))
        FROM
    OPENROWSET(’MSOLAP’, ‘Data Source=localhost;Initial Catalog=ComponentForecast;’,
        ‘SELECT { [Measures].[Forecast-Part] }  ON COLUMNS FROM [ComponentForecast]‘)

IF @forecast = ‘0’ OR @forecast IS NULL
RAISERROR (’Cube Data Not Loaded Correctly’, 17, 1)

Of course your MDX query in the OPENROWSET will need to be different depending on your cube. If you get more complicated, you can also just call a stored procedure and let your imagination run wild with what you can do.

* update – fixed sql code – changed from BIGINT to VARCHAR(10)

So, I finally decided to pick up a new bike, a Trek 7.2 FX, Newport Blue, 22.5 inch. It’s a Hybrid – not a road bike, not a MTB, but somewhere in between.

Some pictures are here, of the bike building process, because when you work at a bike company, you take 25 minutes of out of the day to build a bike.

http://www.flickr.com/photos/scaleovenstove/sets/72157619164047726/

So after getting my bike, I had to get some more gear. The usual, helmet, lights, pump, bag, tools, all that stuff. Most other people will get a “computer” for their bike, a little electronic device to track speed, etc. Guess what? I already had one, it is called an iPhone (what doesn’t the iPhone do.. “there’s an app for that”.. is true.)

I jumped on Amazon and looked for a good armband for the iPhone 3G, with good reviews. This is the one I ended up with

So what other parts are there to this equation? The app of course. RunKeeper Pro. (http://www.runkeeper.com) It lets you set your activity type, you start the music before you start RunKeeper, lock the GPS on, and start your activity. You can “lock” the screen so you dont bump it, and then tap it to get pace/speed info. It will also tell you every 5 minutes and/or every mile what your speed/pace is. Once you are done with your activity, you upload it to their site. It maps it out, elevation, speed, nice google map interface. Aggregates miles over weeks/months, and lets you share with your friends.

Here was a ride I did the other day, http://www.runkeeper.com/ui/activities/1000402

RunKeeper really keeps you motivated. I haven’t used Nike+, but I am guessing it is pretty similar. But Nike+ doesn’t work on the iPhone, just iPod Touch.

I really like my bike, there was a Gary Fisher I had my eye on though, so maybe that will be my next bike. Using my iPhone and RunKeeper, I can keep track of my rides, miles, and share with my friends (which kind of helps you stay motivated too). Fun Stuff – Go By BIke!

As you can see, I wrote this post using nothing but the tablet, pretty sweet!