Search found 15 matches

by aboyzhou
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: 711

Re: ODBCOutput Delete table error with MS SQL2019

Hi Wim,

I will test latest verison on my PC.

Very appreciated your reference.

Best Regards,
by aboyzhou
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: 711

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. ...
by aboyzhou
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: 711

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...
by aboyzhou
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: 711

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...
by aboyzhou
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: 711

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...
by aboyzhou
Tue Mar 08, 2022 1:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Approaching project complexity
Replies: 15
Views: 3570

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...
by aboyzhou
Thu Feb 24, 2022 4:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculation within the same dimension
Replies: 6
Views: 1286

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
by aboyzhou
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: 2379

Re: TM1 Web View value is different Architect View

Can anybody help me ?

I have re-installed TM1 application, but the problem still on.

:cry: :cry: :cry: :cry: :cry: :cry: :cry: :cry: :cry: :cry: :cry: :cry: :cry: :cry: :cry:
by aboyzhou
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: 2379

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
Image
by aboyzhou
Wed May 24, 2017 12:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 cubeview display value incorrectly
Replies: 5
Views: 4133

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]
DisplayMistake.jpg
DisplayMistake.jpg (197.44 KiB) Viewed 3898 times
[/img]
by aboyzhou
Tue May 23, 2017 6:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 cubeview display value incorrectly
Replies: 5
Views: 4133

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
by aboyzhou
Sat Apr 29, 2017 3:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 cubeview display value incorrectly
Replies: 5
Views: 4133

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
TM1_ViewError.jpg
TM1_ViewError.jpg (263.76 KiB) Viewed 4133 times
by aboyzhou
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: 2763

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
by 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: 2763

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...
by aboyzhou
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: 2763

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?