OWC 11 Pivot Table

[Douglas Osborne]

So reading through a few posts here, it seems as though to use SQL as a
source you have to only connect to an OLAP cube - but then you can connect
to Access? That doesn't seem quite right.

So - can I connect to my own data in SQL - or does everything have to
migrate over to Analysis Services?

Either way - does anyone have an end to end example in C# connecting to SQL
2000?

Alvin - I got your book yesterday and sent you an email for the source
code - are you looking to update your book to OWC11?

Seems promising,
Doug

 

[Alvin Bruney]

The book is written for owc10 and 11. The pivot table can connect to cubes
not databases which is why you need analysis services. If you need to
connect to a database, you first need to pull the data out of the database
and convert it to a cube using one of the analysis service wizards. From
there, it's a straight port.

Alvin - I got your book yesterday and sent you an email for the source
code - are you looking to update your book to OWC11?

Sent the source, but it came back with a transmission error yesterday.
Perhaps another email address?

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

 

[Jeff Moore]

Also Cubes will give you significant performance advantages over relational
tables as the data is pre-aggrigated and pre-loaded into memory.

Jeff

The book is written for owc10 and 11. The pivot table can connect to cubes
not databases which is why you need analysis services. If you need to
connect to a database, you first need to pull the data out of the database
and convert it to a cube using one of the analysis service wizards. From
there, it's a straight port.

Alvin - I got your book yesterday and sent you an email for the source
code - are you looking to update your book to OWC11?

Sent the source, but it came back with a transmission error yesterday.
Perhaps another email address?

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

So reading through a few posts here, it seems as though to use SQL as a
source you have to only connect to an OLAP cube - but then you can connect
to Access? That doesn't seem quite right.

So - can I connect to my own data in SQL - or does everything have to
migrate over to Analysis Services?

Either way - does anyone have an end to end example in C# connecting to
SQL 2000?

Alvin - I got your book yesterday and sent you an email for the source
code - are you looking to update your book to OWC11?

Seems promising,
Doug

 

[Douglas Osborne]

Jeff,

So do you have any code for doing this in c#?

I keep seeing people say 'look in the messages' - but there is no code to be
found.

How about and end to end example?

Doug

Also Cubes will give you significant performance advantages over
relational
tables as the data is pre-aggrigated and pre-loaded into memory.

Jeff

The book is written for owc10 and 11. The pivot table can connect to
cubes
not databases which is why you need analysis services. If you need to
connect to a database, you first need to pull the data out of the
database
and convert it to a cube using one of the analysis service wizards. From
there, it's a straight port.

Alvin - I got your book yesterday and sent you an email for the source
code - are you looking to update your book to OWC11?

Sent the source, but it came back with a transmission error yesterday.
Perhaps another email address?

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

So reading through a few posts here, it seems as though to use SQL as a
source you have to only connect to an OLAP cube - but then you can
connect
to Access? That doesn't seem quite right.

So - can I connect to my own data in SQL - or does everything have to
migrate over to Analysis Services?

Either way - does anyone have an end to end example in C# connecting to
SQL 2000?

Alvin - I got your book yesterday and sent you an email for the source
code - are you looking to update your book to OWC11?

Seems promising,
Doug