Using a Cube to store Histogram information?
- From: "R Avery" <robert.avery@xxxxxxxxx>
- Date: 31 Mar 2005 10:10:33 -0800
I am running regressions off of SQL server using VBA for calculation.
In addition to this, I would like to be able to create histograms with
that bucket all the variables. It should be able to create
cross-distributions for 1, 2, or 3 variables, and do so with a simple
..AddRow() method or something like that.
Since there are lots of variables in the regression, I do not want to
create a huge array with a dimension for each variable. I expect most
cross-buckets (sub-cubes) to be empty, so I think that a SparseCube
object could do the trick, if such a thing were to exist.
Also, I am calculating directly off a SQL statement that returns
millions of rows, so whatever solution I take must be able to handle
that and not slow down the regression calculation too much.
If there is an entirely different way to bucket and store the data such
that I can easily aggregate over variables to get a 1, 2, or 3
dimensional grid of data that an Excel histogram can easily display,
however, I would be open to it. Of the class of things that work,
whatever is fastest to obtain or build...
Any help would be appreciated.
.
- Follow-Ups:
- Re: Using a Cube to store Histogram information?
- From: Michael R Middleton
- Re: Using a Cube to store Histogram information?
- Prev by Date: Re: Is this possible...Filter list after user selects location
- Next by Date: Copying Formats vs Formatting Programatically
- Previous by thread: Changing Cell Font and Color Issue,
- Next by thread: Re: Using a Cube to store Histogram information?
- Index(es):
Relevant Pages
|
