Anyone using Business View DQL queries?

Question ID: 105088

What is the benefit of business view and why not just use SQL?

Marked as spam
Posted by (Questions: 5, Answers: 1)
Asked on July 31, 2013 8:34 pm
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 (Questions: 0, Answers: 613)
Answered on July 31, 2013 8:38 pm
So what is the why DQL instead of SQL? Any Limitations?
( at July 31, 2013 8:40 pm)
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).
( at July 31, 2013 9:06 pm)
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.
( at July 31, 2013 9:07 pm)
Thanks for the synopsis, I think I just need to spend some time to get more familiar with it. Thanks again.
( at July 31, 2013 9:09 pm)
Always happy to help.
( at July 31, 2013 9:11 pm)
Private answer

Why ANSI SQL 92 instead of ANSI SQL 99??

Marked as spam
Posted by (Questions: 22, Answers: 7)
Answered on July 31, 2013 9:20 pm
You'll need to ask HP developers that question.
( at July 31, 2013 9:21 pm)