Search found 3 matches

by Jaspe
Sat Jun 23, 2012 8:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to write feeders when attribute is feeding a strintg
Replies: 2
Views: 2970

Re: How to write feeders when attribute is feeding a strintg

Hi !

In your case, maybe you can find a "logical" indicator to feed your element (turnover, price, or a technical indicator "feed" loaded by a process...) ?
Technically, you can feed from the elementattribute cube, but it's not performant (overfeed).
by Jaspe
Sat Jun 23, 2012 8:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help on TM1RptRow? (MDX)
Replies: 3
Views: 5369

Re: Help on TM1RptRow? (MDX)

Hi ! It depends if you want to filter on an element of a dimension or a value in the cube... For examle, if you want to filter on "China" in dimension "Country", you wan write {[Country].[China]} on cell B11. And in your fomula TM1RPTROW, you can write : =TM1RPTROW($B$12;"yo...
by Jaspe
Fri Jul 18, 2008 11:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Print dimension structure as tree
Replies: 3
Views: 4902

Re: Print dimension structure as tree

Hi ! First sorry for my bad english :) You can write a formula in Excel, without writing VBA code. In your spreadsheet, you have in the cell A1 : "MyServer:MyDimension" where MyServer is the name of your server and MyDimension your dimension name. In the cell A2, you can write this formula...