TM1 Forum

Hi, i used an VLookUp in Excel to identify the missing rows. The data doesn't look unusual and yes I re-ordered the dimensions. We are still in development, so destroy the cube and reorder the dimensions could be an option - maybe I'm in Ehingen at the "Planning Analytics TM1 Anwendertag"...

Did you re-order the cube dimensions ?
There is a bug in PA (can't recall which release) with Rest API that will cause such issues if the cube has a re-ordered dimensions. Even PAx is facing the same problem.

Was bored with the long rule I am writing currently and decided to take a break and investigate this. If you edit the .vue file directly, the auto-calc flag is at code 376. A value of "1" means auto-recalc. Problem is public view won't work after you manually edit until a server restart. I...

Just noticed this message in server log with TM1 Build Number: 11.2.00000.27. SmartCache is disabled I remembered Smart Caching was mentioned years ago but never get much attention after that. Was checking tm1s.cfg parameter set didn't end up anything as well. Anyone knows anything about this ?

Are you using LDAPS (ie port 636) or LDAP (port 389) for the AD in the Cognos configuration ?
If you are using LDAPS, suggest you switch to LDAP instead and see if it resolve the issue.

Your issue is real. On PA instances I have also seen a lot of sf_DeleteFile and sf_SafeDelete errors, always to do with sub and/or vue files. It doesn't always occur on SaveData, sometimes it happens during TI process execution where a process that should execute in less than a second can drag on f...

Microsoft power BI is the leader in analytics and BI platform based on latest Gartner report. Contact us to learn more about how you can leverage both Power BI and TM1/Planning Analytics to advance your businesses using this leading analytics technology with a lower TCO. https://powerbi.microsoft.co...

I only remember there is a object structure change in 10.2.2 FP7 IF4 which caused the objects incompatible with lower release of TM1 (FP7 and below). http://www-01.ibm.com/support/docview.wss?uid=swg22008561 But in your case Server B is at FP6. :roll: Unless there are some other objects changes betw...

Did you attempt to isolate where the bottleneck is ?

In many cases this is at the DB (SQL?) end as ODBCOuput is not really an optimum way to upload into RDBMS.

Also how do you clear the current data in table before insert ? Delete or Drop table ? All this will have impact to the overall run time.

You can try GrepWin :
https://sourceforge.net/projects/grepwin/

However, it's not that straight forward with rule as you will need to deal with both .rux and the corresponding .blb.
Should works fine with .pro

We have just released Version 2.1.0. Highlights of the new release: - New Cache Engine with more dynamic cache control - Scalability and performance improvement to balance server resources and large data set request that goes beyond tens/hundreds of millions Please send us an email for details about...

The ^ character if I am not wrong is supposed to be used internally partly due to MDX. There was a bug with Set Editor that resulted in this character being exposed when using Subnm under PAX but this has been resolved with later PAX releases. SUBNM returned with the ^ character separating the level...

Rest API Port via the parameter :
HTTPPortNumber

If not specified, default is 5001 (PA 2.x), hence conflict.

I think Perspective "Print Report with snapshot option" is what you are looking for.

We have just released TMVGate Version 2.0.1

https://www.youtube.com/watch?v=CpyTFFYEE1U&t=8s

If you are on PA, store the client name as attribute and use the attribute as hierarchies. But again this will only work with PAx, Workspace but a more efficient and memory friendly way.

http://www-01.ibm.com/support/docview.w ... wg22000283

Many steps to follow but this is the only way now for all PA components.

Alternatively you can wait for the next update from IBM which promise a mode 3 with PAW.

I would check tm1server.log to see if there are any error.

Nov Update:
Validated R Studio integration with TMVGate

https://www.youtube.com/watch?v=428-zDU ... e=youtu.be