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

Post Reply
kbogies
Posts: 31
Joined: Tue Jun 10, 2008 8:21 pm
OLAP Product: TM1
Version: 9.1sp4 64x
Excel Version: 2003
Location: Hartford, CT

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

Post by kbogies »

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 :roll:

Thank you!
User avatar
Mike Cowie
Site Admin
Posts: 482
Joined: Sun May 11, 2008 7:07 pm
OLAP Product: IBM TM1/PA, SSAS, and more
Version: Anything thru 11.x
Excel Version: 2003 - Office 365
Location: Alabama, USA
Contact:

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

Post by Mike Cowie »

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
Mike Cowie
QueBIT Consulting, LLC

Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
kbogies
Posts: 31
Joined: Tue Jun 10, 2008 8:21 pm
OLAP Product: TM1
Version: 9.1sp4 64x
Excel Version: 2003
Location: Hartford, CT

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

Post by kbogies »

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