Archives of the TeradataForum
Message Posted: Fri, 20 Oct 2000 @ 11:13:26 GMT
We have about 400 users using GQL (we have used it for 7 years and I can't get used to BI/Query)against models built by the support team and some business departments. Joins are defined in the model so if the builders know what they are doing regarding Teradata then the queries will be sound and efficient from that viewpoint.
The built in functions also translate well into the SQL submitted but they do not currently cover the new Teradata functions in V2R3/R4. Users can modify the SQL generated so they can still do silly things ut we find most of our serious performance problems are created by SQL only users.
We choose GQL because it was a graphical tool and this has stood the test of time, users can be up and running generating their own queries with a couple of hours hands on traning. This actually means that even if users use it infrequently they can remember how to do things, at least the basics. We have a datawarehouse philosophy of empowering the end user and this tool fits the bill exactly. We have looked at Business objects 3 times over the last 5 years including a couple of months ago and are still put off by the time it takes to define and setup universes. The average time for us to create a GQL model is a couple of days and a basic one can put together in a couple of hours. I have to say that these models are for user ad-hoc queries, we have a few models which are fancy and have lots of canned reports and these took longer to develop as you would expect.
Hope this helps.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|