richardvanderknaap
New Member
- Joined
- Jul 2, 2008
- Messages
- 2
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o>Our application is based on MS SQL</o>
<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> </o>
Is this the correct way of doing this? Are there better ways of doing this? Is it robust? Can we automatically refresh the pivot table<o></o>
<o> </o>
<o></o>
richard
<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> </o>
Is this the correct way of doing this? Are there better ways of doing this? Is it robust? Can we automatically refresh the pivot table<o></o>
<o> </o>
<o></o>
richard