Search found 3215 matches

by lotsaram
Mon Jan 27, 2020 12:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use of DimensionDeleteAllElements
Replies: 3
Views: 82

Re: Use of DimensionDeleteAllElements

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 ...
by lotsaram
Sat Jan 25, 2020 7:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process Error Log Not Available
Replies: 12
Views: 163

Re: Process Error Log Not Available

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...
by lotsaram
Thu Jan 23, 2020 9:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process Error Log Not Available
Replies: 12
Views: 163

Re: Process Error Log Not Available

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...
by lotsaram
Thu Jan 23, 2020 11:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: To know Active Users & Inactive Users of TM1
Replies: 12
Views: 334

Re: To know Active Users & Inactive Users of TM1

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...
by lotsaram
Tue Jan 21, 2020 10:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic YTD Calculation on a Continuous Time Dimension
Replies: 15
Views: 160

Re: Dynamic YTD Calculation on a Continuous Time Dimension

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...
by lotsaram
Fri Jan 17, 2020 8:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: To know Active Users & Inactive Users of TM1
Replies: 12
Views: 334

Re: To know Active Users & Inactive Users of TM1

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...
by lotsaram
Wed Jan 15, 2020 4:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Log Management for PA
Replies: 7
Views: 232

Re: Log Management for PA

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...
by lotsaram
Fri Jan 10, 2020 10:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Datasource for Power BI
Replies: 6
Views: 608

Re: Tm1 Datasource for Power BI

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 ...
by lotsaram
Wed Jan 08, 2020 9:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem copying data between 2 cubes using TI
Replies: 3
Views: 118

Re: Problem copying data between 2 cubes using TI

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...
by lotsaram
Wed Jan 08, 2020 10:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX in TI Process
Replies: 14
Views: 522

Re: TM1 MDX in TI Process

.... 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...
by lotsaram
Wed Jan 08, 2020 6:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX in TI Process
Replies: 14
Views: 522

Re: TM1 MDX in TI Process

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...
by lotsaram
Mon Dec 23, 2019 1:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subsets and Views not registering after Restart
Replies: 13
Views: 802

Re: Subsets and Views not registering after Restart

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 ...
by lotsaram
Fri Dec 20, 2019 6:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subsets and Views not registering after Restart
Replies: 13
Views: 802

Re: Subsets and Views not registering after Restart

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 ...
by lotsaram
Tue Dec 17, 2019 8:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX Queries
Replies: 1
Views: 370

Re: TM1 MDX Queries

Have you looked at the Ancestors function?
by lotsaram
Fri Dec 13, 2019 10:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AsciiOutput element order different from subset
Replies: 12
Views: 507

Re: AsciiOutput element order different from subset

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 ...
by lotsaram
Thu Dec 12, 2019 8:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View not loading in TI Process
Replies: 8
Views: 501

Re: View not loading in TI Process

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...
by lotsaram
Tue Dec 10, 2019 8:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temporary views surviving their TI process
Replies: 10
Views: 327

Re: Temporary views surviving their TI process

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.
by lotsaram
Tue Dec 10, 2019 8:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Enhance DBSW/DBRW formulae with Hierarchy Awareness Parameters
Replies: 3
Views: 188

Re: Enhance DBSW/DBRW formulae with Hierarchy Awareness Parameters

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.
by lotsaram
Mon Dec 09, 2019 7:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temporary views surviving their TI process
Replies: 10
Views: 327

Re: Temporary views surviving their TI process

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...
by lotsaram
Fri Dec 06, 2019 2:22 pm
Forum: Useful code, tips and tricks
Topic: Bedrock Issues
Replies: 17
Views: 17415

Re: Bedrock Issues

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 ...