Results 1 to 13 of 13
  1. #1
    Join Date
    Jan 2004
    Posts
    7

    Unanswered: 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.

  2. #2
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    I think you need analysis services, which come with enterprise edition of SQL Server
    Regards
    Dbabren

  3. #3
    Join Date
    Jan 2004
    Posts
    7

    Post

    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

  4. #4
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    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.
    Regards
    Dbabren

  5. #5
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    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
    Regards
    Dbabren

  6. #6
    Join Date
    Jan 2004
    Posts
    7
    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?

  7. #7
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    type in "pivot table" in the keyword searh bit.
    Regards
    Dbabren

  8. #8
    Join Date
    Jan 2004
    Posts
    7
    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...

  9. #9
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    if that does the job for you mate, then the answer is yes. Its a standard feature of SQL Server I believe.
    Regards
    Dbabren

  10. #10
    Join Date
    Jan 2004
    Posts
    7

    Cool

    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!

  11. #11
    Join Date
    Jan 2004
    Posts
    7

    Unhappy

    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 DLL´s isn´t it?
    And what DLL´s?

  12. #12
    Join Date
    Jan 2004
    Posts
    7
    I find it "PivotTable Service, DLLs" BOL

  13. #13
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    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?
    Regards
    Dbabren

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •