I am using the following MDX statement to retrun data to populate a drop down
list allowing the user to select a time period:

WITH
MEMBER [Measures].[DisplayName] AS
'SPACE([Period].CurrentMember.Level.Ordinal * 4) +
[Period].CurrentMember.Name'
MEMBER [Measures].[UniqueName] AS '[Period].CurrentMember.UniqueName'

SELECT
{[Measures].[UniqueName], [Measures].[DisplayName]} ON Columns,
[Period].Members ON Rows

FROM MyCube

The idea of the "SPACE([Period].CurrentMember.Level.Ordinal * 4)" bit in the
first MEMBER declaration is to provide indentation to give a sense of the
hierarchy in the drop down list display.

I now need to serve a client application that doesn't allow leading spaces
in the drop down list display. Is there a function I can use instead of SPACE
to put an alterntive indentation character at the start?

For example, a hyphen. So the returned data would look something like:

ALL
--2004
----Qtr1
------Jan
------Feb
------Mar

WITH
MEMBER [Measures].[DisplayName] AS
'String([Period].CurrentMember.Level.Ordinal * 4, "-") +
[Period].CurrentMember.Name'
MEMBER [Measures].[UniqueName] AS '[Period].CurrentMember.UniqueName'

SELECT
{[Measures].[UniqueName], [Measures].[DisplayName]} ON Columns,
[Period].Members ON Rows

FROM MyCube


"Dave Morrow" wrote: