Search found 2058 matches

by Wim Gielis
Wed Jul 17, 2019 9:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PowerShell issue
Replies: 5
Views: 347

Re: PowerShell issue

By now it works, but I will play around with your examples.
by Wim Gielis
Tue Jul 16, 2019 10:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Cube data in CSV file, with all Months as columns
Replies: 31
Views: 4736

Re: Export Cube data in CSV file, with all Months as columns

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...
by Wim Gielis
Tue Jul 16, 2019 1:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PowerShell issue
Replies: 5
Views: 347

Re: PowerShell issue

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 ?
by Wim Gielis
Tue Jul 16, 2019 1:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Button does not give RUN Process option
Replies: 5
Views: 289

Re: PAW Button does not give RUN Process option

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.
by Wim Gielis
Tue Jul 16, 2019 12:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PowerShell issue
Replies: 5
Views: 347

Re: PowerShell issue

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 =...
by Wim Gielis
Mon Jul 15, 2019 11:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PowerShell issue
Replies: 5
Views: 347

PowerShell issue

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...
by Wim Gielis
Sun Jul 14, 2019 8:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Application built on PAL 2.0.6 and want to use it in tm1 10.2.2
Replies: 1
Views: 197

Re: Application built on PAL 2.0.6 and want to use it in tm1 10.2.2

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.
by Wim Gielis
Fri Jul 12, 2019 9:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sandboxes in Dynamic Reports?
Replies: 8
Views: 210

Re: Sandboxes in Dynamic Reports?

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...
by Wim Gielis
Mon Jul 08, 2019 1:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM PA Local 2.0.7: TM1 Web started showing -0
Replies: 2
Views: 338

Re: IBM PA Local 2.0.7: TM1 Web started showing -0

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.
by Wim Gielis
Fri Jul 05, 2019 2:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder statement cleanup
Replies: 6
Views: 161

Re: Feeder statement cleanup

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.
by Wim Gielis
Thu Jul 04, 2019 9:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder statement cleanup
Replies: 6
Views: 161

Re: Feeder statement cleanup

Or you could use the TI function DeleteAllPersistentFeeders:
https://www.tm1forum.com/viewtopic.php?t=5294#p22566
by Wim Gielis
Wed Jul 03, 2019 6:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: difference between prolog, metadata, data, epilog
Replies: 13
Views: 8892

Re: difference between prolog, metadata, data, epilog

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.
by Wim Gielis
Wed Jul 03, 2019 6:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Flag value in consolidatedavg function
Replies: 8
Views: 1130

Re: Flag value in consolidatedavg function

First test without undefvals like me.
by Wim Gielis
Wed Jul 03, 2019 7:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Guide
Replies: 5
Views: 226

Re: PAW Guide

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.
by Wim Gielis
Tue Jul 02, 2019 4:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Guide
Replies: 5
Views: 226

Re: PAW Guide

There is something on the internet called Google. You might want to use it.
https://www.ibm.com/support/knowledgece ... lcome.html
by Wim Gielis
Tue Jul 02, 2019 8:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Day of Week in TI
Replies: 13
Views: 3414

Re: Day of Week in TI

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 ?
by Wim Gielis
Mon Jul 01, 2019 11:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use subsets in DBRW
Replies: 6
Views: 446

Re: Use subsets in DBRW

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...
by Wim Gielis
Sun Jun 30, 2019 5:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Flag value in consolidatedavg function
Replies: 8
Views: 1130

Re: Flag value in consolidatedavg function

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