 |
 |
Archives of the TeradataForum
Message Posted: Wed, 09 Jul 2003 @ 20:59:48 GMT
| Subj: | | Re: Alternating Account Strings via Microstrategy Logon |
| |
| From: | | Yonina Schuchman |
We have multiple Microstrategy projects. The user logs on to each project with the same ID. Within each project the ID is mapped
to a group logon with the necessary account info. That way, our merchandising queries (tactical) use a different resource partition
with a higher weight than our marketing queries (killer queries). Each of the Teradata/Microstrategy group logons use milestone
limits so they all come in at Rush within the specific partition and then gradually are degraded as CPU is consumed. Starting out at
Rush allows the lookup queries to return to the user in subsecond response time.
| |
