Page 1 of 1
TM1RPTROW Subset
Posted: Sat Jul 07, 2012 3:02 pm
by winsonlee
=TM1RPTROW($B$27, "cxmd:Version","SubsetName")
E27 = "SubsetName"
=TM1RPTROW($B$27, "cxmd:Version",E27)
Has anyone try before referencing a subset using a cell ? E27 data is from a cube. It is a control cube where user will determine what subset to use.
Re: TM1RPTROW Subset
Posted: Sat Jul 07, 2012 3:06 pm
by declanr
Yes. it should work perfectly well but from memory I think you will have trouble if E27 is a dbrw whereas a dbr works ok.
That is just based on memory though so I may be mixing up a few different thoughts.
Re: TM1RPTROW Subset
Posted: Sat Jul 07, 2012 3:18 pm
by winsonlee
Yeap.. you are right. It works now. I would thought as long as there is value in that cell that should work. Never have realised that dbr and dbrw would make a difference.
Re: TM1RPTROW Subset
Posted: Sat Jul 07, 2012 3:30 pm
by declanr
I believe it is all to do with the order in which TM1 executes the various calculations in sheets.
It would be nice if IBM (or someone from the user community who actually has any free time) would make a document explaining TM1 formulas in the old Mathematics BODMAS way... but in the mean time; trial and error has to suffice.
Re: TM1RPTROW Subset
Posted: Tue Jul 10, 2012 2:03 am
by EvgenyT
DRBW -This function works the same as the DBR function, with one major difference; DBRW reduces network traffic and may improve performance on wide area networks. In worksheets with a large number of TM1 functions, DBRW forces TM1 to execute functions in "bundles" rather than individually.
What it means: Basically DBRW doesn't per-calculate(or execute) right away, which helps to improve performance. On the other hand DBR does, but if you have a large report and use DBR it will slow down your performance.
So, as suggested above use DBR to retrieve the value. Even though you can see the value in the cell, excel does not recognize it until its rebuild.
Cheers