Dynamic report with multiple DBRW's per cell

[JohnO]

Hopefully a very simple one.

We are using 2.0.93 PAfE and 2.0.93 Spreadsheet services.

I have a report in PAfE where I have DBRW() + DBRW(). The DBRW's are pointing to separate measures.

In PAfE this report works fine but in TM1Web no rows are returned. If I pull it back to one DBRW it is fine in both PAfE and TM1. We don't have a natural aggregation for the 2 measures so I'm trying to keep it to 2 DBRW's.

I have looked at all of the fix lists in Spreadsheet Services since 2.0.93 but I didn't find anything related to this.

Should I expect this to work in TM1Web?

[MarenC]

Hi John,

Dynamic reports simple, is it April fools day!

Can you share exactly how the DBRW looks, because as nuts as this sounds I had an issue where the DBRW did not work if I put a space between the + sign and the second DBRW, I had to do something like,

=@DBRW(cube,dim1,dim2,measure1) +@DBRW(cube,dim1,dim2,measure2)

rather than
=@DBRW(cube,dim1,dim2,measure1) + @DBRW(cube,dim1,dim2,measure2)

Though note this was in PAW, not TM1Web.

Also, is the Measure in the Title, or is it part of the row/columns?

Maren

[JohnO]

Thanks. That's interesting but not the case for me.

The measures are in the column heading and the only difference between the two DBRW's is the measure. The formula is subtraction, so DBRW()-DBRW()

[burnstripe]

Try changing from dbrw to dbr just for the components that make the header

[MarenC]

The formula is subtraction, so DBRW()-DBRW()

Well you said initially,

I have a report in PAfE where I have DBRW() + DBRW()

I guess this is going to be a minimum information problem!

If Burnstripe's suggestion doesn't work you could try adding the measure dim to the TM1RPTITLE.

Or say having the first column just looking at the single measure (just a dbrw), and then the next column doing the DBRW()-DBRW(), and hiding the first column. messing around like that may give a clue as to the source of the issue.

maren