Hi All
Has anyone tried the DBS function on Planning Analytics for Excel yet?
I first had a problem with the DBS and DBSW functions automatically changing to a DBRW when using a custom report. You couldn't copy the function or click and drag because once you entered the formula and clicked off the cell, it would change to a DBRW!
I changed it to a snapshot, but now I can't get the DBS functions to calculate en-masse. For them to work, each cell needs to be "edited" - ie you need to click in and out of the formula for it to work.
I've tried the buttons on the PA bar, "Refresh Sheet", "Refresh book", "Rebuild sheet", "rebuild book", "recreate book"...
Has anyone else experienced this?
And does anyone have a work around??
Thank you
Planning Analytics - PAX DBS function
-
- Posts: 19
- Joined: Wed Aug 10, 2016 1:20 pm
- OLAP Product: Tm1
- Version: 10.2.2
- Excel Version: Prof Plus 2013
- Steve Rowe
- Site Admin
- Posts: 2417
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Planning Analytics - PAX DBS function
I've not tested directly but from what you say it seems likely that DBS is not yet supported in PAx (or it is, but is bugged which amounts to the same).
Your likely workarounds are probably reverting to perspectives or flat file and TI load.
It might be worth playing with the calculation mode. PAx is expecting to be in calculation automatic mode but I'd try it both ways.
Your likely workarounds are probably reverting to perspectives or flat file and TI load.
It might be worth playing with the calculation mode. PAx is expecting to be in calculation automatic mode but I'd try it both ways.
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- Posts: 1
- Joined: Fri Oct 14, 2016 2:44 pm
- OLAP Product: TM1
- Version: 8.5-11
- Excel Version: xp-16
Re: Planning Analytics - PAX DBS function
formula changing into a different formula shouldn't happen, are you running perspectives at the same time as PAx in excel?
if you change it to a snapshot, i wouldn't expect it to 'refresh' at all. (regardless of the ribbon buttons clicked)
only issues i am aware of with dbs* in PAx are
a) if any writeback fails for a given cube's dbs's, all the writebacks for that cube's dbs's will fail (it is treated atomically)
and
b) the error response of a dbs function is #value, instead of in some cases (ready only, etc) returning the current value.
if you change it to a snapshot, i wouldn't expect it to 'refresh' at all. (regardless of the ribbon buttons clicked)
only issues i am aware of with dbs* in PAx are
a) if any writeback fails for a given cube's dbs's, all the writebacks for that cube's dbs's will fail (it is treated atomically)
and
b) the error response of a dbs function is #value, instead of in some cases (ready only, etc) returning the current value.
-
- Posts: 24
- Joined: Fri Aug 13, 2010 2:14 am
- OLAP Product: TM1
- Version: PAW 2 PAX
- Excel Version: 2016
Re: Planning Analytics - PAX DBS function
It didn't work when copying and modifying a DBRW formula with the equals sign in it, BUT copying and modifying without the equals for some reason DID work!?!
So copying and modifying =DBRW($A$1,$B$2,$B5,$A5,J$4) to =DBSW(100, $A$1,$B$2,$B5,$A5,J$4) DIDNT work
But copying and modifying DBRW($A$1,$B$2,$B5,$A5,J$4) - Note no equals sign to =DBSW(100, $A$1,$B$2,$B5,$A5,J$4) DID work
Must give the credit to a tenacious TM1 administrator at my client site for figuring it out, I had sworn and given up!
So copying and modifying =DBRW($A$1,$B$2,$B5,$A5,J$4) to =DBSW(100, $A$1,$B$2,$B5,$A5,J$4) DIDNT work
But copying and modifying DBRW($A$1,$B$2,$B5,$A5,J$4) - Note no equals sign to =DBSW(100, $A$1,$B$2,$B5,$A5,J$4) DID work
Must give the credit to a tenacious TM1 administrator at my client site for figuring it out, I had sworn and given up!