TM1 Forum

Thanks for your answers :) So if i understand correctly, because the Analytical Server (TM1) has a PVU limit, sub-capacity licensing terms can be applied? Please correct me if i'm wrong. So the next thing would be to check if ILMT must be used (if supported by the environment) or if the customer has...

Currently trying to understand the IBM licensing requirements (Full Capacity, Sub-Capacity, ILMT etc.). IBM says on their website that sub-capacity licensing only applies to PVU-based software. Cognos Express isn't PVU based but Install- and AuthorizeD User Based. Does that mean that if i want to in...

jim wood wrote:Have you tried using TM1 Top? There are plenty of posts about that on here.

Yeah, but it only shows the most recent lock of a thread. If a thread hold multiple locks, you can't see them.

Hi! Is there any way in TM1 to see which objects are currently locked by any thread, process or user (R-Rock, IX-Lock etc.)? I currently have problems with parallel execution of TM1 cube load chores even with parallel interaction and need a little debugging. My second question would be: If you start...

I'm not sure if Cognos BI creates dynamic subsets via MDX but it's highly possible.
Updating TM1 to 10.1.0 FP1 seems to be the first step in isolating the problem.

I wonder if this problem still exists in TM1 10.1.0 FP1.
Anyway, thanks for the help George.

lotsaram wrote:The function you want is TABDIM. If it returns 0 then the dimension is not part of the cube.

TABDIM only gives you the dimension name for the specified index. TABDIM doesn't accept a dimension name as a parameter.
A small helper cube would be the best solution in my opinion.

I have a problem with TM1 9.5.2 FP2 and long running queries initiated by Cognos BI 10.1.1. Long running queries can block TM1 completely which means that no further API commands (or MDX commands initiated by Cognos BI) can be executed against TM1. Even TI Processes will not execute. In TM1Top i can...