Create member with description in MDX

ssas mdx olap-cube
Dan Kennedy picture Dan Kennedy · Apr 21, 2010 · Viewed 7.7k times · Source

This is a pretty straight forward question that may or may not be possible but, when you create a measure in a SSAS 2005 cube, there is a description property which can be set, which we've been using in the client application that consumes the cube.

Is it possible to set this description when you create a calculated member through MDX? i.e. something like (although it doesn't work as I get an error saying the syntax near DESCRIPTION is incorrect)

CREATE MEMBER CURRENTCUBE.[Measures].[CalculatedMember] AS
NULL,
FORMAT_STRING = "Percent",
VISIBLE = 1,
DESCRIPTION = "My favourite calcuated measure";

Answer

Jake Longo picture Jake Longo · Sep 1, 2011

On the Calculations Tab - click on the 'Calculations Properties' button. This is where you can tell SSAS which folder to put your calculations in. There is a Description column - fill that in, and Bob is your uncle.

Related questions

Filtering MDX query with current year & month using Now()

How can I filter data in MDX with current Year & Month? What I did so far is: WHERE strtomember{ [Time Dim].[FSCL YEAR].&["+Format(now(), "yyyy")+"], [Time Dim].[FSCL MONTH].&["+Format(now(), "m")+"] } but it is not …

Read More
MDX Column Alias for use in SQL

I'm trying to query our SSAS cubes and return the values into a SQL view for use as parameters in cube based reports. I need to return 3 values for financial seasons based on the date hierarchy. This is the below …

Read More
SSAS MDX WHERE clause syntax - filtering multiple values from the same hierarchy

I'm quite new to data warehousing and MDX queries, and I realize that I'm probably not using the MDX syntax properly in the case below. I'm using SSAS 2005 on MS SQL Server 2005 and would like to query my cube and …

Read More