Search found 41 matches

by roei61
Wed Aug 19, 2020 4:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC connection to EXCEL
Replies: 4
Views: 2397

Re: ODBC connection to EXCEL

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
by roei61
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
by roei61
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
by roei61
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
by roei61
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...
by roei61
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. ?
by roei61
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.
by roei61
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...
by roei61
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 ...
by roei61
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
by roei61
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...
by roei61
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
by roei61
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
by roei61
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
by roei61
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...
by roei61
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.
by roei61
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 ...
by roei61
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
by roei61
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...
by roei61
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