TM1 Forum

Good idea to open only a very small view, but this still takes 30 GB of RAM even though the cube usually does not take much more than 18 in production. But it works fine to simply unload and copy the cube shortly before the service is anyway restarted, so I will stick to that.

Thank you!
Holger

My goal is to copy "the" important cube from the production environment to both the test and development instances once a week. But unfortunately IT doesn't allow me to stop and restart the services from a TI routine, so I finally came up with the idea of unloading the cube, copying the pr...

Absolutely, yes. Actually that is what I thought the reason might probably be.

Thank you!
Holger

We have this analysis cube with a set of really complex rules (which come along without any feeders). Right after system start this cube requires some 2 GB in memory, but when users start browsing, memory used for calculations can quickly jump up to 35 or even 50 GB. MaximumViewSize is set to 5000, ...

also occurs in case one of the target dimension subsets contains no element.

Actually I was trying to find a way how to avoid the flags which we currently use, as setting them takes quite some performance and I would rather avoid that. Sounds to me like creating the view through MDX might do the job but I do not seem to have the time to find out how to do it exactly... Thank...

Brilliant, thank you, Steve! This may make me leave my good old 9.5.2 ways behind, looks really powerful... I could not find much syntax help yet, can anyone point me to something?

Regards
Holger

Probably there is actually no way of solving that by MDX, but maybe someone can think of a solution? I need a list of products and countries plus a key figure, could be revenue. The challenge is, we want to apply a benchmark to the query, like a list of products and countries where revenue "by ...

Ah, I tried a few more things and now it works: The trick is, you must not have different number strings after the cube name, that one must be the same all over, then it works because you can apparently only have one TM1RPTDATARNG?? range, not more.

Awesome, you definitely made my day, thanks a lot!

Tried that, thank you, but it did not help:

- On rebuild I got back the named range TM1RPTDATARNG10
- However, TM1RPTDATARNG15 was not created when using the other option
- Then I created TM1RPTDATARNG15 manually and started the rebuild, and Perspectives got stuck (looped)

Hi John, I did a lot in that field and had big benefits from using TM1RunTI together with Cubewise's hustle.exe. Google for that, it's easy and I love it. And: You may have to think about object locking. Especially if your processes update dimensions, instances will block each other so they will run...

Hi all, I have seven Active Forms on seven cubes all with the same simple dimensionality: }Clients, <Dimension n>, Measure. In all of these Active Forms, TM1RPTROW handles this one dimension which makes the difference between these cubes. I was thinking to have everything in just one sheet instead o...

Hi Evgeny, I cannot quite confirm this: 2. Hustle - TM1RunTI with inbuilt queuing mechanism, but has a limitation where threads must be ran under different users, as when user thread logs out and another thread tries to log back in (under the same user account) it creates a lock. Potentially a lot o...

Hi both, do not miss to take a look at RushTI (also from Cubewise). It works just like hustle.exe, but it uses only one connection for all the calls, so less overhead, e.g. less traffic in your LDAP connection. It just requires Python installed on the server plus a little library with TM1 specific p...

Well. After more fiddling around I got it to work after I made the call a parameter of cmd.exe and refrained from putting double quotes around the redirection target file... That is to say, for me it works quite simply like this: sCMD = 'D:\Hustle\Hustle.exe ' | sTaskFile | ' ' | NumberToString(p_nT...

Dear all, since a few weeks we have been using hustle.exe with great success. However, I did not manage yet to redirect the output to a text file, can someone help? This is how I tried it. Hustle executes, but sTaskLogFile is not created: sCMD = '"D:\Hustle\Hustle.exe" "' | sTaskFile ...

RuleLoadFromFile(Cube, TextFile) could be even quicker if it is just about reinstating the previously deleted rules

Dear all,

we are about to move from Version 10.2.2 to 11.1.0.30. While testing, I found that our models seem to take around 25% more time to load in V11 than in V10.

Can anyone confirm that? What do you experience? Any recommendations maybe?

Thank you
Holger

Hi, I believe the core of it is, whenever you have a rule in a cube that includes the }Cubes dimension, and this rule throws an error, }ElementAttribute Cubes will not be created, and there will be no error message to make you aware. You will have to rely on the forum and on helpful guys like you, l...

I discussed the matter with our IT department. Looks like we will use a separate Outlook mailbox which encrypts all outgoing email by default, so it seems to be solved.