September 29, 2008

v0.1 of my Visit/PageView Analysis Services Cube

So I created a cube using my the visit/pageview that I recently started collecting.  The cube is VERY simple - only 4 dimensions {App, Page, Source, Time} and just a single measure - {Hit}.  I created the cube using the 2005 versions of Visual Studio and Microsoft's Analysis Services.  The IDE's wizards pretty much walk you through the process, which is great because creating an Analysis Services project from scratch is more than a little intimidating.  Especially if your a web developer like me and you don't know a whole lot about querying, let alone designing a cube. Anyway, like I said, my cube is very simple.  The App dimension only contains 2 members: 'mattberseth' for this site, and 'mattberseth2' for my live demo site.  The Page dimension contains all of the unique URLs for both sites as its members, the Source dimension is essentially a bit field for determining...

Topics: Other

September 25, 2008

Maintaining my own Pageview/Visit Database

I have started maintaining my own pageview/visit database for both mattberseth.com (this blog) and mattberseth2.com (my demo site).   Why? I currently use Google Analytics (GA) and I really like it.  But ... You can't (yet) export your raw visit data from GA You can't (yet) browse your GA cube I have other data in my MoveableType database (post dates, categories, commentors, tracebacks, etc...) that GA just doesn't know about.  This information would be interesting to get into the cube.   What have I done so far? Added a small bit of JavaScript to the pages I want to track on on both mattberseth.com and mattberseth2.com.  The script extracts the pages referrer and a few other tokens and sends them a HttpHandler that I have setup on mattberseth2.com (hosted by DiscountASP).  Here is a sample of what is the request/response looks like. The handler extracts the tokens and any http...

Topics: Other

September 21, 2008

Dynamic Data Demos Now Available

Last week DiscountASP upgraded to .Net 3.5 SP1 - so I took sometime this weekend to publish demo's for my 5 Dynamic Data posts.  Here is a quick summary of what is out there ...    ASP.NET Dynamic Data - Simple 5 Table Northwind Example Very simple DD site based on the 5 core Northwind tables.  Read more ... Download | Live Demo   Dynamic Data and Custom Metadata Providers DD enabled controls take rendering hints from the metadata you apply to your data model.  This post shows how you can create a custom metadata provider that will provide sensible default values for the DisplayName and DisplayFormat attributes.  Read more ... Download | Live Demo   A Dynamic Menu For Your Dynamic Data This post continues the custom metadata theme and shows how you can use the existing Category attribute to create a 2 level navigation bar.  Read more ......

Topics: ASP.NET , Dynamic Data

September 15, 2008

Dynamic Data - Experimenting with YUI's DataTable and DataSource Controls

I spent a few hours putting together a Dynamic Data web site using the YUI DataTable and DataSource components.  I mostly just did this out of curiosity to see how easy or difficult it would be to use the DD API with other components besides the GridView and DetailsView controls.  So I created a DD web site that provides read-only access to Northwind's Customer, Employee and Supplier tables, but I am not using ASP.NET's GridView, DataSource and UpdatePanel controls to render the grid.  Instead I have replaced these components with YUI's client side DataTable and DataSource and serve the data using a web service (paging included!).  Below are a few of the highlights, and don't forget to download the sample and try it out for yourself.  Its experimental, but if you are new to DD or YUI you might find it interesting.  [Update: 9/21/2008]: Added live demo link  Download |...

Topics: ASP.NET , Dynamic Data

September 07, 2008

Dynamic Data - Customizing the Delete Confirmation Dialog

I spent some time customizing the delete confirmation dialog in the Dynamic Data site I have been blogging about recently.  Specifically, I looked at ... replacing the browsers default confirm dialog with a jquery thickbox displaying a confirmation message that includes contextual information regarding the row being deleted Below is a screen shot showing how it turned out.  You can read on for the details, or you can download the site and browse the code for yourself.  Hopefully DiscountASP will get upgraded to .Net 3.5 SP1 soon so I can get back to providing demos as well ... [Update: 9/21/2008]: Added live demo link   Download | Live Demo   The Default Confirmation Dialog If you use the Dynamic Data Web Site template to create your DD web site, the List.aspx page template will already include a default delete confirmation dialog that uses the browsers confirm dialog to prompt the user...


Consulting Services

Yep - I also offer consulting services. And heck, I'll do just about anything. If you enjoy my blog just drop me an email describing the work you need done.

Recent Comments

  • TimothyP wrote: I work with tons of developers who haven't even got a clue what Twitter of Facebook is. In fact, it'...
  • Janko wrote: Yes it's strange that people think it's ok to blog at work but consider unethical to use facebook. P...
  • Kam Lagan wrote: Hi Matt, The numbers do seem a little "off" to what you perceived the community would be like. But...
  • Siderite wrote: You're kidding me! So the people that don't blog think it is ok to blog at work (maybe because they ...
  • Guy Harwood wrote: Good to see the results. one typo.... 'What best describes your current job title?' appears twice,...
  • sirrocco wrote: One problem with : DEV I DEV II DEV III was that I didn't know what it meant :( .(is it common ...
  • Jack wrote: How many person fill the survery? Blog is very common, so I don't think 71.5% is high. Maybe our bos...
  • Andy wrote: Done. The developer1, developer2 question - not sure how meaningful the results are going to be for ...