TM1 Forum

@Gabor and @lotsaram, thanks for the ideas. I will give them a try. I agree with keeping it simple. I will try the csv file approach first and see if it works for the end users. I would have to get IT involved for the Windows Scheduler so that will be my 2nd approach.

Tom,
Thanks for the reply. You are correct, a snapshot is what I really wanted. Now that I search on snapshot (instead of slice) I am getting a lot of hits. Looks like I will have to create the snapshot manually every morning .

Thanks,
Bob

The people accessing the Excel file don't have access to TM1, so I am not sure that an Active Form would work - although I have no experience using Active Forms. The data on the mainframe changed every night so I need to refresh the Excel file daily. Just trying to automate the process so we have re...

This should be simple. We are running TM1 10.2.2. I need to create an Excel file from a slice of a cube using TI. I have no problem doing this manually, but I need it to happen at about 2:00 AM every day (and I only work the day shift) :D . Our mainframe will create a file that will be FTP’d to a TM...

Could it be that the SaveDataAll needs to be the first line of code in the process to not cause this issue? My TI process has only 1 line in it. The Prolog has the following: #****Begin: Generated Statements*** #****End: Generated Statements**** SAVEDATAALL; That is the only code in the process. I ...

Will do. I mentioned your PMR when I logged mine. The person I takled to didn't think that the crash dumps would show the root cause of the problem, just that the problem was from the tm1s.log file. They didn't even suggest that we create any debug files. We went live on 7/29/11 and 3 of the daily l...

Just ran into the same problem this afternoon. We use the SaveDataAll in a TI process every night before the LAN server is backed up. A TM1 Admin user was viewing the transaction logs beginning with several days ago and the server crashed. Our TM1 service is set to restart if it goes down on its own...

Thanks for all the replies. Unfortunately, removing the comma is not an option for us for reasons that I will not try to explain here. Clayton, our workaround (a 4 letter word in my vocabulary) also is to use the Dimension Editor in Server Explorer which seems to work. However we use Dimension works...

We are upgrading from Excel 2003 and Perspectives 8.4.5 running with a 9.0 server to Excel 2007 and 9.5.2 :twisted: . Ran into a problem with a dimension worksheet that includes the following elements (Note the comma in the name): Anderson, Donna Anderson, Richard 1. When we try to edit the dimensio...

Our database is 10.2.0.3 and the DBS's couldn't find 64 bit drivers for that release. We have 10.2.0.1 64 bit drivers and a patch to 10.2.0.4 but neither would work for us. We could set up a DSN and test the connection to the database just fine through the ODBC Database Administrator, but when setti...

This thread was about 10 days too late for me. I just went through about 12 days working with Iboglix support trying to get the 64 bit ODBC drivers for the Oracle 10g database to work with the 64 bit version of 9.0 SP3. Of course that still isn't working. However by accident I did stumble across the...

How many named users do you get for each concurrent user?