TM1 Forum

Thanks Edward. I think the sequential type thing is all I need, as I can just do the last 5 years easy enough. Thing is, I tried that and couldn't get it to work. Where in the two lines do I put the year? The data is in the 'Asia Sales' cube and has a feeder to our global cube as follows; ['Local', ...

Hi all. I wish to feed some data from one cube to another but would like it to only feed data up to the year 2016 and not beyond. The data is in the 'Asia Sales' and has a feeder to our global cube as follows; ['Local', 'Total Customers excl INTCO']=>DB('GlobalSales', 'Asia', !Year, !Month, !Version...

Thanks for the responses guys.

Douard, not sure why I never even tried that one, so thanks. Works fine.

A couple of interesting options to consider from Wim and Ajay. Thanks for your help.

Hi all. Is there an option to add a comment line in the Query box on the data source page in turbo integrator. We have many processes with SQL queries inside this query box and they don't work if there are any comment lines starting with -- which is perfectly fine in SQL. I understand you can use # ...

Ok thanks, that's what I thought, was just holding out for hope otherwise.

Hi all.

Quick question.

Is it possible to load a backed up .cub file (with a new name) into a running TM1. Or is the only way to shutdown and restart TM1?

Thanks is advance


David

Thanks babytiger.

I don't need to do anything with PTLCON so the 'stet' function works a treat.

Thanks.

Hi all. We have a rule in one of our cubes that converts our local currency data into AUD and AUDYE based on some exchange rates in another cube as shown below. As you can probably tell this rule sets it to do it automatically for all of the elements in the “Company” dimension. I would like to amend...

Hi all. Just completed my first attempt for an MDX expression in TM1. After a bit of reading/searching on here, I got it working. Basically I wanted to select all items in the product dimension, in consolidation 0400 that have 01-R or 02-R or 03-R in the element. I have used the union function to do...

Hi all. I wanted to change a users password in our Cognos Express 10.2.1.1 IF2 installation and so I went into Cognos Express Manager as administrator and selected the user, clicked on edit and then changed their password, clicked on ok and got an error message stating; An error has occurred EXP-ERR...

CX Xcelerator 10.2.1.1 with Interim Fix 2 now enables client to be installed with Office 2013. Tried it on a brand new Surface Pro 3 and seems to work fine.

http://www-01.ibm.com/support/docview.w ... wg21678220