Search found 179 matches

by PavoGa
Mon Apr 23, 2018 11:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Return codes and error messages
Replies: 2
Views: 89

Re: Return codes and error messages

Perhaps a useful tip, use a counter dimension (1...n) and add attributes for it to describe the error codes so they can be written to control cubes, output in messages, emails, etc.
by PavoGa
Wed Apr 18, 2018 3:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Direct version of dimension updates
Replies: 5
Views: 245

Re: Direct version of dimension updates

While I cannot recall where exactly, some documentation stated that using the DIRECT functions does not allow TM1 to store the dimension in an "optimized" manner. Whatever that means, I do not know and have not explored it further. I use the DIRECT functions, but if making a significant number of ch...
by PavoGa
Wed Apr 18, 2018 12:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Query on SwapAliasWithPrincipalName
Replies: 2
Views: 167

Re: Query on SwapAliasWithPrincipalName

If you want to swap aliases based on subsets of elements, create an alias for swapping purposes only. Create your subset, update the alias only for your subset members, the swap the alias. The elements with unpopulated aliases will retain their original name as you probably know. I think you can use...
by PavoGa
Tue Apr 17, 2018 2:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process slow
Replies: 2
Views: 206

Re: TI Process slow

Sometimes the user interface is misleading as to what is really going on, e.g. seeming to be hanging up on the Epilog procedure. Your post does not mention if you have confirmed the observed performance in the server log itself by reviewing the time that Process 1 actually executes. Based on what el...
by PavoGa
Mon Apr 16, 2018 5:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX dependent drop down lists
Replies: 2
Views: 152

Re: PAX dependent drop down lists

Yes. You will need a mapping cube with the relationships between the departments and accounts, and an MDX subset on the Expense Accounts that uses the entry from the first (department) dropdown. You can get REALLY fancy and have the Expense Accounts subset even have previously selected accounts drop...
by PavoGa
Mon Apr 16, 2018 5:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting data from view to file consuming memory
Replies: 13
Views: 525

Re: Exporting data from view to file consuming memory

I think this is my problem here... All cells in the cube are calculated (and unfortunately not fed - the model is too complicated to be fed correctly but as far as I understand even exporting correctly fed cells won't solve the issue) so all memory is cunsumed by calculations and therefore not rele...
by PavoGa
Thu Apr 12, 2018 6:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting data from view to file consuming memory
Replies: 13
Views: 525

Re: Exporting data from view to file consuming memory

I think this is my problem here... All cells in the cube are calculated (and unfortunately not fed - the model is too complicated to be fed correctly but as far as I understand even exporting correctly fed cells won't solve the issue) so all memory is cunsumed by calculations and therefore not rele...
by PavoGa
Wed Apr 11, 2018 7:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Interesting findings in rules
Replies: 4
Views: 515

Re: Interesting findings in rules

Duncan P wrote:
Sat Apr 07, 2018 6:56 pm
customer in the south of England who were using this feature of the rule parser to write extensive well formatted documentation of their rules.
This race of beings of which you speak, of what heretofore unknown lands in the south of England whence they came? :lol:
by PavoGa
Fri Mar 23, 2018 4:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Date held as number but formatted as date
Replies: 5
Views: 671

Re: Date held as number but formatted as date

Mark, There are several discussions on the board about this and I think Alan has an FAQ or Useful Tips discussion on date management between TM1 and Excel, so there is no use in repeating on this thread. :) http://www.tm1forum.com/viewtopic.php?f=3&t=9679&hilit=%2A21916%2A Hope the link provides som...
by PavoGa
Thu Mar 22, 2018 4:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX filter on cube values for different dimension
Replies: 6
Views: 551

Re: MDX filter on cube values for different dimension

Noticed this again this morning and realised that PavoGa was on to something, the below will work and be more efficient that generate if your dimensions are large. {Filter( {[dim2].members}, [cub1].( StrToMember ( "[dim1].[" + [dim2].[attr_dim1_elm_name] + "]" ),[cub1_measure].[value])>1 )} Thanks,...
by PavoGa
Fri Mar 16, 2018 7:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX filter on cube values for different dimension
Replies: 6
Views: 551

Re: MDX filter on cube values for different dimension

You'll have to use StrToMember to do this. I've got code for it, but will have to get it to you a little later if no one else provides it.

Ty
by PavoGa
Wed Mar 14, 2018 8:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View Size issue
Replies: 11
Views: 580

Re: View Size issue

To be clear, are you getting your error when the view is processing in the METADATA/DATA tabs or are you getting the error when you try to open it in cube viewer? Btw, ViewSuppressZeroesSet is the same as using both ViewColumnSuppressZeroesSet + ViewRowSuppressZeroesSet. :) The error appears on the...
by PavoGa
Wed Mar 14, 2018 4:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View Size issue
Replies: 11
Views: 580

Re: View Size issue

One thing to remember is that the ViewExtract... functions do not have the same effect as the ViewRowSuppressZeroesSet, ViewColumnSuppressZeroesSet and ViewSuppressZeroesSet. The first are for views used as data sources and I do not think they have any effect on a datasourceview you then try to ope...
by PavoGa
Wed Mar 14, 2018 2:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing dimension attribute values based on filter selection
Replies: 15
Views: 788

Re: Changing dimension attribute values based on filter selection

Unless you are needing the labels to vary because of reporting requirements by the users, Orlando's solution should do it. However, if you really do need the labels to change, another solution is to use an MDX subset on the Month dimension. Add elements to your month dimension for each year/month c...
by PavoGa
Wed Mar 14, 2018 2:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Improve TI Processing Time
Replies: 8
Views: 687

Re: Improve TI Processing Time

Are you writing values to cells that are used as sources (on the LHS) for feeders? If so, it can be slow because it is feeding. Another thing to check is if you are using dynamic MDX subsets in your data source. Although problems with that were supposed to go away by 10.2, I noticed occasions where ...
by PavoGa
Wed Mar 14, 2018 1:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View Size issue
Replies: 11
Views: 580

Re: View Size issue

One thing to remember is that the ViewExtract... functions do not have the same effect as the ViewRowSuppressZeroesSet, ViewColumnSuppressZeroesSet and ViewSuppressZeroesSet. The first are for views used as data sources and I do not think they have any effect on a datasourceview you then try to open...
by PavoGa
Mon Mar 12, 2018 3:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing dimension attribute values based on filter selection
Replies: 15
Views: 788

Re: Changing dimension attribute values based on filter selection

Unless you are needing the labels to vary because of reporting requirements by the users, Orlando's solution should do it. However, if you really do need the labels to change, another solution is to use an MDX subset on the Month dimension. Add elements to your month dimension for each year/month co...
by PavoGa
Wed Mar 07, 2018 8:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tool to detect overfeeding?
Replies: 16
Views: 6166

Re: Tool to detect overfeeding?

The only way I know of is, once a cell (or block of cells) is identified as overfed, review the feeders that are feeding that cube. A quick hint: look for feeders that are feeding a consolidation. If feeding to and from the same consolidation, it is a shortcut for feeding leaf cells. HOWEVER, if one...
by PavoGa
Tue Mar 06, 2018 9:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Chore Schedule Information
Replies: 10
Views: 766

Re: TM1 Chore Schedule Information

Make sure you turn logging off in the }Stats cubes or get of lot of useless log files...

And, Andy, how about those b-ball Vols?! SEC regular season champions.

Ty
by PavoGa
Tue Feb 20, 2018 1:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Subsettoset help
Replies: 3
Views: 265

Re: TM1Subsettoset help

GENERATE can have some performance issues because it is running queries for each member of the set in the filter. In your solution, you're running GENERATE twice, plus the intersect. I believe that logically, the second set of code below accomplishes the same thing in a single pass through the nLeve...