Hi,
My Excel in the server is 32Bit and I cannot change the installation.
I don't think I'll be able to install 62bit ODBC driver if my Excel is 32
Search found 41 matches
- Wed Aug 19, 2020 4:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBC connection to EXCEL
- Replies: 4
- Views: 2397
- Fri Aug 14, 2020 6:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBC connection to EXCEL
- Replies: 4
- Views: 2397
ODBC connection to EXCEL
Hi All,
I'm trying to set ODBC connection to xlsx.
I get no results (there are in the Excel) just blank column F1
Thanks
Roei
I'm trying to set ODBC connection to xlsx.
I get no results (there are in the Excel) just blank column F1
Thanks
Roei
- Wed Jan 22, 2020 4:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA Transaction Log
- Replies: 7
- Views: 3483
Re: PA Transaction Log
I'm using Perspectives in both
- Wed Jan 22, 2020 4:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA Transaction Log
- Replies: 7
- Views: 3483
Re: PA Transaction Log
Thanks EvgenyT.
I was able to read transaction log even of the current log in the TM1 10.2.2.
Now on PA it's not possible
Roei
I was able to read transaction log even of the current log in the TM1 10.2.2.
Now on PA it's not possible
Roei
- Tue Jan 21, 2020 5:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA Transaction Log
- Replies: 7
- Views: 3483
PA Transaction Log
Hi All, We use PA and looking for transaction log just like we did before in the TM1. It seems that now the transaction log only reads logs from closed log files and not from the one that is open right now. I can see transactions logs before today but not from today (only tomorrow I'll see today's l...
- Sun Oct 20, 2019 2:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RunProcess and Process Ends msg
- Replies: 22
- Views: 83736
Re: RunProcess and Process Ends msg
Yes, I saw it.
1. This part is not clear to me, how can I get an error from the running process if it did not ended yet since main process already ends?
2. How can I recognize "minor errors", "Error" etc. ?
1. This part is not clear to me, how can I get an error from the running process if it did not ended yet since main process already ends?
2. How can I recognize "minor errors", "Error" etc. ?
- Sun Oct 20, 2019 5:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RunProcess and Process Ends msg
- Replies: 22
- Views: 83736
Re: RunProcess and Process Ends msg
Hi, Thank you all for the answers. However, I'm still missing solution to know if there was a error \ minor error while running those processes. I don't want the user to get the process ends msg if there were errors. Since RunProcess brings no result I need Idea how can I register the process result.
- Sun Oct 13, 2019 11:39 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RunProcess and Process Ends msg
- Replies: 22
- Views: 83736
Re: RunProcess and Process Ends msg
I thought on something similar: to create an element \ view and delete in the end. In this way I can add an attribute that counts how many processes completed since not always the last process will ends the latest. What would you do if one of the process has error? I don't want to show "Process...
- Sun Oct 13, 2019 5:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RunProcess and Process Ends msg
- Replies: 22
- Views: 83736
RunProcess and Process Ends msg
Hi, I have process that being executed by users (few users can execute the process on the same time). I'm using few runprocess commands in this process to run other processes. The main process ends after few seconds and the user gets msg of "Process Ends". However, there are still threats ...
- Mon Jul 29, 2019 2:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: No ODBC preview
- Replies: 3
- Views: 6860
Re: No ODBC preview
Hi,
Thanks for your answer.
Yes, it's the same user and still don't work
Roei
Thanks for your answer.
Yes, it's the same user and still don't work
Roei
- Sat Jul 27, 2019 5:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: No ODBC preview
- Replies: 3
- Views: 6860
No ODBC preview
Hi All, I'm using PAX 2.0.8 We have a new process that connect through ODBC to a view in Oracle 11g. While i'm getting results in PL-SQL, tm1 showing me only the view headers (wo data). Based on posts in this forum, I already done the follows without any success. 1. Checked that cfg file contains: S...
- Mon May 27, 2019 6:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: tm1py not connecting
- Replies: 4
- Views: 4028
Re: tm1py not connecting
Hi,
Thanks that's may be the reason.
I'm using 10.2 FP2, hopefully after upgrading to PA it will work
Roei
Thanks that's may be the reason.
I'm using 10.2 FP2, hopefully after upgrading to PA it will work
Roei
- Sun May 26, 2019 5:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: tm1py not connecting
- Replies: 4
- Views: 4028
tm1py not connecting
Hi All,
I have installed the tm1py libary.
While trying to connect (even through the sample connection) i get no response from the service and all gets freeze.
Attached the what I get in the TM1top.
I hope that someone can help me with this
Roei
I have installed the tm1py libary.
While trying to connect (even through the sample connection) i get no response from the service and all gets freeze.
Attached the what I get in the TM1top.
I hope that someone can help me with this
Roei
- Tue Feb 20, 2018 3:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Getting data from AD
- Replies: 2
- Views: 2592
Getting data from AD
Hi All,
We are trying to get users from the AD to the TM1.
Is there any way we can get the users, alias, mails (not for security).
Thanks
We are trying to get users from the AD to the TM1.
Is there any way we can get the users, alias, mails (not for security).
Thanks
- Sun Dec 11, 2016 7:06 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SetInputCharacterSet is not working
- Replies: 0
- Views: 1629
SetInputCharacterSet is not working
Hi Experts, I have a TXT file that being overwritten every night and then being loaded to the TM1. For some reason in some of the nights the file is being loaded with strange characters. After checking this issue, we found that the file UNICODE on the problematic loadings is OEM United States instea...
- Sat Nov 19, 2016 6:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: FEEDERS issue/Bug
- Replies: 4
- Views: 3480
Re: FEEDERS issue/Bug
Hi,
We had tge same isse with TM1 9.5
After installing FP of 9.5.2 this issue was solved.
We had tge same isse with TM1 9.5
After installing FP of 9.5.2 this issue was solved.
- Tue Aug 30, 2016 5:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Form is greyed
- Replies: 1
- Views: 1638
Active Form is greyed
Hi Experts, All the users login to TM1 prespectives 10.2.2 through the same terminal. Few days ago we note that there are few users that their "Rebuild Current Sheet" and "Rebuild Current Book" are greyed out. i will just mention that if another user opens the same Excel file he ...
- Thu Jul 28, 2016 7:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX- Filter By Index
- Replies: 2
- Views: 3628
MDX- Filter By Index
Hi Experts,
i'm looking for MDX that will filter all the 0 level elements that their index is greater than the index of other element in the dimension.
Does someone has a good idea how to do it?
Thanks
i'm looking for MDX that will filter all the 0 level elements that their index is greater than the index of other element in the dimension.
Does someone has a good idea how to do it?
Thanks
- Wed Apr 13, 2016 5:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Automatic log from the transaction log
- Replies: 2
- Views: 3375
Automatic log from the transaction log
Hi experts, I need ideas to how I can export the transaction log automatically to an ASCII file once a week. I need a process that will take out from the transaction log all the transactions for cube A and export them to a file. The file should have the same columns we gets while query the transacti...
- Mon Dec 21, 2015 6:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1.Event mt_SetEvent: Set event 0x0000000000000000 failed
- Replies: 2
- Views: 3079
Re: TM1.Event mt_SetEvent: Set event 0x0000000000000000 failed
Hi,
Any solution for this issue?
I'm experiencing the same issue:
mt_SetEvent: Set event 0x0000000000000000 failed. error = 6
Thanks
Any solution for this issue?
I'm experiencing the same issue:
mt_SetEvent: Set event 0x0000000000000000 failed. error = 6
Thanks