Search found 46 matches

by jrizk
Mon Mar 18, 2019 3:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 report bursting
Replies: 8
Views: 917

Re: TM1 report bursting

I don't think it will work when everyone is logged off. The only way it seems to work is to schedule the task under the Administrators group - not a user account which is part of the Administrators group - and this only runs when a user is logged on. The Excel identity is 'The Interactive user'. I t...
by jrizk
Mon Feb 04, 2019 9:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2. TM1API: TM1SystemServerNof doesn't work
Replies: 4
Views: 180

Re: TM1 10.2.2. TM1API: TM1SystemServerNof doesn't work

While the technote relates to the CDM application server the workaround for connectivity using the API (TM1SystemOpen()) for your Tm1 install is "Switch to V2 certificate". I would test this out on the server side (in a development environment preferably) - pointing the certificate to: C:\Program Fi...
by jrizk
Thu Jan 31, 2019 4:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX for getting Parent and Children
Replies: 17
Views: 339

Re: MDX for getting Parent and Children

Doesn't seem to behave differently. Though it might be worth trying:

{ [DimName].[Consol1], [DimName].[Consol1].Children }
{ [DimName].[Consol2], [DimName].[Consol2].Children }

rather than filtering by pattern.
by jrizk
Thu Jan 31, 2019 12:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2. TM1API: TM1SystemServerNof doesn't work
Replies: 4
Views: 180

Re: TM1 10.2.2. TM1API: TM1SystemServerNof doesn't work

Assuming the code is correct then this could be an issue with the change in certificates and using tm1ca_v2.pem vs applixca.pem This link might help: https://www-01.ibm.com/support/docview.wss?uid=swg21993992 The link specifies only changing bin64\ssl - however it may be necessary to change bin\ssl ...
by jrizk
Wed Jul 25, 2018 12:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automating TM1 in VBA
Replies: 11
Views: 1096

Re: Automating TM1 in VBA

I had the same issue trying to automate Excel/Tm1 to produce excel based reports, particularly when logged off the server, and I didn't want to keep changing the DCOM settings for Excel to be able to use it every session. The 2 Desktop folders in a Windows didn't work either so I'm not sure that had...
by jrizk
Fri Apr 27, 2018 11:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parameterized Data load issue
Replies: 6
Views: 758

Re: Parameterized Data load issue

Hi, If you want it to work as per what you have now you need change elmperiod to the month variable in the source file (V6 I think you have for the month) ie if(elmperiod@=pPeriod % pPeriod@= 'All'); to if(v6@=pPeriod % pPeriod@= 'All'); if(elmperiod@=pPeriod % pPeriod@= 'All'); resolves to true if ...
by jrizk
Thu Feb 15, 2018 2:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Evaluation of DBRW Formula in VBA
Replies: 7
Views: 1406

Re: Evaluation of DBRW Formula in VBA

Try: sDBFormula = "DBRW(" For i = 0 To numArgs sDBFormula = sDBFormula & """" & Application.Evaluate(argsArrayValue(i)) & """," Next i sDBFormula = Mid(sDBFormula, 1, Len(sDBFormula) - 1) & ")" myValue = Application.Evaluate(sDBFormula) You may have to include/exclude the quotes for each of the argu...
by jrizk
Tue Feb 13, 2018 9:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Evaluation of DBRW Formula in VBA
Replies: 7
Views: 1406

Re: Evaluation of DBRW Formula in VBA

For simple formulas you can strip out the dbrw based on *, / , +, - after the closing bracket using Instr. More complex formulas will require a some code or function to work out the positions of the opening and closing brackets of the the DBRW so it can be stripped out using those positions. x = InS...
by jrizk
Mon Feb 12, 2018 1:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: formula for element property in hierarchy
Replies: 4
Views: 1152

Re: formula for element property in hierarchy

Assuming you have a measures dimension and are are initially loading the data as +ve and -ve and all you weightings are 1. If so, a suggestion would be to set up a second measure(s) and have a rule to push the values into the second measure. Then set the formatting for the measures respectively (you...
by jrizk
Thu Aug 17, 2017 6:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 tools excel add-in not working in Excel 64 bit
Replies: 15
Views: 7306

Re: TM1 tools excel add-in not working in Excel 64 bit

Hi, I’ve uploaded TM1Tools.xlam which should work on both 32bit and 64bit Excel. To note: * converted xla to xlam * replaced the toolbar (and disabled the associated code) with the ribbon (Tm1 Tools) * used Application.FileDialog in place of GetOpenFolder function for the folder selection (for testi...
by jrizk
Thu Nov 10, 2016 10:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: The SSL break and TM1Top
Replies: 6
Views: 1883

Re: The SSL break and TM1Top

Hi,have you copied the new ssl files to your Tm1top\ssl folder?
by jrizk
Mon Feb 16, 2015 5:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Tools Issues And Discussions (Was *KEY_ERR Tracer)
Replies: 63
Views: 20455

Re: TM1 Tools Issues And Discussions (Was *KEY_ERR Tracer)

Using concept of TM1Tracer posted earlier I've attached the following add-in (for Excel 2007/10). There are 2 functions. DB Tracer - similar to the tracer in TM1 Tools - traces DB/DBRW/DBRA/DBSS/DBSW/DBSA formulas (also for active forms) - highlights if the formula is a read or send formula - highli...
by jrizk
Thu Jul 10, 2014 2:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic subset hierarchy sort ascendic hierarchy
Replies: 5
Views: 2814

Re: Dynamic subset hierarchy sort ascendic hierarchy

There is a way achieve the sort using ELPAR in this example - but it may not work well where the parent index is different for the children that sit under a particular hierarchy. In this case the parent index is the same (ie 1) for all the children - so the sort can be done in 3 steps. 1. Create att...
by jrizk
Wed Jul 09, 2014 1:32 am
Forum: Useful code, tips and tricks
Topic: Dimension Mapper
Replies: 2
Views: 3604

Dimension Mapper

I've attached a dimension mapper that list the cubes a dimension is associated with. As indicated in the forum there are other ways to map out the dimensions, this is another way that may be of interest. It's something I worked on a while ago and haven't done much with since, so caveats re using it ...
by jrizk
Fri May 31, 2013 11:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1API how to find out if cell is updatable?
Replies: 5
Views: 1674

Re: TM1API how to find out if cell is updatable?

Hi, You can use the API function TM1CubeCellWriteStatusGet - ie Declare Function TM1CubeCellWriteStatusGet Lib "tm1api.dll" (ByVal hPool As Long, ByVal hCube As Long, ByVal hArray As Long) As Long hArray will need to be populated with the handles to each of the dimension elements for the cell\value ...
by jrizk
Mon Apr 01, 2013 9:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 report flickering after upgraded from 9.0 to TM1 101.1
Replies: 7
Views: 1778

Re: TM1 report flickering after upgraded from 9.0 to TM1 10

1. What is the difference between TWEVRECALC1 and TM1RECALC1. There is no real difference between TMEVRECALC1 and TM1RECALC1. TMEVRECALC1 is the function that performs the recalc - TM1RECALC1 just calls TMEVRECALC1. I haven't investigated but I think TMEVRECALC1 is a function in one of the dll's th...
by jrizk
Thu Mar 28, 2013 11:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 report flickering after upgraded from 9.0 to TM1 101.1
Replies: 7
Views: 1778

Re: TM1 report flickering after upgraded from 9.0 to TM1 10

From 9.5 (I think) screen updating was turned on in the TM1RECALC and TM1RECALC1 calls in tm1p.xla. Application.ScreenUpdating = False has no effect as when the recalc calls are made ScreenUpdating is switched on - hence the screen flicker. Not sure about 10.1 but up to 9.5 TM1RECALC and TM1RECALC1 ...
by jrizk
Mon Aug 13, 2012 1:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance of TM1Recalc 9.5 vs 9.0 WTF?!?
Replies: 3
Views: 1117

Re: Performance of TM1Recalc 9.5 vs 9.0 WTF?!?

9.5 turns screen updating on, as such disabling screen updating in your macro has no effect. Use the following in your macro with screen updating off:

Application.Run ("TWEVRECALC1") instead of TM1RECALC1
Application.Run ("TWEVRECALC") instead of TM1RECALC
by jrizk
Tue Jul 26, 2011 4:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Express Installation
Replies: 2
Views: 805

Re: Cognos Express Installation

Hi. I've encountered this when CX had been installed and removed - seems to retain the content store settings. Try the following command line entries (might be worth making a backup of the server in case something goes terribly wrong). Once you run these commands you should be able to install CX wit...
by jrizk
Mon Jun 20, 2011 7:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM Cognos Xcelerator Server Freezes/Not responding
Replies: 4
Views: 1304

Re: IBM Cognos Xcelerator Server Freezes/Not responding

Hi. Have you checked for circular rules for that cube? I' I've experienced this freezing with a circular rule/calculation. Check your tm1server.log file as a start - if you see errors showing 'Stack Overflow' then a circular rule could be the problem. Apart from that the tm1server.log will give you ...