TM1 Forum

I can't believe I only just found this out. This goes straight into the playbook. +1 from me too

Cheers Wim, I didn't know that either!

Hi Naufal and welcome, Could you go to : Start Menu >> IBM Cognos >> IBM Cognos Configuration And make sure that the 'IBM Cognos', 'TM1 Admin Server' have a little green triangle on their Icon? Can you also check under the part that says 'Data Access/ TM1Server' that you also have a little green tri...

Hi Paul, Yes you can choose multiple cubes and it will pick up all the stuff required. Its history It was originally written in PERL as a script but it became too cumbersome (one cube at a time) so I re-wrote it in VBA: It was very handy for us as originally, we had three completely different system...

Cheers MCE, thats fantastic

There's always something new to learn on here, and seeing how other people tackle the problems in completely different ways.

I'm going to give that a go on our test server.

Jules

PS

If you have these '}' cubes visible, you can open them up as normal cubes just by double clicking on them.

This makes them far easier to examine when dealing with lots of groups etc.

Jules

Hi Akbiswal, Probably the easiest way to is from the beginning with native TM1 under architect: First of all goto 'View' >> 'Display Control Objects' and tick it.(this will show you all the extra cubes that TM1 uses to do its magic) 1.Add A User Right Click Server >> Security >> Clients/ Groups Add ...

Hi Tom, I agree with you, but maybe Analytics123 is using this for this is as a starting point for a far more complicated system, e.g. some kind of rolling period. We just don't know, as the its only a query regarding EXPAND function. I just think that maybe he should be given the benefit of the dou...

Hi all, Yep that code looks fine to me too. As Declan says, I think it is a typo eg missing 'g', or your variable is declared in the 'Variables', which are not visible to the Prologue tab Can you manually put: vrollinggroup1='Jan 2017'; vrollinggroup2='Feb 2017'; vrollinggroup3='Mar 2017'; Upto 12 a...

Hi Wim, Yes its a standard tree view from the Microsoft add ins, and I did have quite a few issues with it, when I upgraded excel. :D It was originally written before we even had ribbons in excel. (2003 I think). You can tell how old it is by the icons, I think they were from the Applix days! (ahh, ...

Cheers Guys, I'm gonna leave the VBA alone, and have a dabble with something more current like, the Python / REST stuff / Java etc. I've not had a chance to do anything with the new interfaces, just the old TM1 API from years ago. Thanks MCE, wow! Thats really cool, all the servers I've ever used ha...

Hi All, During my early days in TM1 I got really fed up with trying to copy a cube from one server to another usually so i could develop a cube without taking the entire server across :D It used to be Bring it up, oops missed an element attributes cube. Shut it down Insert }element attributes cube. ...

Hi krithika331, I've had very similar issues at a clients, it was an install problem for us. What we did to fix it was to A)Uninstall the TM1 application (making sure that you have all your TM1 models saved somewhere safe). B)We then made sure that the TM1 folder was removed completely from the C:\P...

Dear Wim, It's humble that you help others, we all do. Not only during the day, also in the evening and during weekends. Agreed. But we should also encourage people not feel worried to post their issues. However, your negative comments addressing me personally in this topic are very unprofessional a...

Dear Wim, Many thanks to your insight and your knowledge and your off topic points, all duly noted. I would query a few points you raised though. You Quote : Always funny, people like you. You registered 3 days ago, so please make comments only once you get to know the environment a little bit. And ...

Hi Mithun, Here is a example that doesn't need any extra measures as its all calculated in the TI. Its a bit more complicated than the previous one, but Wim was having issues with understanding the logic of using a view of the target cube to iterate through all the cells and process them in turn. So...

Hi Wim, Thats quite easy to explain, its for simplicity for mithun to follow. We are using a TI view instead of loops, whilst also dealing with : Mithuns blank in 'Start Date' meaning from the first period of the dimension and Mithuns blank in 'End date' being the end of the dimension This can also ...

In TI it's easier as Declain says, here is a starter for 10 that should put you on the right track, i've used bedrock to create the view that its going to use, Based upon the dimension we discussed earlier. Capture10.jpg Can be achieved quite simply by using the following TI process Capture11.jpg An...

So the proof of the pudding is Capture6.PNG Where you can see the zero is unfed, which means that its not going to feed any other cubes and waste CPU. When we suppress zeros we get. Capture9.PNG Which is still correct. If you still want to do it in TI give me a shout, it will be quite easy to go thr...

Have you considered doing it in rules, that way you dont have to run a TI after every change. Here are the cubes i've created based upon yours. Capture7.PNG And here are the rules for each of the cubes. Capture4.PNG Capture3.PNG It may look a bit complicated, but its really good and makes TM1 faster...

Hi Mithun, Im guessing you want to turn this Capture1.PNG Into this? Capture2.PNG Have you considered doing it in TM1 rules? I think the main thing you need is give your time dimension a number attribute that it can use for period checking rather strings see below for an example Capture8.PNG