Archives of the TeradataForum
Message Posted: Thu, 21 Feb 2002 @ 23:31:11 GMT
The database tables are a somewhat denormalized 3NF, but the Microstrategy reports hit star schema views, with the "fact tables" (read views) being a fairly complex join of multiple tables. Any given report will hit only one fact table.
However, my real concern right now is more along the lines of control of the number of queries being run by each user. We currently have controls in the middleware piece, so that the user only has one report running, and any additionally submitted reports queue up. These controls apparently aren't available in 7.1. Thus, we either open it up to running multiple reports simultaneously, and running into significant issues with spool space, or may have to delay the implementation until a better control mechanism is available.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|