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 Send Private Message
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 Send Private Message
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 Send Private Message
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