TM1 Forum

Is your TM1 base report an ActiveForm report? And on the base report, do you have any or lots of conditional formatting rules? Base on experience, with the newer version of Excel, TM1 activeforms does not handle conditional formatting well. I am using Excel 2010 and TM19.5.2. It has a combination o...

Just confirming that you have been able to walk through the macro step by step and it works? (i.e. Hitting F8 though the complete sub?) We had issues with users changing our XLSM & XLSX files back to XLS which would crash our VBA, not sure if that is your issue? It's working perfectly for the f...

Crashing does seem unlikely but with the filename being a dynamic part of the code it isn't just the case that it's trying to use special characters etc in the name and therefore can't save it? No problem in saving for the first three reports. There are no special characters in saving file name. Al...

Not monitored RAM. But I don't see any thing wrong with the code since it's working for first three reports. Dim i As Integer i = 4 Do While (Range("B" & i).Value <> "") Range("B" & i).Select ' selects the report name and pastes into the open template Selection....

No not the print report function. There is no issue with running the template manually. Through a macro a TM1 based Excel report is opened and refreshed and then hard coded and closed. This is run on a loop. I think it crashed because the Clipboard is full or TM1 retrieving data to RAM and RAM is fu...

Hi, I am running about 100 Excel based TM1 reports using a macro and it crashes every time after it runs 3 reports. I get the following message "Microsoft Excel has stopped Workings" How can I improve the performance? Is it RAM is the issue or problem with the template? Any suggestions wel...

Thanks for reminding the correct method.

Hi,
I am trying to back out certain transactions using the transaction log and there were no changes. I can retrieve the transactions using the transaction log and select them but can't back out.

Nothing happens when I click the back out button


regards,

Abi

Thanks for the reply.

Hi,
I would like to get all the n level elements of a consolidated element which has multiple levels. Now ELCOMP works when we have only one level.
What to do If we have multiple levels? I like to use a worksheet function.

regards,

Abi

jacktuckerman wrote:Yes, you can use the DB function to reference the cube that you are writing a rule for, it's not exclusive to referencing other cubes.

Thanks I will try this and come back.

Hi, I need a rule that is after calculating the average at the consolidation level need assign that value to N level elements. Say Group average=10 and also I want that 10 to beassigned to leaf level elements for group average. ['Group Average']=C:['Kgs']\['Metres']; say this is 10 ['Group Average'...

Assuming your cube has 4 dims dim1, dim2, dim3, dim4 and the measures dim has elements: Kgs, metres, GroupAverage And assuming you want to average on a consolidated element 'Total of dim3' on dim3, your rule would look like this. your Clevels rules should be fine, and your N level rule would go lik...

Hi, I need a rule that is after calculating the average at the consolidation level need assign that value to N level elements. Say Group average=10 and also I want that 10 to beassigned to leaf level elements for group average. ['Group Average']=C:['Kgs']\['Metres']; say this is 10 ['Group Average']...

Hi, I am exporting a TM1 cube using asciioutput function. Say I have 5 dimensions, I was able to export these 5 dimension into records (Each dimension one instance of an element) in text or CSV file. One of the dimension is measures where elements will be assgined values. Now When I export only one...

Hi, I am exporting a TM1 cube using asciioutput function. Say I have 5 dimensions, I was able to export these 5 dimension into records (Each dimension one instance of an element) in text or CSV file. One of the dimension is measures where elements will be assgined values. Now When I export only one ...

Is there is a way to get only leaf level n elements of the Subset displayed in the Active Form?. The subset I am using has a consolidated element. If your dimension is called e.g. Business_Unit and the consolidation is e.g. All Business Units then the TM1RPTROW formula should read: =TM1RptRow(Repor...

Hi, I am using the following function in my Active Form. Is there is a way to get only leaf level n elements of the Subset displayed in the Active Form?. The subset I am using has a consolidated element. TM1RptRow(ReportView, Dimension, Subset, SubsetElements, Alias, ExpandAbove,MDXStatement, Indent...

Did you try the following MDX Statement? If all you want to do is filter one element from Customer Dim, then try the MDX below {[Customer].[20001744]} Thanks all. This worked. But this one worked in expression window but not working in Excel,bit strange! {TM1FILTERBYPATTERN({TM1FILTERBYLEVEL( { TM1...

Hi I am testing a query to retrieve an element of a dimension but failing to compile. Can any one see the error in the statment? "{FILTER( {TM1FILTERBYLEVEL( { TM1SubsetAll([Customer] ) } ,0 ) } ,[Customer].[20001744] ) }" Customer is dimension and 20001744 is one of the leaf level element...