Question ID:
105088
| ♥ 0 |
What is the benefit of business view and why not just use SQL?
Marked as spam
|
Posted by Answers (2)
|
Private answer
Business views were introduced to simplify the reporting process for users by removing the need for an in depth knowledge of underlying database. Project Admins define BVs using DQL. Report Designer - Create Reports/Graphs based on the business view instead of the more complex full database schema. Marked as spam
 Posted by sammyh (Questions: 0, Answers: 613) Answered on July 31, 2013 8:38 pm
So what is the why DQL instead of SQL?
Any Limitations?
1) reports are generated according to the permission levels of the user generating them so data that is excluded from business view results does not appear in any report that the user creates.
2) DQL statements provides uniformity across different database through the ANSI SQL 92 standard. DQL removes the need to know database specific SQL syntax. For example the DQL function datediff In MS SQL, the function is coded as datediff(DAY, , ). In Oracle, the function is converted to - and is coded as trunk ( - , 0).
3) Field names are made more meaningful across entities by using consistent names. So, for example Bug Id numbers are name Defect ID across all entities.
See chapter 23 of the ALM v11.52 Administrators Guide for more details.
Thanks for the synopsis, I think I just need to spend some time to get more familiar with it. Thanks again.
Always happy to help.
|
|
|
Private answer
Why ANSI SQL 92 instead of ANSI SQL 99?? Marked as spam
 Posted by qatroll (Questions: 22, Answers: 7) Answered on July 31, 2013 9:20 pm
You'll need to ask HP developers that question.
|