This project has moved. For the latest updates, please go here.

Function GetMemberPropertyTableHTML

Topics: Developer Forum
Apr 7, 2009 at 9:20 AM
GOAL
I'd like to add a cube action, which generates a HTML page containing all member property attribute names (=visible attribute relationships) and their values for a specific dimension member as a HTML table.

APPROACH
Therefore I'm looking for a function, which extracts the relationship attribute names and values for a specific dimension attribute (passed by parameter) and then wraps the retrieved values with additional HTML-table tags (tr, td; or by prefix/suffix-parameter) and finally builds a concatenated string, which then can be used within the cube action definition. The table body and header columns itself are defined in the calling action definition and therefore must not be part of the concatenated string.

CHALLENGE
The visible attribute relationships for a specific dimension member can be extracted as data table with the existing Discover function of this project. But moreover I'm looking for a way or even better a (new?) ASSP function, which also extracts the related attribute values and builds the desired concatenated HTML string on the top of it.
In its most flexible version, the function would accept following parameters: 1) Catalog Name 2) Cube Name 3) Unique Dimension Member Name, and
4) Format String which defines the attribute wrapping pattern (example: '<tr><td>##Name##</td><td>##Value##</td></tr>',
where ##Name## and ##Value## is replaced with the existing member property attribute names and values.

As my skill focus is more on T-SQL and MDX rather than C# and its SSAS related object models, having a new ASSP function or working code sample would help most. I assume, that this function in its most flexible version (as suggested above), would also be useful for other purposes within MDX scripts and/or queries.
Based on the new function I could contribute MDX related usage examples to document the power of the resulting cube actions.

Coordinator
Apr 8, 2009 at 2:17 AM
What client tool are you using to consume this HTML action?

Off the top of my head, I don't think that Excel 2007 supports HTML actions (just URL/reporting actions and drillthrough/rowset actions). But if other major client tools support HTML actions, this proposed sproc may be a win.

Thanks for the suggestion! We'll definitely consider it. Let us know if you write any code you want to share.
Apr 8, 2009 at 7:51 AM
Edited Apr 8, 2009 at 7:53 AM
CLIENT TOOL
The HTML actions are initiated thru ProClarity.
It might be, that also following good front end tools support HTML-actions:
Intelligencia (IT-Workplace), Cubeware Cockpit.
There are many other tools as well. To get a comprehensive picture maybe other
SSAS-specialists like Chris Webb and Mosha Pasumansky may provide some feedback. 

FUNCTION
Moreover the function I'm looking for, could also be used to build a concatenated string,
which then could be used to create specific calculated measures/members with text content.

CONTRIBUTION
I'm pleased to contribute code. But as mentioned, my focus is on the cube design and MDX-side and not in creating assemblies (unfortunately). Some impressions about enhanced cube design and functionality as implemented by our team can be derived from the slides on www.aito.ch . If you or the community is interested in code logic and design behind specific features I can write some short articles.
Coordinator
Apr 8, 2009 at 8:26 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.