Search found 16 matches

by armas
Wed Dec 10, 2008 5:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Executing TI from SQL
Replies: 1
Views: 2167

Executing TI from SQL

Hello

Is there a way to execute a TI process from a SQL script?
Or probably a VB file executed by a SQL script and then this VB executes a TI process??

Or am I asking too much?
by armas
Tue Nov 25, 2008 3:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Service Error
Replies: 8
Views: 6701

Re: TM1 Service Error

I'm attaching the SSLs in case this is the problem.
Place them at C:\Program Files\Applix\bin\ssl
by armas
Tue Nov 18, 2008 4:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Send Email when TM1 service is down
Replies: 16
Views: 11496

Re: Send Email when TM1 service is down

Well the thing is that when a TM1 user loads a large a view or any other funny thing crashes the TM1 process, the service keeps showing as Started, so I suppose the scheduler will not detect the issue.
by armas
Tue Nov 18, 2008 2:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Send Email when TM1 service is down
Replies: 16
Views: 11496

Send Email when TM1 service is down

Hi

I have TM1 running as Windows Service.
Is there a way to send an email whenever the server crashes or comes down for any reason??
by armas
Fri Nov 14, 2008 3:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel issue
Replies: 1
Views: 2346

Excel issue

Hi, has anybody ever experienced the following?: I got Excel crashed in my local computer by something I can't remember, then I tried to open it up again and nothing happened. Also I remote desktop to a server where I got TM1 installed, then tried to open up Excel in the server too, and nothing happ...
by armas
Thu Nov 13, 2008 4:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 + SharePoint ??
Replies: 3
Views: 3670

TM1 + SharePoint ??

Does anyone know if this is possible...maybe just creating our Excel reports with TM1 formulas then load them into SharePoint server and see the report, use filter, etc etc....or am I totally asking too much??
by armas
Wed Oct 29, 2008 6:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web - File does not exist
Replies: 5
Views: 5366

Re: TM1Web - File does not exist

Where should I look at??
by armas
Wed Oct 29, 2008 4:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web - File does not exist
Replies: 5
Views: 5366

TM1Web - File does not exist

Hi

I have an Excel file as an application in my TM1 server.
I access the file with no problem from the Architect and Perspectives.

Then when I go to TM1 web and try to open it then get the error: "File does not exist: ...."

Any comments??
by armas
Tue Oct 28, 2008 4:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 lost data
Replies: 4
Views: 4016

Re: TM1 lost data

I have an automatic scheduled Chore which executes a TI process that saves data every 2 or 3 hours.

I have never been sure that running as service automatically saves when shuts down and automatically load logs when unexpected shut down
by armas
Tue Oct 28, 2008 3:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automatic Chore Disabling
Replies: 2
Views: 4547

Automatic Chore Disabling

Is there a way through TI code to disable/enable a chore??

Thanks
by armas
Mon Oct 27, 2008 5:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RuleCalculation for an specific element
Replies: 1
Views: 2099

RuleCalculation for an specific element

Hello I have a dimension called Departments. Then I have a measures dimension called EmployeeMeasures with AvaliableHrs as a C: element composed by PayHrs and StdHrs. Suppose I have the following department in the Departments dimension and three employees rolling up to it: 1820 - ControlFinance *Joh...
by armas
Tue Oct 14, 2008 4:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View in memory duration
Replies: 4
Views: 3617

View in memory duration

Hi I calculated a large view that took 3 minutes to calculate, then close Server Explorer, Excel, etc...then went through the view again one hour later and took a few seconds. Then I came back a couple of days later and took 3 minutes or more to be calculated. For how long a view is stored in memory...
by armas
Fri Sep 05, 2008 7:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Find a roll up using an [N] Element
Replies: 5
Views: 5001

Re: Find a roll up using an [N] Element

Oooops

Thanks for your kind response...but seems I did not explain as I should...
I'm trying to do this on Excel, actually something like ELISANC, but this function does not seem to work

Any workarounds?
by armas
Fri Sep 05, 2008 4:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Find a roll up using an [N] Element
Replies: 5
Views: 5001

Find a roll up using an [N] Element

Hi

Is there a way to know if an [N] element is rolling up to a certain consolidation even if this is 3 or 4 levels above??
by armas
Thu Aug 28, 2008 1:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Disable autosaving??
Replies: 7
Views: 5965

Re: Disable autosaving??

Thanks all I had never really thought about doing this before until I sent a great amount of values to a certaing cube, through an Excel file, then lost that file and realized those values were not correct at all and I was not able to recall the exact locations where those values were sent. Or proba...
by armas
Wed Aug 27, 2008 9:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Disable autosaving??
Replies: 7
Views: 5965

Disable autosaving??

Hi

I have my TM1 server running as a windows service.
If I make changes (like changing a value) and then Stop the service, TM1 automatically saves this change.

Is there a way to avoid this behavior???

Thanks