Search found 42 matches

by jrizk
Wed Jul 25, 2018 12:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automating TM1 in VBA
Replies: 6
Views: 625

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 ...
by jrizk
Thu Jun 02, 2011 1:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Nested IF statements in TI
Replies: 10
Views: 5615

Re: Nested IF statements in TI

To simply your script you could try:

vDateUsedLen = LONG(vDate) - 5;
vDateUsed=SUBST(vDate,1,vDateUsedLen);
by jrizk
Mon May 30, 2011 11:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Recalculating in Excel changes the way rules work
Replies: 6
Views: 1479

Re: Recalculating in Excel changes the way rules work

Hi. Is there rebuilding of any dimensions in the cube happening before you recalculate - I've experienced this when a dimension was updated etc. - and values being stored in memory. Try running a macro with the line Application.Run("M_CLEAR") and see if it helps. Could be something else but worth tr...
by jrizk
Mon May 30, 2011 11:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to see the no.of dimensions in cube
Replies: 11
Views: 4589

Re: How to see the no.of dimensions in cube

Could be wrong but sounds like the number of dimensions each cube contains is what's trying to be retrieved. Tabdim would work if you keep going with the index number until you hit a blank for the dimension name.
by jrizk
Mon May 30, 2011 11:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to see the no.of dimensions in cube
Replies: 11
Views: 4589

Re: How to see the no.of dimensions in cube

Hi. Are you trying to achieve something like what's shown in the attached - but instead of listing the dimensions and the associated cubes you want to list the cubes only wanting to see how many dimensions each cube contains. There are a few ways to do this. One through the API (as shown in the atta...