=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.
TM1RPTROW Subset
-
declanr
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TM1RPTROW Subset
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.
That is just based on memory though so I may be mixing up a few different thoughts.
Declan Rodger
-
winsonlee
- Regular Participant
- Posts: 180
- Joined: Thu Jul 01, 2010 3:06 am
- OLAP Product: Cognos Express
- Version: 9.5
- Excel Version: 2007
- Location: Melbourne, Australia
Re: TM1RPTROW Subset
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.
-
declanr
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TM1RPTROW Subset
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.
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.
Declan Rodger
-
EvgenyT
- Community Contributor
- Posts: 324
- Joined: Mon Jul 02, 2012 9:39 pm
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: 2016
- Location: Sydney, Australia
Re: TM1RPTROW Subset
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
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