Query Builder vs. Oracle/SQL Server views

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Phil Simon
Veteran Member
Posts: 135
Veteran Member
    Hello

    I was wondering if anyone cared to share his/her thoughts on using Query Builder vs. Views. I know that QB has the built-in Lawson security but am wondering if reporting performance will suffer as more than a handful of tables are added for Crystal Reports (deployed via LBI). In some cases, the way that the data is stored in different tables (PRSAGDTL, for example) isn't ideal for the way that 'normal' end-users look at it. Using SQL server to create a view in the dB wouldn't by utilize Lawson security, but if the end-users wouldn't be restricted to any records, wouldn't the performance improvement justify the tradeoff? Also, I believe that you can lock down that view to individual users anyway if that was a major issue.

    Thanks.

    ps
    Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
    k-rock
    Veteran Member
    Posts: 142
    Veteran Member
      Have you tried reporting with the cubes built by IA? They use security and are a view stored on a SQL server.
      Phil Simon
      Veteran Member
      Posts: 135
      Veteran Member
        No, I haven't monkeyed around with that one yet. So many reporting options.

        Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com