TM1 Forum

Create an attribute called 'Level' and just fill it in with what you want to filter. So in this case fill it in with Level 0 (you can call it whatever you want) and then use the filter() command and filter against that in BI. Example: Filter([MyCube].[MyDimension].[MyDimension], [MyCube].[MyDimensio...

I just finished setting up Kerberos in 9.4.3 FP3. I was having issues setting it up getting the error "Server principal name (SPN) or the security context of the destination server could not be established." I followed the Operations guide and went through all the steps but still was recei...

Awesome, thanks guys.

Cryptic 2516 ERROR 2010-04-08 00:01:58.561 TM1.Rule TM1RuleImpl::LineGet - String overflow error, length = 526 Real Error When doing a CellGetS and passing in a NULL or '' as a dimension, it will give give the error above. Solution Add an if statement to verify the dimension is not a non null or bla...

TM1USER will give you the user who is running the TI Process.

So, in a TI Process you can use vUser = TM1USER;

On the one you just posted you are definetely missing a } around the area definition. You have: [{'701000 - Bank Service Charges']=> DB('G&A Allocations', !Version, !Department, !Country, !Month, !Portfolio, ‘Total – 701000 – Bank Service Charges’); Should be: [{'701000 - Bank Service Ch...

Make sure the file you are trying to use as a data source is not open too.