TM1 Forum

Hi Tomok,

Thanks for that. I did get the same advise from someone else.
Another option I have heard is to index the actual column that joins the two tables.

Will try both and see which one works best.

Cheers NIels

Hi Steve, Thanks for your suggestions. I found out what is causing it, well almost. I def know it is something with the SQL. As far as I am concerned it is a very basic SQL statement with one left join. It works fine in SQL server but TM1 doesnt like it at all! Now the hard part is why TM1 doesnt li...

Hi Tomok,

Thank you for your reply.
As mentioned in the post before we use SQL server as far as I understand that topic you were referring to is all about Oracle?

Hi David, Thanks for that. However, it did confuse me a bit. 'What I think you are doing is a 2-way summary: JAN-2011 is a total of the days in January Cat1 (in the source cube) is a total of SKUs.' That is spot on but I am not sure about the linking part of all SKU's. we have about 800k sku's so lo...

Hi Alan, Thanks again for your quick response, I really appreciate you taking the time to try to help me (and possibly others)! I thought of that and I did chuck the SQL in SQL server. The result: returning lines after 9 seconds and completely run after 30 seconds. Now I am not a SQL expert by all m...

Hi Alan, Thanks again for your words of wisdom! The ChoreQuit does work now, so thanks. And I understand what you mean with itemreject and itemskip ( I guess I was just hoping this would be the issue....) However, I don't think it is going to help me much as it seems there is something fundamentally...

Alan, I think you are right, I do have an infinite loop in there. This is what I have: # Plant sPlant = NumberToString(vPlant_No); # skip missing Plants IF(DIMIX('Plant,sPlant)=0); #ItemSkip; ENDIF; It seems I forgot the 'then' part of my if-statement as the itemskip is commented out?! Does this loo...

Hi Alan, Great feedback, thanks! And great thread about Time/Date as well. Did I mention I am new to TI processes..... I obviously am and just trying to get my head around it. Have to ignore what it is in Excel and read the Reference Guide better! OK...I understand the prolog vs. metadata/data tab i...

Hi, I am trying to put some kind of 'safety' code into one of our overnight chores as it tends to hang and this affects other chores that are scheduled to run after that. I am looking into as to why this particular chores does this but until then I want to kill the chorse if it hasn't finished runni...

Hi, I have the following problem with creating rules for cubes with different dimensions: I have one cube that uses Date dimension which is build up by days and the other one uses year and month (so no days in there). Also I have a product dimension in one cube which is build up by sku's and the oth...

Hi Gregor, Thanks for your reply. Unfortunately I do need a total for all those days so your solutions might not work then. Having a sum in Excel can work obviously but it does mean I need to have the formulas on a different worksheet. The date interval can be any combination of two dates in the las...

Hi Gregor, Thanks heaps for that. I am not familiar with mdx so I have to look into this but it looks good! So just to be clear: everywhere you use 'days' that is the name of the dimension right? And I need to add the excel date as an attribute to all the values in the 'days' dimension so when the u...

Hi Steve, Thank you for you reply. At the moment I am using a TI process to generate a date range which the user defined in the active form. A user can run a daily sales report based on two days they enter and the TI process creates a consolidation will all the dates in between the chosen dates. It ...

Hi, When I use the 'SUBNM' function in an active form and double click on it, it takes me to the subset editor but there is no roll up functionality. I want the users to change their own date range and roll up the results. At the moment the date range is set up by a TI process which is working ok, t...