TM1 Forum

Hi

The oldest version I have is 9.1. In 9.1 it works OK eg NUMBR('AA') returns 0 as you would expect. As a work around in your version you could try concatenating a '0' to the front of the number so there is always something numeric in the string, eg NUMBR( '0' | vMyInput )

Regards


Paul Simon

Similar experience here. 9.4.1 FP2 with HF16 is noticeably faster than 9.1 in the Cube Viewer and Excel. However, as ever I am sure that it depends on the particular cube. Still not sure whether it is faster than 9.0 though. One annoying issue we have is that Edit Formula insists on prefixing the ce...

Hi, I would avoid consolidatechildren. Is there any reason why you cannot use consolidation in the dimension to give you YTD, as per the previous posts? If the issue is that you have balances rather than movement figures, then a lookup cube that gives the last element in each consol could be what yo...

Steve I wouldn't be too concerned that you didn't figure this one out yourself. This is actually a bit of an odd case. From what I can remember feedstrings was originally introduced to allow rule derived string values to show up in zero suppressed views. However, a while back I realised that you cou...

Steve Let me see if I understand your requirements correctly. You want the user to be able to enter into a cube that has measures representing an amount and a text measure saying where the value should go. You then feed from the amount using the text measure to direct the feeder to the appropriate s...

Sudheen Glad I could help a bit. Unfortunately I have never used Cognos BI Reporting with TM1 so I can't help any further. Hopefully someone else, can but you are on fairly new ground. Are you using Cognos Express, or just connecting to TM1 using Cognos Reporting Suite? It seems that the problem is ...

Sudheen Sorry I couldn't read your attachment, so this reply might not be correct. I don't know what format the attachment was in, but it didn't seem to be a word document. I would guess that you just need to turn off Aliases in the subset editor to get the country names to show instead of the numbe...

Martin Personally I always ensure that dimensions join up to a single top level element, largely because of past experience with many OLEDB for OLAP tools which require this, but also because it gives the user a single point to drill down from, and this makes it easier for them to access the differe...

Mike This only happens when the missing element is in the Title area of the view. It is not a problem if it is in the row or column area. The view will still open but you won't see data. If your View uses an unnamed subset in the title area, then as per the previous post there is nothing that you ca...

Raj

Yes - Sometimes the optimal order in terms of smallest cube size is not necessarily the optimal order in terms of response time, however, most of the time it is. It is worth carrying out a few tests on a test box with the main reports that are used.

Regards


Paul Simon

Hi I suspect the reason for your problem is that the dimension is part of a cube and therefore cannot be destroyed. Instead I would try using DimensionDeleteAllElements in the Prolog, and then rebuilding the dimension in the MetaData tab of the same process. As the dimension is never destroyed you w...

Hi

Try contacting IBM Support to get Hot Fix 16. I know that this was issued to cure a major client problem in 9.4 MR1 FP2 but I can't remember if it was your problem.

Please also post your version of Excel and Operating System as that may have some bearing on it.


Regards


Paul Simon

John If you have a license for Executive Viewer, then using that, it is possible to mark a Title Dimension as Invisible (Off-Spread in their terms). For the Off-Spread dimensions, you need to select a single element, so you will still need to have an All elements consolidated element in your dimensi...

Hi Is this literally what you are typing? DBSW(12,Statuscube, Month ,Text) This implies that you are sending numeric data in to a text cell. I am not clear as to whether Statuscube is a literal value or a Range Name. I would expect your formula to be more like =DBSS("12","MyServer:Sta...

Hi

Sorry - I didn't notice that the elements that you are referencing are numerics so you should be OK with the [ ].

Regards


Paul Simon

Hi

The S: is part of the solution. The other limitation with String Rules is that you cannot use the [ ] notation on the right hand side. You need to use the DB( ) notation, even though you are referencing the same cube.

Regards


Paul Simon

John If you are still having problems, come back to me, but from memory I think that the file that you are missing is tm1dasrv.dll You need three files registered for the tm1xl.ocx to work (This is the In-Spreadsheet Browser by the way) tm1dasrv.dll tm1prc.dll tm1xl.ocx To register them, drag when o...

Hi By validate parameters I mean something along the lines of IF( DIMIX('MyDim',pMyParam)= 0 ) ; ItemReject('Invalid Param') ; ENDIF ; Assuming that the parameter value should exist in a Dim on your cube. By the way ItemReject works fine on the Prolog. It writes a message to the TM1ProcessError log ...

Hi I think that part of the problem with the example in your Word Doc, is that you are running a SQL Procedure to insert values in the Data Source tab. However, that tab is intended to be a select query to return values to use in the Variables, MetaData, and Data tabs. The approach I would take woul...

My guess (or wild theory) is that you might be loading using multiple processors, which means that you can get feeding more than once since when processing in parallel, TM1 cannot determine whether a cell has already been fed. There may be a step that then tries to merge things together so that dupl...