Post Author: computknit
CA Forum: Desktop Intelligence Reporting
How do I set up either Desktop Intelligence or Designer so that when I query for totals only the totals get returned? We have over 250,000 rows in a main table and I cannot keep pulling that much data down to the PC when all they need are totals. We are using Teradata V2R6.1. This table also needs to be available to query details when they select a single user.
The sql being generated is "select avail_bal from table1 where avail_bal > 0" when I want the sql to be "select sum(avail_bal) from table1 where avail_bal > 0". I am having these issues all over the place and if I increase the user row limits I bury the pc or the network.
Thanks. Debbie