TM1 Forum

Generally speaking can TM1 support a cube with 1 Terabyte of data? I've heard not but wanted some other opinions on this.

I elected to use the ELPAR command and seems to work fine. So, where my worksheet originally contained only description of child I inserted two rows and ELPAR calls parent and grandparent descriptions. In first of the newly inserted cell entered =ELPAR("blueprint:Study",C14,1) where bluepr...

Hello, I'm using Perspective (TM1 9.5.2) and working with a dimension that has several levels to it. What I would like to do is have it such that once the child is selected what is displayed back is Parent / Child description. For example, my project is for clinical trials. In a study dimension I ha...

Got it. First enabled to have TM1 automatically running as service under .\administrator. Then using Cognosnamespace added Administrator to TM1 security and then modified tm1_contribution.atom and TM1_en.properties files with proper references. Now when in Biz Insight I can drag in Applications or V...

I've found that since I've been using TM1 I have a tendency to over complicate things. I do have a version DIM and it holds Budget, Actuals, Forecast. I could simply add Quota and give it a whirl. But, in getting to my sales budget I have units sold * price by product, sales exec, account, region. Q...

Hello, I have a model for sales revenue where Sales Exec, Region, Products, Accounts, Version and Time are the DIMS with revenue, qty sold, margin are measures. I want to measure this activity against a pre-determined quota (ie, $1M) and wondering if anyone has approached this before. The quota is b...

Can a TM1 input form have something like a button a user hits that captures current date and time. Have a TI process utilize the =Now() ability of Excel? So a cube would have a list of clients and the agent would hit a button and then TM1 would store info on the date and time when the client was con...

Have configured my environment so that I can drag TM1 content into business insight workspace. While I can access my cubes I do not have sandboxing. TM1 web, architech, perspective all have Sandboxing. Looked at Capability Assignments but everything is already set to "Grant". Any ideas?

Hello, I'm building a cube for employee headcount and a measure within an EmployeeMeasures dimension will be Position. We have about 50 different positions so rather than have people free form into the cell (and have incorrect entries) I want to have a pick list for my users. With so many different ...

Does anybody have experience working with TM1 and CAFE? Coming off of CAFE/Powerplay configuration and hoping that TM1/CAFE solution is much better.

Hello, I have been successfully building out a TM1 model with contributor. When I go to log into TM1 Contributor I receive the msg below; "Could not logon to any available servers with the provided credentials." I think problem relates to changing server name in TM1s.cfg file. With this ch...

Is it possible to add a new dimension into an existing cube?

Thanks Alan. I figured out my problem while I was looking at my different levels. I corrected by implementing StateAbbr+Segment (NY-01, NY-02...) as the segment values. Still fairly new to TM1 so I expect that eventually I'll get to hand crafting my own code.

I have a rather simple csv file that I'm bringing into TM1 via TI. The file has 5 fields; AccountID, State, Segment, AccountNumber, AccountName. AccountID is the Element. State and Segment are Consolidations and AccountNumber and AccountName are Attributes/Alias for AccountID. The basic premise is t...

Main elemnt is Employee ID. Employee Name is an alias. Once I went through and addressed the duplicated names my issue was resolved. Thanks!

Hello, I've been provided with a CSV file to upload into TM1. The file is a list of sales executives and sales managers. All ficticious. Each record (row) has a colomn with an ID, Full name, Email, Sales Manager and Sales Manager Email. Looking to upload with hierarchy where sales executives are con...

Hello, I have a time dimension with the following structure; Year - Qtr - Months. The other years have the same level of detail as does 2011. I'd like to now have YTD rollup's. Is it best practice to have the YTD's within each year? And would the "YTD's" be at the same level as the Qtr's? ...

That was it. I need rules within the target cube and feeders in the source cubes. All working nicely now. Thanks.

Hoping to pick your collective brains. I'm building a sales plan and currently in the model I have two primary cubes; MD_Sales_Plan and MD_Disposable_Sales_Revenue. MD_Sales_Plan.jpg MD_Disposable_Sales_Revenue.jpg I want to now take the revenue numbers from these two cubes and bring them over to a ...

That appears to have addressed the problem. Added in margin % and that's fine as well. Thanks.