TM1 Forum

Hi Guys, I need some feeder assistance. In our P&L cube we have created a series of LTD years in the "Year" dimension which is fed by the following rule (for the 2012 LTD example): ['2012 LTD'] = ['Year':'2012'] + ['Year':'2011','Full Year'] + ['Year':'2010','Full Year'] + ['Year':'200...

Thanks Martin... In that case I will try the version dimension concept. Thanks..

Hi Guys, We are wanting to create a process where a GBU head is able to enter a project budget and allocate portions of the budgetted costs out to the appropriate departments (GSF's). We would then like the individual department heads to look at those figures and propose changes to those budget figu...

Thanks Guys... I have looked at all three solutions: 1) Create a seperate measure element and create a rule that makes values between 1 and -1 equal to zero.. Good solution, but this will result in my memory being used.. So I will keep this as a last resort 2) Using an Excel filter trigged by a VBA ...

Hi Guys, I have created an active form that is comprised of 4 row dimensions which are set to dynamically generate based on an MDX statement in TM1RPTROW for each of the 4 dimensions. I have also set zero suppression on the form. This works well, however there are some values which are less than 2 d...

Yes, thanks for that suggestion, its a shame the TM1RptRow functionality does not work for columns as well. I will see what I can do to get around that.

Thanks,
Damien

Hi Guys, Anyone had any experience with making a either a row or column dimension auto expand including all of the latest elements per the consolidation.. For example in our Customer dimension we have customer groups and one such group is other. In the P&L by customer report we list the customer...

Perfect! Thanks guys I am happy with this solution now! Really appreciate your help on this.

Hi David, The TM1Web option seems like a good option! I have just tested and it works well. However I am unable to find a way to pass in particular element to the object... For example the portal needs to pass in a project number and the browser should be able to pass in the project to the project d...

Hi Guys, I am wanting to display a particular cube view embeded into our corporate portal. I have looked at doing this with EV, however I am unable to find a way of passing the login credentials to the ActiveX object.. The only other way I can see of doing this is to use the API, however this would ...

Thats for the suggestion, however unfortunately for us we have different views depending on the type of person that is viewing the report, there are reports showing P&L by project and others that show P&L by customer and others that show a period comparison, etc. We have so many different co...

Hi Guys, For our end of month P&L reporting we create a large number of reports with different variations for many different users. We currently maintain these via spreadsheets in Perspectives. Each spreadsheet workbook contains many sheets for all of the different variations of the P&L. The...

Thanks Alan. Funny thing is that I am using Excel 2003 and the format saved should have been xls. And when I did a save as the file name was showing "Account.xdi" and the save as type was "Microsoft Office Excel Workbook (*.xls)". So I thought that this doesn't explain it. Howeve...

unfortunately this is a different issue. The issue in that thread was the spreadsheet was loading either blank or in a strange format. However my spreadsheet loads perfectly normal and all cells in the spreadsheet are correctly formatted. The problem is that when I click the button to save to tm1 it...

Yes the files are certainly in the same directory and I have tried completely recreating the xdi file via Perspectives. However it still will not allow me to Save the dimension back to TM1. Actually it funny enough worked this morning for one save and then went back to the same issue again. So I at ...

Hi Alan, Thanks for you quick reply! To answer your question, no there are no attribute formulas. In fact there are not attributes specified. I basically recreated the XDI file and simply added one element as follows for testing purposes: Cell E1 = "tm1serv:Sales Office" Cell A3 = "N&...

Hi Guys, In order to update many of our dimensions we use the Perspectives XDI file update on the TM1 toolbar in Excel. This allows us to change and add elements and then click a button that saves it back to TM1. This has been working fine over the past few years. However today I have attempted to m...

Perfect! Global variables will certainly do the trick! I have implemented this and it works perfectly.

Thanks,
Damien

Hi Guys, I am needing to create a recursive script/function in my TI drill process. I want to get all n levels for a particular consolidation and thought that I could create a recursive process that will take an element name as a arguement and return return a comma seperated string of all child elem...

Hi Armand,

I had exactly the same situation occur to me on Friday! TM1 crashed and afterwards my security was missing and was seeing this message in the logs "TM1.Security Security Upgrade performed on all processes" . Have you worked out what this message means?

Regards,
Damien