Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: MicroStrategy 7.1
From:   Sam Mosley

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.


Sam Mosley

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020