TM1 Forum

Hey guys, where is the setting to display more viewable columns in Contributor? I'm in 10.1.

Thx

Hello all,

I have deployed a contributor app and the client wants breakback functionality turned off. He would also like scrolling as opposed to paging.

Does anyone specifically know how to do this? I could not find this in the options/settings.

I have unloaded a cube and now my feeders dont work. I have restarted the server and still my aggregations will not calculate. I'm fairly certain my feeders are correct since I checked them all before i did the unload. I am in 10.1/Architect. Thanks.

What is the % sign used for in TM1 rules? I see this used in code I inherited. It doesn't look like it is for division as front and back slashes are used.

Thanks.

No.

I have deployed a Contributor application and have noticed that the dimension where the approval hierarchy resides does not let me choose subsets within the View. All of the other dimensions in the rows/columns have a drop-down box that lets me use subsets within the view. How can I use subsets in V...

Thanks Oliver. How would I initialise? I'm not sure what that means.

When a budgeting row has all zeros for the month and we enter a number in the Total column, Contributor complains about spreading a zero (something like that) and doesn’t make the total spread to the months. If there are numbers in the months, it works fine and spreads the number proportionally as e...

What is the full custom number format for making zero values invisible in TM1?

Hi,

I have a list of zero level elements from a TM1 dim in Excel in column A. In column B, I would like to return the direct parent of the element in column A. What is the function to d this???

Thanks.

Ok I'm going to give that a try using TI. I'm still not sure how the user will be prompted to enter the three bits of information. All I need the user to return to TM1 is

Company (Element)
Date (attr of Company)
Individual/Name (attr of Company)

I have a TM1 input sheet in Excel and I would like to add a new element along with 2 attributes for the newly added element. So essentially, I would like to prompt the user for 3 pieces of information 1. Company Name 2. Date 3. Individual's Name The company name is an element and the date and indivi...

Here is the VBA code for anyone who wants to use it. I leveraged the fact that when the SUBMNM function clears, it puts the cursor in the immediate cell to the right, my SUBNM statement is actually in cell D2! Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address(False, Fals...

Wow! Thanks for the quick feedback. If I decide to keep the subnm function in the sheet, how would I add that onchange event to a particular cell without tying it to an object in Excel?

Thanks again

I would like to add a vba driven control box with the available dimension elements to Excel. What is the code to do this??? The subnm function seems inefficient to me. I'd rather select from a drop down box and add a calculate line in the code so when I make the selection the form calculates immedia...

To be clear I started with a date dimension that collected the date of input from an Excel user sheet. For reporting purposes I want to roll this into months so I can analyze trends. I was thinking of creating some type of look up cube but I like the idea of adding the monthly/yearly rollups in my e...

I have a user input form where I collect input dates by day (5/12/2011), and for reporting purposes, I would like to consolidate these dates and put them them into a monthly format that looks like May-2011. I do not need to report by day, just by month. What would be the best way to do this??? Much ...

Hello, I am trying to reference a dimension attribute on a spreadsheet and the formula doesn't come through. =DBRA("r_best_practice",$A7,"Details") A7 is the dimension element, the dimension is r_best_practice and the attribute is Details. The formula doesn't return an error, jus...

Hello all,

If I use TM1 native security (authentication mode 1) for Contributor users, how would the user change their password?

Thanks,