| Steve's profileSteve's spacePhotosBlogLists |  Tools  Help |
Steve's space |
|||||
|
June 25 ADOMD.NET: Could not load file or assembly Microsoft.AnalysisServices.AdomdClientOriginal URL: http://blog.stevienova.com/2009/06/25/adomd-net-could-not-load-file-or-assembly-microsoft-analysisservices-adomdclient/ If you are developing a .NET/ASP.net solution using ADOMD.NET locally, and everything works great, and you go to release to a production server and end up with this error:
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 Microsoft BI: Creating Local OLAP Cubes using XMLA and ascmd.exeOriginal URL: http://blog.stevienova.com/2009/06/25/microsoft-bi-creating-local-olap-cubes-using-xmla-and-ascmd-exe/ Most people, when using OLAP cubes, are hitting the live version that is located on SQL Server Analysis Services (SSAS). They hit it with Excel, or some other reporting tool, etc. I have blogged previously about offline cubes and how you could possibly use them. 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 :) June 21 Ob-La-Di, Ob-La-Da, Playing around on the Piano This Morning..Original URL: http://blog.stevienova.com/2009/06/21/ob-la-di-ob-la-da-playing-around-on-the-piano-this-morning/  Ob – La – Di, Ob – La – Da by Steve Novoselac
Download now or listen on posterous 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. June 19 5 Years Ago Today...Original URL: http://blog.stevienova.com/2009/06/19/5-years-ago-today/ Wow, two “X years Ago Today” this week.. 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! :) iTunes DJ - iPhone, Remote App - Party!Not sure when this came about, but I just realized that there is an “iTunes DJ” in iTunes now. It obviously lets you just play a random selection it picks. But what I didn’t know, is allowing anyone on your wifi network to connect with their iPhone and the Remote App. Once you connect with the Remote app, you can browse the library, and request a song. Multiple people can request a song, and vote it up. Totally awesome!!
So the Apple Remote app, iPhone, iTunes DJ = ultimate geek iPhone party! Who’s game? |
||||
Send a private message
Subscribe to RSS feed
Tell a friend
Add to My MSN
Add to your network
Sign up for alerts
|
|
