Search found 286 matches

by ascheevel
Fri Nov 10, 2017 6:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot insert new element in element attribute dimension
Replies: 7
Views: 5189

Re: Cannot insert new element in element attribute dimension

You can right-click the dimension in server explorer, select Edit Element Attributes, and then Edit->Create New Attribute or you can use DimensionAttrInsert in a TI process.
by ascheevel
Wed Oct 18, 2017 3:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX expession
Replies: 3
Views: 2443

Re: MDX expession

UNION should work
by ascheevel
Thu Oct 12, 2017 12:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: replace a subset value in db function
Replies: 4
Views: 3045

Re: replace a subset value in db function

Consolidation called 'Prior Month' would work too.
by ascheevel
Tue Oct 10, 2017 12:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to re-use the data from source twice?
Replies: 3
Views: 2469

Re: How to re-use the data from source twice?

I agree with qml that there might be a better solution that doesn't involve spinning through the datasource twice, but if you're set on it, you could always run the process twice and use a parameter and if statement to segregate operations between first and second run. You can call the second run fr...
by ascheevel
Tue Oct 10, 2017 5:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help to create TI process to copy data
Replies: 5
Views: 4556

Re: Need help to create TI process to copy data

To expand on what Drg said, you can use a WHILE loop to apply one value to multiple target elements, periods in this case. If I'm understanding your question right, you're trying to take a value from one month in the current year, say October, and write that value to all the months in the next year,...
by ascheevel
Fri Mar 08, 2013 3:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 trend forecasting
Replies: 6
Views: 5895

Re: TM1 trend forecasting

I'm curious to see what other people have to say, but I've been leery about doing anything more complicated than a rolling average when it comes to trending in TM1. For forecasted sales volume, we do interface with Logility Demand Planning, using TM1 to gather some of the inputs and manual forecast ...