MS SQL Server OLAP - Building a Cube from a VB .NET dataset / datatable

Author

Building a Cube from a VB .NET dataset / datatable

Michael

2005-04-21, 3:24 am

Hi,

I'm trying to reformat data from a normalised SQL relational database,
so that it can be analysed. I have extracted it and stored it in a
datatable in a VB .NET application, and I've managed to export that
table as a .csv or an .xml file, but now I need to build an off-line
cube file from the same data.

I understand that the datasource for a cube is usually a dataview
stored on a server, but I'm wondering if it's possible to build an
off-line cube directly from the datatable in vb .net. The data table
at the moment has a bunch of fields (with various different data
types), and each field ultimately needs to be a dimension of the final
cube.

I'm very new at working with cubes, so any suggestions or advice would
be really appreciated.

Thanks!

Michael

Randy Birch

2005-04-24, 11:23 am

Since the majority of the groups you posted to are really for VB6 and
earlier, you might want to look into the ms groups devoted exclusively to
..net programming on the microsoft news server, named such as:

news://msnews.microsoft.com/microso....dotnet.general
news://msnews.microsoft.com/microso...et.languages.vb
news://msnews.microsoft.com/microso...c.vsnet.general
....etc.

--

Randy Birch
MS MVP Visual Basic
http://vbnet.mvps.org/
----------------------------------------------------------------------------
Read. Decide. Sign the petition to Microsoft.
http://classicvb.org/petition/
----------------------------------------------------------------------------

"Michael" <mikespoff@gmail.com> wrote in message
news:9d743ead.0504202345.5a11c0ee@posting.google.com...
: Hi,
:
: I'm trying to reformat data from a normalised SQL relational database,
: so that it can be analysed. I have extracted it and stored it in a
: datatable in a VB .NET application, and I've managed to export that
: table as a .csv or an .xml file, but now I need to build an off-line
: cube file from the same data.
:
: I understand that the datasource for a cube is usually a dataview
: stored on a server, but I'm wondering if it's possible to build an
: off-line cube directly from the datatable in vb .net. The data table
: at the moment has a bunch of fields (with various different data
: types), and each field ultimately needs to be a dimension of the final
: cube.
:
: I'm very new at working with cubes, so any suggestions or advice would
: be really appreciated.
:
: Thanks!
:
: Michael

Sponsored Links