Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    12

    Exclamation cognos powerplay on sql server

    I designed a relational database in sql server and i need to use cognos powerplay on it. The thing is that the administrator of the tool who i'm working with says that relational databases can not be used, only databases with hierarchy are usefull to desing a cube. I think that realtional database are new technology and a tool like cognos powerplay should be designed for both databases types.
    The client who i'm working for is tired of the lack of flexibility that hierarchys force, because it makes you go to lower levels all the time in things that you need to see at the same level, so that's why i designed the relational database but i can't use it yet.
    Is cognos powerplay usefull on relational databases??

    Thanks

    baccon

  2. #2
    Join Date
    Sep 2003
    Posts
    3

    Re: cognos powerplay on sql server

    Hi Baccon,

    Really, Cognos tools have been created, originally, to access databases that was build with bi statments. Why about it? Well, because the access performance is very fast than relational database, of course.
    But, isn't impossible to use, cognos tools, with relational databases. But you have to know that the access, at relational database, is very slow than other databases created specifically to bi solutions, impacting in creating and generating cube process.
    I hope help you.


    Regards,


    Originally posted by baccon
    I designed a relational database in sql server and i need to use cognos powerplay on it. The thing is that the administrator of the tool who i'm working with says that relational databases can not be used, only databases with hierarchy are usefull to desing a cube. I think that realtional database are new technology and a tool like cognos powerplay should be designed for both databases types.
    The client who i'm working for is tired of the lack of flexibility that hierarchys force, because it makes you go to lower levels all the time in things that you need to see at the same level, so that's why i designed the relational database but i can't use it yet.
    Is cognos powerplay usefull on relational databases??

    Thanks

    baccon

Posting Permissions

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