TM1 Forum

Posted: **Wed Apr 22, 2009 9:13 pm**

Hello everyone,
I've built a model for a business user group who, of course, want to see almost every field in their database. A few fields ended up as attributes and therefore the users can filter in the cube viewer, however at the 11th hour, they now NEED to use these attributes within their excel templates.

Does anyone know how to use text attributes within an excel template/slice?

Any suggestions on attribute functionality is welcome. Please help me from building a model of impracticle amounts of dimensions

Thank you!

Posted: **Wed Apr 22, 2009 9:22 pm**

Hi,

Have you looked at the Excel DBRA formula? Its purpose is to return attribute values for a dimension. You can easily insert these into your slices. The syntax if you don't have it handy is:

=DBRA( DimensionName, ElementName, AttributeName )

Note the dimension name would be of the syntax "servername:dimensionname".

Regards,
Mike

Posted: **Wed Apr 22, 2009 10:38 pm**

i hadn't found that syntax yet... thanks Mike! That was exactly what i was looking for

TM1 Forum

Using text attributes in excel templates (slice).. possible?

Using text attributes in excel templates (slice).. possible?

Re: Using text attributes in excel templates (slice).. possible?

Re: Using text attributes in excel templates (slice).. possible?