TM1 Forum

Hello,

I am trying to reference a dimension attribute on a spreadsheet and the formula doesn't come through.

=DBRA("r_best_practice",$A7,"Details")

A7 is the dimension element, the dimension is r_best_practice and the attribute is Details.

The formula doesn't return an error, just displays as blank in Excel. Can anyone help???

youngjedi wrote:Hello,

I am trying to reference a dimension attribute on a spreadsheet and the formula doesn't come through.

=DBRA("r_best_practice",$A7,"Details")

A7 is the dimension element, the dimension is r_best_practice and the attribute is Details.

The formula doesn't return an error, just displays as blank in Excel. Can anyone help???

You seem to be missing the server name before the dimension name. It needs to be "ServerName:r_best_practice".

Works with both light sabres and blasters.