Search found 31 matches
- Wed Jan 25, 2023 4:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SQL ANSI_NULLS Warnings are missunderstood like an error in turbointegrator
- Replies: 0
- Views: 1866
SQL ANSI_NULLS Warnings are missunderstood like an error in turbointegrator
Hi, I have a TI with ODBC as Data Source and I am using an SQL query previously tested in SQL Management Studio and directly in ZEUS (Accounting software) by IT team but "sometimes" the process fails and returns this message: Error: Data procedure line (0): SQLState: 01003 SQLMsg: [Microso...
- Fri Jan 13, 2023 3:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Perspectives Active Form and O365 removing formulas
- Replies: 18
- Views: 2408
Re: TM1 Perspectives Active Form and O365 removing formulas
Hi,
I populated the blue title with the same string, a diferent period but nothing changes...
Only when I add a DBRW formula that uses the TM1RPTView the problem disapear.
I populated the blue title with the same string, a diferent period but nothing changes...
Only when I add a DBRW formula that uses the TM1RPTView the problem disapear.
- Thu Jan 12, 2023 8:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Perspectives Active Form and O365 removing formulas
- Replies: 18
- Views: 2408
Re: TM1 Perspectives Active Form and O365 removing formulas
Hi Wim and Steve,
Thanks for your comments.
I was testing what you proposed, but I got the same results:
Thanks for your comments.
I was testing what you proposed, but I got the same results:
- Thu Jan 12, 2023 4:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Perspectives Active Form and O365 removing formulas
- Replies: 18
- Views: 2408
Re: TM1 Perspectives Active Form and O365 removing formulas
Now, please see what happen if I don't leave the blank and add any formula
and what happen IF I deleted the inserted blank columns:
and what happen IF I deleted the inserted blank columns:
- Thu Jan 12, 2023 3:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Perspectives Active Form and O365 removing formulas
- Replies: 18
- Views: 2408
Re: TM1 Perspectives Active Form and O365 removing formulas
Hi, Just on the off chance does it work without the column break in G? The steps to reproduce de error: step1 : export an active form from any cubeview using Tm1 perspectives step2: insert a new blank column anywhere in the data range step3 click on recreate the sheet or workbook Results: the last c...
- Wed Jan 11, 2023 10:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Perspectives Active Form and O365 removing formulas
- Replies: 18
- Views: 2408
Re: TM1 Perspectives Active Form and O365 removing formulas
Hi, Last nov-22 we upgraded to: Planning Analytics 2.0 Local 2.0.9.15 (11.8.01700.1) Planning Analytics 2.0 Spreadsheet Services 2.0.81 Planning Analytics 2.0 For Microsoft Excel 2.0.82 Planning Analytics 2.0 Workspace 2.0.81 I think I have the same problem... When trying to refresh an active form b...
- Thu Dec 01, 2022 2:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Order set in prolog tab in a view created with MDX is no the order running in datatab
- Replies: 5
- Views: 931
Re: Order set in prolog tab in a view created with MDX is no the order running in datatab
Hi gtonkin,
thanks for your reference. I found a solution creating the subset and looping in the prolog tab instead of using the source view.
thanks for your reference. I found a solution creating the subset and looping in the prolog tab instead of using the source view.
- Wed Nov 30, 2022 9:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Order set in prolog tab in a view created with MDX is no the order running in datatab
- Replies: 5
- Views: 931
Order set in prolog tab in a view created with MDX is no the order running in datatab
Hi everybody, I created a view in the prolog tab using a MDX to filter and order a dimension from the source cube and when I test the MDX in subset editor the elements are shown in the expected order even in the view created by the TI Process elements appears in the expected order but when process g...
- Thu Sep 17, 2020 8:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Forms that Works in TM1 Perspectives doesn’t work on Planning Analytics For Excel.
- Replies: 2
- Views: 1692
Re: Active Forms that Works in TM1 Perspectives doesn’t work on Planning Analytics For Excel.
Hi rebecca, thanks for your response. I've tried your idea but i got the same results. There's something with the "rebuild workbook/sheet", i erase the grouping but when i click on "rebuild workbook/sheet" buttons the rows generated by TM1RPTROW get grouped again. kind regards, J...
- Thu Sep 10, 2020 7:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Forms that Works in TM1 Perspectives doesn’t work on Planning Analytics For Excel.
- Replies: 2
- Views: 1692
Active Forms that Works in TM1 Perspectives doesn’t work on Planning Analytics For Excel.
Hi Everybody, I am in the process to upgrade from TM1 10.2.2 to Planning Analytics 2.0.9 and i've found some troubles with Planning Analytics For Excel when i try to open a workbook that contains an active form: When refreshing the active form in PAX the TM1RPTROW formula only returns the first elem...
- Thu Jun 14, 2018 2:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: C Level Rules with attributes evaluations in N level elements
- Replies: 5
- Views: 4304
Re: C Level Rules with attributes evaluations in N level elements
Hello! Fisrt of all: Sorry for the late response, i was out of the office for a few days. And Thnak you very much for you comments. I am agree with MGrain, =C: is unnecessary as i am evaluating only C elements in time dimension I've reviewed if there is another rule interfering, but i didn't see any...
- Wed Jun 06, 2018 9:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: C Level Rules with attributes evaluations in N level elements
- Replies: 5
- Views: 4304
C Level Rules with attributes evaluations in N level elements
Hello everybody! I have a conceptual doubt with TM1 Rule Calculation for C Level elements. I need the rules to aply only for specific C level elements in time dimension (month) but All attributes that i have to evaluate are defined for a N level element (!Concesion). I Know C level Rules only apply ...
- Mon Sep 25, 2017 3:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
- Replies: 12
- Views: 25165
Re: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
Hi! First of all, i want to correct my last post... Yes you're right. I think found that Tm1RunTi only reads until 9 parameters and my process has 15... RunTi can send to the .Bat File as many parameters as the TI Process has, but the CMD batch script only can read until 9 parameters. There's some w...
- Fri Sep 22, 2017 7:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
- Replies: 12
- Views: 25165
Re: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
Hi Drg P/s/ My expirence runti in parralel, so painfull. Many params may affect to result execution( when you are cooking view, whether you use in view (sabsets) mdx, ...) and bugs tm1, need be ready to all it/ Yes you're right. I think found that Tm1RunTi only reads until 9 parameters and my proces...
- Thu Sep 21, 2017 4:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
- Replies: 12
- Views: 25165
Re: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
Yes, i am using some global parameters and attributes in the child processes that run with TM1RunTi. but the case is when i send 12 processes for a year i see in logfile only 11 executions... why this happens? i have verified the MaximumPorts parameter in }CLientProporties control cube and is set to...
- Mon Sep 18, 2017 7:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
- Replies: 12
- Views: 25165
Re: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
Hi Paul yes, but in the case of contention i would expect some messages in "tm1lockexceptiondebug" file , but the only message it appears is about a lock in object client, no other objects. Please, it would be great if you can check the ti process in attachments: MasterProcess = Traslado.P...
- Mon Sep 18, 2017 4:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
- Replies: 12
- Views: 25165
Re: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
Hi Paul first of all, thanks for your answer. Yes, All process are running under the same user ID and MaximumPorts parameter in }ClientProporties is cero for all clients and i didn't find another parameter in TM1 configuration file that specify this number. Could you please tell me where i can confi...
- Sat Sep 16, 2017 1:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
- Replies: 12
- Views: 25165
Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
Hi! I am trying parallel execution for the first time and i'm living with a problem that i don't understand: i have a master process that call some child process in batch using Tm1RunTi. The problem is, sometimes, aleatory, the master process just stop execution with any action completed. The master...
- Sat Sep 02, 2017 2:36 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to get an automatic cubeview refresh with TI Process
- Replies: 5
- Views: 4732
Re: How to get an automatic cubeview refresh with TI Process
I'll give it a try with vba first, Thank you very much for your answer lotsaram
- Thu Aug 31, 2017 8:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to get an automatic cubeview refresh with TI Process
- Replies: 5
- Views: 4732
Re: How to get an automatic cubeview refresh with TI Process
yes TomoK, i mean recalculate the view automatically without any click on the recalculate button. i need to show to other users the masterProcess progress in the cubeviewer. Another option is create and publish a websheet and put a VBA Code that recalculate the excel sheet every X seconds or mins. B...