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!
Using text attributes in excel templates (slice).. possible?
- 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?
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
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!
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!
-
- 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?
i hadn't found that syntax yet... thanks Mike! That was exactly what i was looking for