TM1 Forum

By now it works, but I will play around with your examples.

Look at the Prolog tab and the view as the data source of the process. You have a view defined on a cube with 9 dimensions. Where in the csv output file do we see the dimensions that are not month, type, BU ? Your AsciiOutput contains too little information (columns) and therefore if you have multip...

Drg wrote: ↑

Tue Jul 16, 2019 6:50 am

but it also brings a little pain with quotes and double quotes

Indeed, don't you close the double quotes in the code ?

mnasra wrote: ↑

Tue Jul 16, 2019 1:48 pm

THANK You all. YES, you are right. I am at version 36

Certainly with PAW where versions change every couple of weeks.

Allright, I got it. Again, double quotes, single quotes, spaces, backticks misery ... Here is the full code you need in TI. Individual text files are called: 'ERROR - nameoftheprocess_20190716 012345.txt' (for today) cLog_Folder = GetProcessErrorFileDirectory; cAll_Errors = 'output.csv'; cFullname =...

Hello all, I'm trying to achieve the following. In several load processes I have a line of AsciiOutput in case an error occurs. In the TM1 logging directory I get files with a certain filename pattern, involving the name of the offending process and a timestamp. The file itself contains 1 line, a de...

What version do you use ?

I don't think you will get many replies. For one thing, you started 2 topics earlier, and did not bother to reply to the feedback that was given to you. That kind of behavior does not induce voluntary people here to offer assistance again.

All good and valid points Garry. The Menu button on the keyboard (left of the bottom right Control on most keyboards) is hijacked by PAx - no more Ctrl C / Menu / S / V to do a copy/paste special values, etc so you have to continually keep moving your hand to your mouse whenever you need to simulate...

If you are interested, please refer to:
http://www.wimgielis.com/tm1_subsetcrea ... set_EN.htm

We have seen this as well. It's also to do with some automatic formatting.
Have a look at:
Tm1_64\webapps\tm1web\WEB-INF\configuration\features.json
to the "NewDataFormatter" property.

grusty wrote: ↑

Fri Jul 05, 2019 12:56 am

I've since deleted about 90% of all feeder statements in the model

Which may or may not reflect 90% of your fed cells.
I mean that a very short statement like:

['Actual'] => ['Forecast 1+11'];

may lead to a big number of fed cells.

But I hear you, you removed a LOT of fed cells.

Or you could use the TI function DeleteAllPersistentFeeders:
https://www.tm1forum.com/viewtopic.php?t=5294#p22566

For example in the prolog tab you can add an element for allocations. In the Data tab you can process data on the element and in the Epilog tab you cannot delete the element. Therefore you need to have the Prolog tab of a second process to do it.

First test without undefvals like me.

No problem. Hopefully someone wants to share their own material, or point you to a step by step guide on the internet that did not come up when you used google.

There is something on the internet called Google. You might want to use it.
https://www.ibm.com/support/knowledgece ... lcome.html

Bakkone wrote: ↑

Tue Jul 02, 2019 7:53 am

I got stuck on trying to figure out the location of the tm1s.cfg.

Are you an admin person of that TM1 model, or what is your role with respect to TM1 ?

Hi Steve, Anything related to ad hoc analysis, or related to user choices, leading to elements / consolidations of which the sum needs to be shown. A regular Excel pivot table can show the sum of the visible elements, so why not TM1 in an easy way ? For more structural consolidations, I would create...

MarenC wrote: ↑

Sat Jun 29, 2019 12:09 pm

I was hoping flag 1 would make ELAvg 15 and flag 2 would make it 30.

Hello Maren,

For me it works fine. PAL 2.0.7