Our application is based on MS SQL We are now thinking to add “Business intelligence” cubes to our application We have created the necessary views in our SQL database which can be up to a million records We have successfully pivoted against the views by using the "external data source" option in the pivot table wizard All seems to work OK Questions Are there better ways of doing this? Is it robust? Can we automatically refresh the pivot table

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

SQL and pivot tables

Thread starter richardvanderknaap
Start date Jul 3, 2008
Tags

pivotchart sql

richardvanderknaap

New Member

Jul 3, 2008

Our application is based on MS SQL
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
We are now thinking to add “Business intelligence” cubes to our application<o

></o

>
<o

></o

>
We have created the necessary views in our SQL database which can be up to a million records<o

></o

>
<o

></o

>
We have successfully pivoted against the views by using the "external data source" option in the pivot table wizard

All seems to work OK
<o

></o

>
Questions<o

></o

>
<o