Setting Member_caption in AS2005 -
08-21-2006
, 09:11 AM
I need to allow users to choose between displaying Member Names (e.g. 'A4302'
or 'Jan') or Member Aliases (e.g. 'Short Term Cash' or 'January') when view
MDX query results. These views are being surfaced to users via Reporting
Services and an as yet to be chosen ad-hoc query and reporting tool
(evaluating ProClarity among others). I am not sure how this is meant to be
accomplished in AS 2005.
I have defined Parent/Child dimensions in which the key is Member (e.g.
'A4302' or 'Jan'). I have an additional column named 'Alias' in which I've
placed the verbose description (e.g. 'Short Term Cash' or 'January'). Both
Columns are surfaced as Attributes in AS.
ProClarity permits one to select a different Attribute for Member Names
(e.g. Alias), which is fine, though a little flakey. However, I've not found
a way to surface Aliases to Reporting Services, SQL Server Mgt Studio, etc,
or to be able to toggle betwen Members and Aliases.
I have I see references to a MEMBER_CAPTION property as a possible
direction, but I haven't figured out where to set that differently than that
of the MEMBER_NAME property.
Any thoughts? |