Search found 48 matches

by jrizk
Wed Apr 03, 2019 10:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Moving to new server
Replies: 2
Views: 555

Re: Moving to new server

Try using TextCrawler - it will do a bulk find and replace. You can download the free version:

https://www.digitalvolcano.co.uk/tcdownloads.html
by jrizk
Sat Mar 30, 2019 1:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VBA API Changes for Excel 64 bit?
Replies: 3
Views: 1162

Re: VBA API Changes for Excel 64 bit?

If you download TM1Tools which was modified for 64bit you should be able to follow the changes required for your models. https://www.tm1forum.com/viewtopic.php?f=3&t=11593 You have to add PtrSafe/LongPtr to the API declarations as well as LongPtr to the functions and dims that reference the declarat...
by jrizk
Mon Mar 18, 2019 3:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 report bursting
Replies: 15
Views: 3316

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: 805

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: 2748

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: 805

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: 20
Views: 3105

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: 1573

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: 2521

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: 2521

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: 1704

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: 9754

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: 2915

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: 25197

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: 3668

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: 5223

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: 2405

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: 2666

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: 2666

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: 1608

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