TM1 Forum

Hello All,
I have an ODBC drill through that works for Excel cells with formula =DBRW(dim1,dim2.,etc).However, when the cell contains =-DBRW(dim1,dim2.,etc). The negative sign causes the drill through function not to appear.Currently, the drill assignment rule is [Version:'Act']=S:'P&L';
Do I need to modify the rule to accomodate the negative sign?

I wonder if it's excel doing something funny with it. Have tried changing the formula to: dbrw()*-1

To drill through you need the DBRW formulas to be "naked". (Which they should be anyway, multiplying by -1 causes the DBRWs to behave as DBRs which may give substantially reduced performance.)

Multiplying by -1 as in the case of presenting credit accounts as a positive number is something that should be taken care of within the cube itself. There are several advantages of doing this; easier report maintenance as DBRW formulas can be consistent throughout the report, better performance, ability to data spread and ability to drill-trough ...

Lotsaram : that's an interesting observation. Would DBRW()+DBRW() count as "naked" or be treated as two DBRs?

hbell wrote:Lotsaram : that's an interesting observation. Would DBRW()+DBRW() count as "naked" or be treated as two DBRs?

I'm not absolutely 100% certain but pretty sure that adding 2 DBRWs within a single cell would also break the "W" and effectively turn the formulas into DBRs.