Search found 2667 matches

by tomok
Mon Jan 27, 2020 4:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBR/DBRW formulas resulting in #VALUE! errors
Replies: 8
Views: 126

Re: DBR/DBRW formulas resulting in #VALUE! errors

Probably not related to your problem but a sheet full of DBR formulas that don't utilize a VIEW statement as part of the sheet is going to perform like unmitigated crap.
by tomok
Mon Jan 27, 2020 1:37 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

Well Duh. You need to put the wait IN THE EMAILER PROCESS that is called with RunProcess. No point putting a wait before calling the emailer as like you observed the error log isn’t released until the process finishes. So you could wait a day and still won’t work. Thanks. That did the trick. Not th...
by tomok
Sat Jan 25, 2020 11:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Private Sets to Cloud Integration
Replies: 2
Views: 564

Re: Private Sets to Cloud Integration

Having just gone through an IBM Cloud conversion four months ago here's what you need to know: You CAN copy over private views and subsets and the user folder name is controlled by the alias }TM1_DefaultDisplayValue on the }Clients dimension. That alias value is created for you by IBMs user setup ro...
by tomok
Fri Jan 24, 2020 3:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy element attributes from one dimension to another
Replies: 2
Views: 49

Re: Copy element attributes from one dimension to another

I'm not sure how to deal with control cubes (with normal cubes I would create a view and copy data over but doesn't seem to work here). Not sure where you are getting this idea. Control cubes are just cubes. You can create views on them AND you can most certainly use those views as a data source in...
by tomok
Fri Jan 24, 2020 12:13 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

I'll give the RunProcess thing a try. 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 on...
by tomok
Fri Jan 24, 2020 11:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI MDX query of 2 different cubes
Replies: 11
Views: 151

Re: TI MDX query of 2 different cubes

You can use ODBO to access a cube from another TM1 server as the primary data source and then use a CELLGETN against a cube on the server that is housing the TI process but this would only be a viable solution if there is a record in the ODBO source for every combination such that the end result of ...
by tomok
Fri Jan 24, 2020 11:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset having a cube of parameters
Replies: 8
Views: 107

Re: Subset having a cube of parameters

Showing us a picture of the Variables tab only proves that it is not blank for the first record in the dataset. Have you confirmed that ALL the records in the dataset have a value in vCANAL_DESPESAS? All it takes is one record to cause the error. While you're at it. Please show us the the entire lin...
by tomok
Thu Jan 23, 2020 9:46 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

Or if you are on PA the RunProcess should achieve the same but without need for tm1runti. I am on PA because we're in the IBM Cloud. I'll give the RunProcess thing a try. I was using ExecuteProcess and that didn't work. As I said earlier up the thread, the file is not actually being written to disk...
by tomok
Thu Jan 23, 2020 8:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI MDX query of 2 different cubes
Replies: 11
Views: 151

Re: TI MDX query of 2 different cubes

A TI process can only have one cube as a data source so the standard way of handling this is to have one cube as the data source (the one with the main intersection of cells you are trying to process) then in the Data tab of that process you issue a CELLGETN against the secondary cube to get it's va...
by tomok
Thu Jan 23, 2020 4:24 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

I went ahead and added a new attribute to the }Processes dimension called "Last Error Log" and changed my process that updates process attributes (I have a generic one that I call at the end of every TI process) to update this value with the name of the error log, if any. I also created a new proces...
by tomok
Thu Jan 23, 2020 2:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset having a cube of parameters
Replies: 8
Views: 107

Re: Subset having a cube of parameters

So this is the offending line of code?: vANOINI=CellGetS('CMU.PARAMETROS_CARGA','Aplicar Filtros',vCANAL_DESPESAS,vGRUPO_ECONOMICO,'Ano Inicial'); I am assuming that the dimension 02.Canal_Despesas is the second dimension in the CMU.PARAMETROS_CARGA cube, correct? If so, the error message is telling...
by tomok
Thu Jan 23, 2020 1:57 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

Until the process ends, the processerror log is still named .log$ Thanks for the idea. I modified my code to put a "?" at the end of the file name but that didn't work. So, I put a one minute sleep in the process for testing and did a continuous query of the log directory and it appears that the lo...
by tomok
Thu Jan 23, 2020 12:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process Error Log Not Available
Replies: 12
Views: 163

Process Error Log Not Available

I have a routine I have used for a long time that accumulates a list of all the error log files generated during the running of a chore and the last process of the chore generates an email that sends a message with all the error logs as an attachment. I now have a need to do this for one process at ...
by tomok
Wed Jan 22, 2020 11:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Single Sign on for Planning Analytics and PAW
Replies: 2
Views: 131

Re: Single Sign on for Planning Analytics and PAW

Hi I just want to find out, how can I configure single sign on, for Planning Analytics and Planning Analytics Workspace. I am current using Intergration Mode 1 You do realize this is all covered in the installation docs don't you? Give it a go and then come back with specific questions when you run...
by tomok
Fri Jan 17, 2020 3:39 pm
Forum: Useful code, tips and tricks
Topic: Going to the IBM Cloud
Replies: 2
Views: 99

Going to the IBM Cloud

I haven’t seen this anywhere so since we recently went through a conversion to the IBM Cloud I thought I would put together a little writeup of what to expect if you also go to the IBM Cloud. Here’s what you get for each instance (standard is one for PRD and one for DEV): TM1 server with 64GB of RAM...
by tomok
Fri Jan 17, 2020 12:24 pm
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

It doesn't really matter if the OP is talking about users that aren't currently logged in or users that have not logged into TM1 within a certain time period when it comes to the idea of just deleting users and let the system add them back. This would only be a valid approach if they are using CAM s...
by tomok
Thu Jan 16, 2020 5:06 pm
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

habibullah.sayyed wrote:
Thu Jan 16, 2020 11:59 am
My friend suggested that delete all users from TM1 architect
A really, really bad idea. What about the people that were off sick that day, or had their computer turned off, etc. and were therefore not actively logged into TM1? Boom, there goes all there security group assignments.
by tomok
Thu Jan 16, 2020 5:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Log Management for PA
Replies: 7
Views: 232

Re: Log Management for PA

Exactly, it is not an issue where to store them but what's the best way to get them/keep them updated. How often does someone's email address change? Seriously. We have approx 250 users and we had one person last year that had a name change and thus email address change. I wouldn't spend any time a...
by tomok
Wed Jan 15, 2020 1:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Log Management for PA
Replies: 7
Views: 232

Re: Log Management for PA

I wasn't able to think of an easy way how to get the email addresses from Cognos to TM1. Any ideas there? The rest (trigger the script to email the file to the user) is easy. Just create an attribute on the }Clients dimension called "EmailAddress" and store them there. Of course you'll have to figu...
by tomok
Wed Jan 15, 2020 1:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Protect DBRW fomrula in Perspectives
Replies: 8
Views: 248

Re: Protect DBRW fomrula in Perspectives

I understand your intention very clearly and it can be done with DBS, just not in a way that is going to completely mimic the way it works with the plain DBRW formula. For that reason you should probably just tell your client it can't be done. I can pretty much guarantee you if they aren't happy wit...