select statements

[slimjen]

Hello,
I'm a SQL DBA new to Impromptu.  We installed Impromptu which connects to our SQL data warehouse.  I am just learning how to write reports using Impromptu against our data warehouse.  What I can't seem to grasp is to how to use actual SQL statements to create a report.  I get that I can select the columns in the catalog but I have a hard time formatting a select query against columns and not actual tables.  For instance; we have columns like empl id, date, actual call time intervals (1/4 hour) and call id.  I need to know for each employee, how many calls they completed for a given month and also how many actual call processing 1/4 hours on an average for the month.  So, empl 1 has 1900 calls for the month divideded by 120 actual call hours which equates to 15.77 avg call hours for the month.  How do I write a select query for this on columns?  What I'm doing is pulling the empl id, call center, value date, value time and call id columns.  I group on call center and empl id.  Then I get a count on call id.  This is how I get all the calls for that month for this empl.  Then I have to find the actual call hours by 1/4 hour.  So, I get a count on each 1/4 hour that a call is processed for the month.  This is really cumbersome.  Isn't there a easier way?  I hope I'm making since. Thanks

[COGNOiSe administrator]

From what you are saying here, you are able to get both counts, so now you just divide one by the other. I'm not sure if I am missing a point here? What is giving you trouble exactly?

[slimjen]

i need to know how to create my select statement if their no tables just columns to select from.  i.e. Select * from ?
count call id...

[COGNOiSe administrator]

Leave the SQL creation to Impromptu. Just define your catalog, specifying all tables and joins between them. Then drag the columns to your report and Impromptu will figure the rest out. If you aboslutely have to, there is an option for SQL override.