TM1 Forum

Hi As Lotsaram says, consolidation is the way to do this. Rules are in general 100 times slower than consolidation. However, be careful how you arrange the rollups. In the past I would have done this using a chaining method like this. 1st Jan YTD = 1st Jan 2nd Jan YTD = 1st Jan YTD + 2nd Jan 3rd Jan...

Hi Your profile shows that you are still on 10.2.2. If so, then I would consider upgrading to Planning Analytics. You can then use PAX which will give faster performance than Perspectives. I say this because if you are about to start writing VBA you might end up having to re-write it again when you ...

Hi Deleting users is a bad idea for many reasons. You will potentially lose Private Views and Subsets stored against those users. If there is anything else stored against the user it will also be lost, such as TM1 Web settings, Locks on Dimension Elements, etc. If the user does not already exist, th...

Hi I know what you mean. Users simply deleting DBRW formula is one issue. The worst case is where they start cutting and pasting and you end up with a DBRW alongside one row column combination that is actually pointing at a completely different row and column and it is therefore showing the wrong va...

Hi You only quoted part of my answer. If you read my full answer then that will answer your question. "There is unfortunately a known bug when exporting text from an MDX View which IBM are going to fix soon. However, your case is not quite the same as you are using a native view, albeit with a ...

Hi Peter The fact that the security is resetting itself at login almost certainly means that it is something to do with CAM since that is the point at which CAM will copy Group membership from the security store, typically Windows Active Directory, in to TM1 Security Groups. If you open up }ClientGr...

Hi Are you outputting text values rather than numerics? I am guessing that you are since you don't have any conversion on the asciioutput There is unfortunately a known bug when exporting text from an MDX View which IBM are going to fix soon. However, your case is not quite the same as you are using...

Hi Are you talking about PAX? We encountered a similar issue whereby even a Native View has to have a column dimension. A View that only has rows, and context elements won't work. Does your view with filtered MDX on the rows have at least one dimension on the columns? We have encountered similar iss...

Hi It looks like Ken's problem was specific to the Dimension Editor, but from PavoGa's description it looks like a crash from a TI process. Is that the case? We have also had some crashes with the Dimension Editor but fortunately only in Non-Production environments, as we don't really use the Dimens...

Hi You have solved your own problem. Put the code in the Prolog or MetaData and it will work. However, I would advise you against starting dimensions with }. It can become difficult to differentiate these from real Control Dimensions. You run the risk that IBM might use this dimension name at some p...

@Lotsaram What I was getting at is that from what I have seen TI functions such as DimensionElementInsert operate on the Main Hierarchy, or the Default Hierarchy, what most of us think of as the traditional dimension, but of course, the idea of a traditional dimension goes as soon as you introduce a...

Hi When using Real Named Hierarchies, any of the Dimension TI Functions actually apply to the Main aka Default Hierarchy of the Dimension - What we traditionally think of as the Dimension. So I would guess that what you are seeing is that DimensionDeleteAllElements is clearing all elements from the ...

Hi

Just an update on this. We have now got data coming in the correct columns. However, the problem is now that any text attribute values are being read in as numbers instead of as text. IBM have re-produced this and are investigating.

Regards

Paul Simon

Hi Wim

Thanks for the offer but we should have our own test server with 2.0.8 up in a week or so.

I have referred the issue over to IBM.

Regards

Paul Simon

Hi Lotsaram

Maybe it is because we are on 2.0.5 and you are on a later version, but that is not what is happening. It is reading the view with columns across, and not reading it as though it was a ViewExtract.

Regards

Paul Simon

Hi Lotsaram The problem with having the hierarchy or ElementAttributes on columns is that you then have a variable number of columns coming in to the TI. I want to create something re-usuable so it can be used against any dimension hierarchy all of which can have different numbers of attributes. So ...

Hi I want to read all attribute values from the consolidated members of a Named Hierarchy. I understand that the only way to create a source view for a TI process that references Named Hierarchies in one or more dimensions is to use an MDX View. I can generate the MDX easily enough to show this in P...

Hi Jed In Server Explorer, go to the Applications folders, right click on a folder, and select Convert Excel files to Open XML format. In theory this converts old xls to xlsx, but in practice it does other things as well that might cure your issue. It does operate on xlsx files even though the docum...

Hi Jed We have Charts that are working in TM1 Web on Planning Analytics 2.0.5. We upgraded from 10.1.1 so that was an even more radical upgrade than from 10.2. You might want to try running the workbook upgrade utility again. We found that it does not always work. We also found that it does more tha...

Hi One thing you could try is renaming the TM1PRibbon.xlam file to add a .DISABLED to the end and then restart. If you get an Add Ins Menu showing in the Ribbon, then check to see if you can access TM1 from that. At our site we gave up trying to use the Ribbon years ago and only use this method now,...