needful parts of MSSQL to create local cube

hi,
I'm creating local cube with Delphi. On my server with MSSQL it work well, but i need to know, which parts of MSSQL is needful to create this local cube (on the server) if i will creat and instal new server with MS SQL.
Thanks for reply.I think you need analysis services, which come with enterprise edition of SQL Server|||Originally posted by dbabren
I think you need analysis services, which come with enterprise edition of SQL Server
I have instaled AS and it works, but then I uninstall AS and it allredy works too.
I don't know whitch libraries wasn't uninstall.
Somewhere i read something about pivot table?? what is it and how to install...
thanks|||I've only ever seen pivot tables used in excel, but there may be other instances of it I'm not aware of.

Haven't actually ever set one up, but I can't imagine they are that complex to do.|||its in SQL Server as well!! - just looked it up in BOL - have a read of that - no need to install as its a feature|||Originally posted by dbabren
its in SQL Server as well!! - just looked it up in BOL - have a read of that - no need to install as its a feature
Thank you.
Can you tell me a title in BOL where it is writen pleas?|||type in "pivot table" in the keyword searh bit.|||Originally posted by dbabren
type in "pivot table" in the keyword searh bit.
If I understand it well, only install MS SQL without AS will work OK...|||if that does the job for you mate, then the answer is yes. Its a standard feature of SQL Server I believe.|||Originally posted by dbabren
if that does the job for you mate, then the answer is yes. Its a standard feature of SQL Server I believe.
Special thanks to you!|||Originally posted by dbabren
if that does the job for you mate, then the answer is yes. Its a standard feature of SQL Server I believe.
But i have once more problem...
If SQL server is on different station than application server, and application server obtain query to SQL I need some DLLs isnt it?
And what DLLs?|||I find it "PivotTable Service, DLLs" BOL|||Unfortunately, I don't know any more than it states in BOL on this topic, although from a brief reading of the article it appears that you need to install some dll files on you app server - perhaps there is someone in this forum who has made use of this pivot table service?