Archives of the TeradataForum

Message Posted: Thu, 21 Feb 2002 @ 23:31:11 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

Thanks,

Sam Mosley

	<Prev	Next>		<<First	<Prev	Next>	Last>>