Does Express 10.2.1 supports MTQ (Multi-Threaded Query) ?

Post Reply
tm1novice
Posts: 29
Joined: Fri Nov 23, 2012 6:25 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2003

Does Express 10.2.1 supports MTQ (Multi-Threaded Query) ?

Post by tm1novice »

Hi All,

Does anybody know if Express 10.2.1 supports MTQ - Multithreaded Query ?

Express 10.2.1 bundles TM1 10.2 and TM1 10.2 supports MTQ (Multi-Threaded Query support).
But I could not find in Express documentation stating it supports MTQ.
http://pic.dhe.ibm.com/infocenter/cx/v10r2m1/index.jsp

Also, I could not find MTQ not being supported as well, in the document that lists the features that are in Cognos TM1 but not in Express 10.2.1
http://pic.dhe.ibm.com/infocenter/cx/v1 ... tures.html

Anybody have any idea ?

Thanks.
EvgenyT
Community Contributor
Posts: 324
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: 2016
Location: Sydney, Australia

Re: Does Express 10.2.1 supports MTQ (Multi-Threaded Query)

Post by EvgenyT »

Enterprise and CX have the same TM1 engine...the major difference is in the licensing perspective....CX under 100 users.

Thanks

ET
User avatar
stephen waters
MVP
Posts: 324
Joined: Mon Jun 30, 2008 12:59 pm
OLAP Product: TM1
Version: 10_2_2
Excel Version: Excel 2010

Re: Does Express 10.2.1 supports MTQ (Multi-Threaded Query)

Post by stephen waters »

EvgenyT wrote:Enterprise and CX have the same TM1 engine...the major difference is in the licensing perspective....CX under 100 users.
Under new 10.2 licensing there is also a max limit of 50 users for (effectively ) read write access, Performance Management users I think they are called. So you could have
- 100 reporters,
- 30 PM users and 70 reporter users
- 50 PM users and 50 reporter users
but NOT
- 60 PM users and 40 reporter users


There is also a limit of 560 PVUs for the server, effectively twin quad core processors.
tm1novice
Posts: 29
Joined: Fri Nov 23, 2012 6:25 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2003

Re: Does Express 10.2.1 supports MTQ (Multi-Threaded Query)

Post by tm1novice »

Found the link in Express :

http://pic.dhe.ibm.com/infocenter/cx/v1 ... ption.html

Though it refers to TM1, as its in Express documentation, should be supporting MTQ.

Thanks a lot guys for all your inputs.
User avatar
stephen waters
MVP
Posts: 324
Joined: Mon Jun 30, 2008 12:59 pm
OLAP Product: TM1
Version: 10_2_2
Excel Version: Excel 2010

Re: Does Express 10.2.1 supports MTQ (Multi-Threaded Query)

Post by stephen waters »

tm1novice wrote:Though it refers to TM1, as its in Express documentation, should be supporting MTQ.
Remember you have to turn it on in the cfg file!
Post Reply