TM1 Forum

I got it right!!!! SKIPCHECK; ['Forecast','Split']=C:['Forecast','Unspecified_Warehouse','Unspecified_Week','Unspecified_Division','Unspecified_Channel','Marketing']/ ## these will be the ones that are consolidated - set them to unspecified ['FCP Forecast','All Warehouses','Weeks','All Divisions','A...

I have, and I tried it out in Excel, but it didn't work exactly as I wanted.
And they want it as "Idiot Proof" as possible, so the user should just input his forecast and TM1 has to do the rest from there. I suggested to them to do it in a view but they want it all in Excel.

Hi all, I'm still new to the rules aspect of TM1, so excuse my ignorance.. I need some help with the logic and writing of rules. I'm busy working on a forecast model, where a tool is used to generate a forecast, and then pulled into Tm1. Then using Excel the users input their view of the forecast, t...

Hi George,

I did make use of these MDX functions to create dynamic subsets.
MDX = '{TM1FILTERBYLEVEL({TM1DRILLDOWNMEMBER( {[Items].[All Items]}, ALL, RECURSIVE )},0)}';

Do you know if it is possible so sort it in the same was as the hierarchy that I'm exporting?

Hi, I was wondering if anyone had a solution to my problem. I'm exporting data from a view through the TI to a text file, that i need to import into Forecast Pro. This works fine and the process is exporting all the data I want. What I want to know is there a way to sort the data that it is being ex...