TM1 Forum

I have read that if you are using alternate hierarchies this means any potential data loss cannot happen when using DimensionDeleteAllElements? So is it now the case to avoid using DimensionDeleteAllElements only when you are not using alternate hierarchies? I would say in general, "yes". The main ...

No go on the RunProcess thing either. The issue is that the error log file does not exist on disk until the original process is completely finished. Sticking a RunProcess on the Epilog means it is running before the original process finishes. I even put in a one minute sleep right before the RunPro...

You could just launch the emailer process with ExecuteCommand and tm1runti from the Epilog and put in a small wait so that by the time the emailer checks for the error log file the calling process has finished its commit and the lock on the log file is released. Or if you are on PA the RunProcess sh...

Hello, thanks for sharing this tip. If users login via PAW, each time they write new data, or change the dimension element, load a new view, etc... a new login is added to the log. Is there any way where we can only log their main login and not each transaction? This is an artifact of how the front...

You don't need extra attributes. What you need is dimension structure. That is you need to add rollups for YTD elements. By far the fastest and most efficient way to do additive calculations in TM1 is via dimension rollups. YTD rollups can be created quite easily via TI process. There are a number o...

I interpreted he OP's request (albeit however poorly formulated) as how to determine and then remove dormant or inactive accounts, as opposed to simply users not currently logged in. For SOx compliance of needing to remove accounts inactive for >90 days I used to employ the method described by pauls...

There's one related thing though - we're using CAM for authentication. Then, of course, in Cognos we can see the users email addresses as they are taken from LDAP. But in TM1 we do not have this information, we basically get only the user ids from Cognos. I wasn't able to think of an easy way how t...

I didn't pursue this but it looks like you could use PowerBI's Python integration to link to TM1PY: https://www.tm1forum.com/viewtopic.php?f=3&t=14191&p=71322&hilit=powerbi#p71322 That's a starting point, but really only a starting point. I am currently looking forward for an option to connect TM1 ...

I created a new cube and use rules to pull the numbers then use TI, it works. I think I know the answer. TI can only read/write from/to leaf-level cells? Not quite. TI can read from any intersection. Generally you would considder that TI can only write numeric data to leaf intersections but there i...

.... TM1 will not let you create an empty MDX subset. Standard practice (mine anyway) is to add the first element from the dimension to the start of the MDX statement and then delete the first element from the subset once it is created. This has the advantage that you can create an empty subset and...

Do not use CurrentMember. Make your expressions 'absolute' by specifying real element names and/or attributes and/or cube intersections, and so on. There is no CurrentMember inside a TI process. I don't understand this advice at all. There's nothing wrong with using CurrentMember. In this context i...

Still makes no sense that Private Subsets work as intended. For now it is what it is, workarounds already implemented and deployed. No actually it makes perfect sense! Private subsets and views aren't loaded when the server loads but when the user logs in. The implicit DimensionDestroy and rebuild ...

Hi George, I don't think this is new. This is just the way it is or always has been. Or as IBM woudl have it, it's a "feature" not a "bug". It's becasue the }Dimensions and }Cubes dimensions are recreated on every server restart and elements inserted from a sweep of the .dim and .cub objects in the ...

Have you looked at the Ancestors function?

If your data source is a SUBSET then sure you can absolutely control the order of output but if your data source is a VIEW (or at least a native view) then no you cannot control the order of elements. For a view elements will be processed in index order and dimensions will be "rotated" from last to ...

re. increasing max view size in TM1s - I was under the impression that was only for end users opening views and that would not impact TI processes - am I mis-informed? Could be, as I often see conflicting info on TM1 topics, sometimes even in IBM's own documentation:-). MaximumViewSize doesn't affe...

I think you might actualy be exploiting a bug Ty. AFAIK assigning a permanent subset to a temp view isn't supposed to work and you may find that on next upgrade all processes using this "feature" break.

I would try and confirm with IBM support if this is actually supposed to work.

This is a planned feature so I'm not sure that posting as a feature request is relevant in this case. It is just taking a (very) long time to implement.

A sub-process creates a temporary view using a non-temporary subset from another sub-process. Are you sure? As in are you sure, you're sure? In my experience trying to assign a temp subset to a non-temp view (or vice versa) will result in an error and the process aborting. So if you are managing to...

I've gotten so much out of this community, it's time I put something back in. The parameter pSuppressConsol does not work properly for }bedrock.cube.data.copy.intercube.pro . Errors occur when trying to copy string across cubes. Hi Adam, Someone else noticed the same issue and in fact we have just ...