TM1 Forum

Also keep in mind when you are using a dynamic subset in excel/websheet that you will need to have the dynamic subset calculate before the DBRW does. I received a Key*Error when creating a websheet in perspectives and the solution was the dynamic subset dimension needed to be represented as a DBR. D...

TM1 10.2 I currently have a TI process that creates view zLoadDriverDetail in my Driver cube. Something strange is occuring to the view when it is created. If i comment out the last two lines which are assigning subsets to the rows of this view results come back with no error. If I remove the commen...

Thanks tomok! I will work on writing a conditional feeder to only populate the combinations enter in the input section. Again I appreciate it.

Perfect! This really helps me narrow down my issue. I have copied my feeders from the rules editor below. PAY NON COM and PAY COM are consolidate elements in my account dimension that have about 15-20 elements each in them. I am feeding the consecutive years in the salary input view so they can popu...

Using TM1 10.2 with Excel 2010. I am building a new salary cube in TM1 10.2. I enter my information for Name, Class, Title, Status, Start Month, Review Month and GL Account. Everything works just great. Then when I enter PY Starting Salary and hit tab or enter my screen takes between 60-90 seconds t...

Hierarchy Total Assets Liabilities & Equity Net Profit I can adjust the weight of these consolidated levels by opening the dimension editor right click and go to element properties. The Dimension Element Properties screen allows me to adjsut the weight at the top or consolidated level. I am tryi...

I am working in 10.2 Architect trying to create a TI process to update my account dimension. The current structure has Assets, Liabilities, and Net Profit rolling up to the top level of the hierarchy Total. My users have requested an alternative hierarchy that only includes balance sheet activity. S...

I could be going about this the wrong way. So my initial thought was that I could build one process the create the dimension. Here is the code I wanted to use. #Add Level Four Length=LONG(TRIM(RSLEVELCODE)); If(Length=2); DimensionElementInsert('CostCenter','',TRIM(RSCOSTCENTER)|'-'|TRIM(RSCOMPANY),...

Thanks Jim!

I moved the code to attribute code to the data tab. The unfortuanate part is it appears I would need one process for each level the the cost center dimension. Is their anyway around that? Its not a big deal was just looking to have less processes to run. Thank again!

TM1 10.2.0 Excel 2010 I have written the code below to add the fourth level onto my cost center or hierarchy dimension. When I run all the code on the metadata tab I get the following error. Data Source Line (1) Error:Metadata procedure line (16):Element "CF-10" not found in dimension 'Cos...

Win 7 64 bit Excel 2010 I have attached a document that outlines step by step the issue I am having. The short of it is that I appear to be having issues with the commit button when preforming that same task two different ways. I might need to log a bug with IBM just wanted to check the forum to see...

Win 7 64 bit Excel 2010 Insight 10.2.1 Today i was testing the 'Get Data' option in Insight. I connected to a relational database and used the query builder in attempts to open a table. When i clicked the refresh button to view the data in the table to see the general format i received the attached ...

I agree this is a complicated way. As far as the percentage split is concerned. How would that work for a 4-4-5 split if the user can ideantify Start and End Month. The denominator is a moving target. For Example: If Nov has 4 weeks, Dec had 4 weeks, Jan has 5 weeks and Feb has 4 weeks and so on. If...

Currently on Win XP, TM1 10.1, and Excel 2007 I am constructing an Initiatives Cube for a forecast model that is in development. As you can see from the print screen the manual spread method works just fine. It takes the Amount Change for Period Input divided by the (End Month minus the Start Month)...

Using Win 7 on the new TM1 10.2 I started playing with the new 10.2 today and tried to import my old approval hierarchy via performance modeler from 10.1.1 in 10.2. I received the following error "The approval hierarchy has members missing below the top level member." when attempting to va...

TM1 10.1 Window XP Excel 2007 Architect TI Process I currently have a TI process in place to copy budget information from an active version that rules run on to a static version. I am using the ViewCreate function to generate the view to copy my data from. The issue I am running into is the variable...

Good point. We tested a customer change in our dev environment and it appeared to work just fine. If a customer changed territories the data loaded in the new month created a new "TerritoryCustomer" field which is what I would expect. Thanks for the input.

We recently completed a cube re-design on this cube. We combined the Territory and Customer dimensions which had 33,714 elements and 377,634 elements into one TerritoryCustomer dimension with 570,642 elements. This significantly reduced the load time of the cube from about 30 seconds to about 17-18 ...

Twin Cities Minnesota Cognos User Group has been started. I missed the first one however I hear they are planning on every 6 months or so. Word is the next will be in November 2013. I have attached a flyer from the last meeting.

I have used Cognos BI in the past and really like the product. Queries and report are easy to design and advances reports take some time to get used to the coding format but its easy once you get a feel for it. Currently my company uses TM1 and Microstrategies. We have been on Microstrategies 7 for ...