Search found 31 matches

by jjramirez
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: 1756

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...
by jjramirez
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: 2270

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.
by jjramirez
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: 2270

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:
by jjramirez
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: 2270

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:
by jjramirez
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: 2270

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...
by jjramirez
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: 2270

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...
by jjramirez
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: 876

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.
by jjramirez
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: 876

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...
by jjramirez
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: 1659

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...
by jjramirez
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: 1659

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...
by jjramirez
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: 4045

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...
by jjramirez
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: 4045

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 ...
by jjramirez
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: 24902

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...
by jjramirez
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: 24902

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...
by jjramirez
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: 24902

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...
by jjramirez
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: 24902

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...
by jjramirez
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: 24902

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...
by jjramirez
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: 24902

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...
by jjramirez
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: 4674

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
by jjramirez
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: 4674

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...