TM1 Forum

Double post

Hello,

You could fill up an attribute with the length of the string, probably with TI but a rule is possible too. After that you can query on the attribute. I haven’t used it in Workspace until now.

Bakkone wrote: ↑

Wed Mar 20, 2019 5:18 pm

I do love how this shows that IBM ships stuff without even testing on a computer with a different regional setting tho. Very nice...

That is not the first time: https://www.tm1forum.com/viewtopic.php?f=3&t=14417

For example, you would use CubeUnload (or the equivalent in the user interface) to remove all feeders from a cube. Useful during debugging. Technical requirement: all views must be closed in Architect / Perspectives. This is not a tool for limiting RAM consumption in a TM1 model. For that, you have ...

Hello jrizk, Thank your for confirming that this isn't going to work. But... it did work in previous versions of Windows. Anyways. What are the different options I still have ? - Someone here on the forum, or within my organisation, the customer's organisation, the Internet, ... knows a way to do it...

Hi, If Excel identity is interactive, it's my username (wimgieli) If Excel identity is the launching user, it's the username with which the task is created (tm1burstservice) I now have the following: - everyone logged off, Excel identity set as the user wimigeli and the scheduled task running under ...

Hi Paul, I think that I tested about each permutation of all the options: - users - highest privileges - 'Run whether user is logged on or not' - Task compatibility 2008/2000-2003... - Excel without vbscript before - Logged on or not - UNC paths - ... Still no joy, at now 2 different customers. But ...

Hello Paul, I am not using a TI for now, but a scheduled task. The testing that I am currently doing in my newest topic : - If I schedule the task to run at a certain point in time, so scheduled, and I am logged on: it works fine. - If I schedule the task and I log off (and everyone else is logged o...

Hello Yuri Thanks. I should have added the following too: - This topic is a continuation of my earlier topic: https://www.tm1forum.com/viewtopic.php?f=3&t=14157 It's the same challenge and the same problem. Last year I thought it worked, but it does not. I forgot to update that topic, I did this now...

Hello,

I still cannot get it to work. See for an updated topic:
https://www.tm1forum.com/viewtopic.php?f=3&t=14157

There is also a Word document including things to check and try.

Wim

Thanks, I will try to set up a variant without TI and without the vbscript part in the middle. Focus on the Excel and scheduled task part only.

Hello all, My case is the following. I have a Perspectives report with DBRW and SUBNM and I would like to: - generate a version of the report with hard values - email the report to a number of recipients - this should be done in an automated way No manipulations need to happen in the report, only ge...

In PA there are control objects for subsets and views. I mean subsets for a dimension and views for a cube. For rules you might want to look at the }StatsForRules control cube. Or just open up the .rux text files.

I think you might be getting mixed up with ItemReject. AFAIK LogOutput should not cause any minor error status (in fact would be pretty bad if it did). I will pursue using a global variable instead of the return code... Yes because the software... will not do this, changing the return code, as was ...

jcr55 wrote: ↑

Fri Mar 08, 2019 2:28 pm

According to the TI manual, using the logoutput command should cause the return code to be 5, but the return code is zero. I think it's a bug. Was just trying to see if anyone else has experience with this situation.

Can you send a link please ?

Hi, Bypassing the issue at hand for a while, why don't you use a global variable ? As in (in the calling process): NumericGlobalVariable( 'vFound' ); vFound = 0; ExecuteProcess( '...' ); If( vFound <> 0 ); # ... EndIf; and in the called process: NumericGlobalVariable( 'vFound' ); vFound = ...; Regar...

PavoGa wrote: ↑

Wed Mar 06, 2019 12:16 pm

Seriously, thanks. I am going to visit your MDX page again! Good

Thanks ! Happy reading.

The corresponding file in the }Externals folder ?

Hi Not sure I understand why you would not use easier functions that TM1TupleSize and Item. Straight from my MDX page: Consolidations without children: {Filter( TM1FilterByLevel( TM1SubsetAll([test]), 1), ISLEAF( [test].CurrentMember ))} {Filter( TM1FilterByLevel( TM1SubsetAll([test]), 1), [test].Cu...

If it's Cognos Express you might need to review the security regarding clients and groups.