TM1 Forum

Since you are using the Excel add-in, the action button parameter references can also point to a cell in the workbook, instead of a hard-coded value. The cell holding the parameter value can be derived by manual input, any relevant formula in Excel, or it can reference a cube value via a DBRW formul...

The Web Server (IBM Planning Analytics Spreadsheet Services) is optional. If you are going to publish all your reports either in PAW or PAFE then you don't need TM1Web.

Hi, I have 10 cubes, each with a common dimension but varying in the number of dimensions from 4 to 12. When a new element is added to the common dimension, I want to assign a value of 1 to a specific measure element (which is available in all the measure dimensions). Is there a function (no rule, ...

Wim Gielis, I'm having trouble understanding your answer. I believe I may not have explained my issue clearly. I'm seeking a clear explanation and a solution to the problem with the measures in the test cube. My Test cube has two measures: one is named' S Value' and is a string, and the other is na...

Hello All, What are the different method to input the data into tm1 Cube? I'm particularly interested in understanding if it's possible to input data into a TM1 Cube directly from an Excel file(not .csv and not .cma) using a process. Has anyone attempted this? Thanks!!! TM1 cannot natively read the...

Hi! I have a user who has permissions to processes Y, but not to a cube named X. The Y process has a cellputs('text','X cube','dim1','dim2') command that it can run, so it can essentially write a cube that it doesn't have rights to. Is that OK? How could this be avoided? Thanks in advance! Process ...

Hi, I try to build an nice looking input dialog. So I want (Excel-Style) an input cell and a very small row below to have a delimiter for the input fields below. Unfortunately all settings belonging to row height in the pattern rows are ignored. The height of the first row in the data area is used ...

Considering that is a Revelwood tool, and not something from IBM, you should probably contact them.

Does anyone have any experience with running Mirantis Container Runtime (MCR) with PAW? MCR is the new name for Docker since it was purchased by MIrantis. Does it just plug in seamlessly with PAW? PAW comes with the Docker install as part of the Powershell script for installing PAW but you can't run...

Hi Everyone, A quick explanation of what I want to do: I have a cube of investments with a dimension "invart1", which I want to summarize in a separate cube. I understand I need to use a process to do so, is that correct? Or is there al although a way with a rule? I just want to start in ...

Hello, Got good news from me. The tm1rawstore error no longer occurs on our production servers. I discovered on our backup server, with the exception of DFS Management which I had previously disabled, there was a task scheduler that copied files from the production server to the backup server still...

Hi there I have a Dynamic Report with multiple nested rows, and 2 Measure columns. For illustrative purposes, example as follows: Row Dim1 Row Dim2 Row Dim3 Col Measure 1 (e.g. Sales Value) Col Measure 2 (e.g. Description) What I am looking for is a way for the report to run and suppress zeros base...

What account does the TM1 service run under? In order to use Windows Authentication for your SQL server connections in TM1 the TM1 service must run under that account. It cannot run under the local system account. Also, the ODBC setup on the TM1 server must be set to use Windows Authentication. If y...

Jorge, the bottom line is this has been the behavior in TM1 since pretty much when the tool was first created. It was initially built for accounting-related apps and this is not normally an issue for budgeting and planning. If you just explain to your users that this is a limitation in the tool, tha...

chewza wrote: ↑Tue Jun 14, 2022 12:15 pm Hi Guys

Do you know of a way of establishing when a chore might have been activated/de-acticated?

Many thx
Chris

That event should be recorded in the tm1server.log file.

This looks to be what I would expect based on past experience. I am assuming that Actual and Budget are in one dimension, the time periods are in another and the accounts are in yet another. Since you've brought both April YTD and Full Year into the view, both Budget and Actual, as well as a subset ...

I don't understand the need to feed the Standard Hours measure in the Labor cube. The only issue you'll encounter if you don't feed it would be possible zero-suppression of that measure whenever someone was browsing the Labor cube. It's really easy to get around that problems with a few reporting tr...

If the type and number of cores is the same I would suspect hard drive issues, i.e., SAN. Are you sure your drive space is in the same region as your server? Even in cube to cube copies TM1 is going to utilize drive space in the memory temp file. As to Architect, at least from an Admin standpoint, c...

Although TM1 can be used for a number of things, the true sweet spot for the tool is planning and forecasting (FP&A) and other accounting/financial purposes. In that vein, in only makes sense that a developer that has a keen grasp on the business purpose for FP&A and knows accounting princip...

Has anyone tried and gotten to work doing an automated server restart on an IBM Cloud TM1 server using a Net Start and Net Stop command? I've tried working on it and I can get the command to execute without any error messages but nothing happens. I'm theorizing that it isn't working either because 1...