WideSheet - Adding multiple dimensions

Posted by Pelle Fri, 25 Nov 2005 14:16:15 GMT

So I’ve gotten most of the multi dimensional support completed. I only really need to create a user interface for moving dimensions around within the same axis or to another dimension.

The following screencast demos it a bit. Click on the screen shot below to view it:

So what is actually happening here is that I am creating a spreadsheet for revenue for various sites of mine (The revenue figures in the screencast bear no resemblance to actual revenue).

  1. For the first part it is a normal 2 dimensional spreadsheet. I enter revenue per site per quarter
  2. I then add another dimension to it (Year)
  3. I Enter some data for the next year
  4. I add a further dimension, but this time to the Y axis. I call it revenue type.
  5. I add further data for the new revenue type
  6. I Create a new view to demonstrate another view of the same data
  7. I Pivot it, which basically flips the x and y axises.

My next demo will demonstrate the gui for moving dimensions around. The data model already supports it, but I’m working on as simple a gui as possible to do so. With this you should be able to change the order of dimensions, so you for example see the product dimension before the revenue type dimension. You could also move revenue type to the x axis instead.

Share your confidential code safely with a Source Code Confidentiality Agreement on our free web service Agree2

Trackbacks

Use the following link to trackback from your own site:
http://stakeventures.com/articles/trackback/106

Comments

Leave a response

Comments

(sorry javascript required)