Hi Wim,
I will test latest verison on my PC.
Very appreciated your reference.
Best Regards,
Search found 15 matches
- Mon Mar 18, 2024 10:05 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBCOutput Delete table error with MS SQL2019
- Replies: 7
- Views: 1239
- Mon Mar 18, 2024 8:58 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBCOutput Delete table error with MS SQL2019
- Replies: 7
- Views: 1239
Re: ODBCOutput Delete table error with MS SQL2019
Hello, Do you have an environment with the latest version of PA ? Thanks a lot for your reply. No, we does not use lastest version. The testing environment version is PA2.0.914 Because upgrading to the latest version is a heavy job that involves coordinating multiple departments, we can not do it. ...
- Mon Mar 18, 2024 3:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBCOutput Delete table error with MS SQL2019
- Replies: 7
- Views: 1239
Re: ODBCOutput Delete table error with MS SQL2019
Hi anyone, I also try to exectue store procedure with TM1, but still did not get any error message. Can somebody help for this error? or maybe it is a potential Bug with TM1? But I copy sql query to MS SQL Studio to execute, It returns "line 0 is affected." and there are not any other erro...
- Sat Mar 16, 2024 2:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBCOutput Delete table error with MS SQL2019
- Replies: 7
- Views: 1239
Re: ODBCOutput Delete table error with MS SQL2019
Hi, gtonkin, Thanks a lot for your reference. But I did not get any valid information, is that mistake with my tm1s-log.properties? below is my tm1s-log.properties: log4j.logger.TM1.SQL=DEBUG,ERROR,WARN, SQL log4j.logger.TM1.SQLAPI=DEBUG,ERROR,WARN, SQL log4j.additivity.TM1.SQL=false log4j.additivit...
- Sat Mar 16, 2024 8:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBCOutput Delete table error with MS SQL2019
- Replies: 7
- Views: 1239
ODBCOutput Delete table error with MS SQL2019
Hi anyone, I have a strange issue for ODBCOutput to delete table with cretria on MS SQL2019. I current used PA 2.0.9 TM1-AW64-ML-RTM-11.0.914.2-0 If the data I need to delete exists in the table, I can successfully execute the ODBCOutput sql statement, but if the data I need to delete does not exist...
- Tue Mar 08, 2022 1:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Approaching project complexity
- Replies: 15
- Views: 3606
Re: Approaching project complexity
Maybe, I think that you should read and undstand inner moduler logic with technical language, and then talk about business logic with business user and make them confirmed. If you would like to business user can undstand TM1 technical logic, this is crazy idea. I think that there are so many work mu...
- Thu Feb 24, 2022 4:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Calculation within the same dimension
- Replies: 6
- Views: 1297
Re: Calculation within the same dimension
Hi ,
Mybe I guess that you would like to get this formular:
DP1 - OthDP = TOTDP - (TOTDP - DP1)*2
Is that right or not?
You can try it with TM1 rule.
Michael Qian
Mybe I guess that you would like to get this formular:
DP1 - OthDP = TOTDP - (TOTDP - DP1)*2
Is that right or not?
You can try it with TM1 rule.
Michael Qian
- Tue Aug 08, 2017 1:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web View value is different Architect View
- Replies: 2
- Views: 2436
Re: TM1 Web View value is different Architect View
Can anybody help me ?
I have re-installed TM1 application, but the problem still on.
I have re-installed TM1 application, but the problem still on.
- Tue Aug 01, 2017 8:49 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web View value is different Architect View
- Replies: 2
- Views: 2436
TM1 Web View value is different Architect View
Hi Experts,
I confused that why the same view display different result as below:
My TM1 version is 10.2.2 and FP7
I confused that why the same view display different result as below:
My TM1 version is 10.2.2 and FP7
- Wed May 24, 2017 12:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 cubeview display value incorrectly
- Replies: 5
- Views: 4150
Re: Tm1 cubeview display value incorrectly
Hi Declanr,
Thanks a lot.
I have not amend any format for these view.
There are no any change after I tried to adjust the format of cubeview.
[img] [/img]
Thanks a lot.
I have not amend any format for these view.
There are no any change after I tried to adjust the format of cubeview.
[img] [/img]
- Tue May 23, 2017 6:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 cubeview display value incorrectly
- Replies: 5
- Views: 4150
Re: Tm1 cubeview display value incorrectly
Hi Dharav,
Thanks a lot for you reply.
Because this is planning sample cube, I do not think that it is feeder issue.
I did not change any planning sample rule and feeder and all of the application is same issue.
Do any experts what is it problem?
Thanks a lot.
Michael Qian
Thanks a lot for you reply.
Because this is planning sample cube, I do not think that it is feeder issue.
I did not change any planning sample rule and feeder and all of the application is same issue.
Do any experts what is it problem?
Thanks a lot.
Michael Qian
- Sat Apr 29, 2017 3:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 cubeview display value incorrectly
- Replies: 5
- Views: 4150
Tm1 cubeview display value incorrectly
Hi experts,
did you know why tm1 cube view could not display real value?
It just like screen:
Michael Qian
did you know why tm1 cube view could not display real value?
It just like screen:
Michael Qian
- Wed Jul 27, 2016 1:46 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: websheet generate dynamic hierarchy element row mistake
- Replies: 3
- Views: 2770
Re: websheet generate dynamic hierarchy element row mistake
Hi Every Experts,
anyone else has better solutions or advise regarding situation what I meet ?
Thanks a lot.
Aboyzhou
anyone else has better solutions or advise regarding situation what I meet ?
Thanks a lot.
Aboyzhou
- Wed Jul 20, 2016 9:34 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: websheet generate dynamic hierarchy element row mistake
- Replies: 3
- Views: 2770
Re: websheet generate dynamic hierarchy element row mistake
Hi Lotsaram, Thanks a lot for you reply. I currently use TM1 10.2.2 and I have install FP5 on my local envirenment, but the problem still exist. The 'FilterCategory' is always include in product dimension, just only its children and leaf element would be dynamically generated. If I directly run Exce...
- Mon Jul 18, 2016 2:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: websheet generate dynamic hierarchy element row mistake
- Replies: 3
- Views: 2770
websheet generate dynamic hierarchy element row mistake
Hi All,
I user TI process generated dynamic hierarchy element row, buy it show DBRW cell is null and could not be Input anything in my websheet.
If I re-login websheet, it show ordinary result as below picture.
Anybody can help to judgement if it was bug?
I user TI process generated dynamic hierarchy element row, buy it show DBRW cell is null and could not be Input anything in my websheet.
If I re-login websheet, it show ordinary result as below picture.
Anybody can help to judgement if it was bug?