Discovering your MetaData

Saturday, December 29, 2007

I have recently discovered a brand tool to help me better understand my work. It's a free tool from the Microsoft SDK. Specifically, I'm talking about the Rowset Viewer. The Rowset Viewer was intended for you to "view and manipulate OLE DB rowsets, with the added ability to call and manipulate other OLE DB methods from the data source, session, command, rowset, transaction, and notification objects supported by any OLE DB provider." I found myself using the tool so as to understand what was problematic in my cube. Basically,...

Recreating a Report Model

Wednesday, October 31, 2007

Remember how I taught you to recreate your Analysis Project? Well, let's say this time you have a model you deployed to the Reporting Services Server, but you have changed it since then and want the old version back. So how would you recreate the model you have on the server?  First of all, create a new Data Source View in your Analysis Project. It doesn't have to include all the relevant tables, as you'll only use it as a shell to build upon. After you've finished defining the DSV, save the project. Then, right click the new DSV...