TM1 Forum

Firstly, thank you all for your kind replies, much appreciated. that looks like a resonable solution that doesnt require much work to maintain it. but would like to further emphasize that using dimix, the sequence of element created in the dimension is important. eg if Jun is created subsequently al...

Good morning/afternoon TM1 gurus, I'm currently working on a sales project that requires a moving average rule. Dimensions are "customer" , "Location" , "Measures" , "Year" such as 2011,2012,2013 and "day" with the 365 days of the year that rolls up ...

Thank you guys for the answers, I did move the Tm1p8.Lic file to C:\WINDOWS but nothing really changed so I have pasted it under C:\Documents and Settings\All Users\Application Data\Applix\TM1 and it's all good now. I would think all apps can normally read C:\WINDOWS\ but I guess there maybe some ki...

Hi everyone, I have just upgraded from excel 2003 to excel 2007 and since then I have been having a bit of unusual issues that I hope you could give me a hint on how to solve the problems. 1- I am an administrator and I have double checked the security settings in the Cognos express admin console an...

Thank you for your posts, as mentioned by lotsaram I think I’ll go for the active form solution, however I’ll explore rmackenzie’s suggestion and see how I go, thank you again for the handy tips and any other suggestions are more than welcome.

Good morning/afternoon TM1 gurus, I am working with dynamic subsets and MDX in active forms, so far I’ve created a simple report to show the top 10 debtors of an AR cube sorted by the total overdue amount and excluding an specific customer called “Legal”. { EXCEPT( {ORDER( { TOPCOUNT( { [Customer].[...

Hi Martin,

Problem solved… Issue was that when setting up the cube, the security of 2 elements in the measures dimension wasn’t set up (for some reason), it should have though…

Appreciate the prompt reply and your help.

Cheers

Hi TM1 gurus, I’m having an issue with a cube say AR Cube, I have just created it a few days ago (using TM1 v9.5) and I, as admin, can see all data/values. I set up a default public view and users can see all dimensions and all elements however when browsing the cube regardless on what they select i...