dbTalk Databases Forums  

Setting Member_caption in AS2005

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Setting Member_caption in AS2005 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
rhankey
 
Posts: n/a

Default 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?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.