<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

  <meta content="text/html;charset=windows-1252"

 http-equiv="Content-Type">

  <title></title>

</head>

<body bgcolor="#ffffff" text="#000000">

Replying to my own post is bad form but others may be interested.а The

solution is to use SOLVE_ORDER to ensure that [Date].[DateParm] is

evaluated before the rest of the calculated measures.<br>

<br>

<font face="Courier New, Courier, monospace">WITH<br>

а Member [Date].[DateParm] as 'Parameter("CalcMDXDateStr", [Date],

[Date].[All Years].[2009].[Q4].[NOV].[4] )'<font color="#ff0000"><b>,

SOLVE_ORDER=100</b></font><br>

select<br>

а CROSSJOIN(<br>

ааааа { [Date].[DateParm] },<br>

ааааа { [Measures].[NumProjs], [Measures].[NumProjsLastMonth],<br>

[Measures].[NumProjsThisMonthLastYear], [Measures].[NumProjsYTD],<br>

[Measures].[NumProjsYTDLastYear],а [Measures].[NumProjsLastYear] }<br>

а ) ON COLUMNS,<br>

а NON EMPTY [Area].[All Areas].Children ON ROWS<br>

from [Enquiries]<br>

where (<br>

ааа [Activity.Activity Type].[All Types].[Created]<br>

)<br>

<br>

</font>I now get usable column headers/field names within PRD.<br>

<br>

Phil<br>

<br>

p.s. Thanks to Kaapa for help removing the unnecessary strToMember().<br>

<br>

Phil Cole wrote:

<blockquote

 cite="mid:b0b0adf0911050948x5f44e981ue94b73af70db9b29@mail.gmail.com"

 type="cite">

  <div class="gmail_quote">

  <div>

  <div>

  <div><font face="Arial" size="2">

  <div>

  <p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span

 lang="en-gb"></span></p>

  <p dir="ltr"><span lang="en-gb"><font face="Arial" size="2">I</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"><font

 face="Arial" size="2">Т</font></span><span lang="en-us"></span><span

 lang="en-us"></span><span lang="en-gb"><font face="Arial" size="2">m

working with PRD and mondrian.а I have the following MDX query</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"><font

 face="Arial" size="2"> which takes a single parameter</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"> <font

 face="Arial" size="2">У</font></span><span lang="en-us"></span><span

 lang="en-us"></span><span lang="en-gb"><font face="Arial" size="2">CalcMDXDateStr</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"><font

 face="Arial" size="2">Ф</font></span><span lang="en-us"></span><span

 lang="en-us"></span><span lang="en-gb"><font face="Arial" size="2">

provided by a DatePicker -&gt; OpenFormula combo in PRD.</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"></span></p>

  <p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span

 lang="en-gb"></span></p>

  <p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span

 style="font-family: courier new,monospace;" lang="en-gb"><font size="2">select<br>

а CROSSJOIN(<br>

ааааа { strToMember( Parameter("CalcMDXDateStr", STRING, "[Date].[All

Years].[2009].[Q4].[NOV].[4]" )) },<br>

ааааа { [Measures].[NumProjs], [Measures].[NumProjsLastMonth],

[Measures].[NumProjsThisMonthLastYear], [Measures].[NumProjsYTD],

[Measures].[NumProjsYTDLastYear],а [Measures].[NumProjsLastYear] }<br>

а ) ON COLUMNS,<br>

а NON EMPTY [Area].[All Areas].Children ON ROWS<br>

from [Enquiries]<br>

where (<br>

ааа [Activity.Activity Type].[All Types].[Created]<br>

)</font></span><span lang="en-us"></span><span lang="en-us"></span><span

 lang="en-gb"></span></p>

  <p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span

 lang="en-gb"></span></p>

  <p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span

 lang="en-gb"><font face="Arial" size="2">This query returns 69 rows

with the following column headers:</font></span></p>

  <p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span

 lang="en-us"><font face="Arial" size="2">[Area].[(All)]<br>

[Area].[Desc]</font><br>

  </span><span lang="en-us"></span><span lang="en-us"><font face="Arial"

 size="2">[Date].[All Years].[2009].[Q4].[NOV].[4]/[Measures].[NumProjs]</font><br>

  </span><span lang="en-us"></span><span lang="en-gb"><font face="Arial"

 size="2">[Date].[All Years].[2009].[Q4].[NOV].[4]/[Measures].[NumProjs</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"><font

 face="Arial" size="2">LastMonth</font></span><span lang="en-us"></span><span

 lang="en-us"></span><span lang="en-us"><font face="Arial" size="2">]</font><br>

  </span><span lang="en-us"></span><span lang="en-gb"><font face="Arial"

 size="2">[Date].[All Years].[2009].[Q4].[NOV].[4]/[Measures].[NumProjs</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"><font

 face="Arial" size="2">ThisMonthLastYear</font></span><span lang="en-us"></span><span

 lang="en-us"></span><span lang="en-us"><font face="Arial" size="2">]</font><br>

  </span><span lang="en-us"></span><span lang="en-gb"><font face="Arial"

 size="2">[Date].[All Years].[2009].[Q4].[NOV].[4]/[Measures].[NumProjs</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"><font

 face="Arial" size="2">YTD</font></span><span lang="en-us"></span><span

 lang="en-us"></span><span lang="en-us"><font face="Arial" size="2">]</font><br>

  </span><span lang="en-us"></span><span lang="en-gb"><font face="Arial"

 size="2">[Date].[All Years].[2009].[Q4].[NOV].[4]/[Measures].[NumProjs</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"><font

 face="Arial" size="2">YTD</font></span><span lang="en-us"></span><span

 lang="en-us"></span><span lang="en-gb"><font face="Arial" size="2">LastYear</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-us"><font

 face="Arial" size="2">]</font><br>

  </span><span lang="en-us"></span><span lang="en-gb"><font face="Arial"

 size="2">[Date].[All Years].[2009].[Q4].[NOV].[4]/[Measures].[NumProjs</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"><font

 face="Arial" size="2">LastYear</font></span><span lang="en-us"></span><span

 lang="en-us"></span><span lang="en-us"><font face="Arial" size="2">]</font><br>

  </span><span lang="en-us"></span><span lang="en-gb"><font face="Arial"

 size="2">Now these column headers are horrible to work with so I

wanted to replace the</font></span><span lang="en-us"></span><span

 lang="en-us"></span><span lang="en-gb"><font face="Arial" size="2">

data parameter</font></span><span lang="en-us"></span><span lang="en-us"></span><span

 lang="en-gb"><font face="Arial" size="2"> with a</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"> <font

 face="Arial" size="2">named member, i.e.</font></span></p>

  </div>

  </font></div>

  </div>

  </div>

  </div>

</blockquote>

<blockquote

 cite="mid:b0b0adf0911050948x5f44e981ue94b73af70db9b29@mail.gmail.com"

 type="cite">

  <div class="gmail_quote">

  <div>

  <div>

  <div><font face="Arial" size="2">

  <div>

  <p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span

 style="font-family: courier new,monospace;" lang="en-gb"><font size="2">with<br>

а member [Date].[DateParam] as 'strToMember(

Parameter("CalcMDXDateStr", STRING, "[Date].[All

Years].[2009].[Q4].[NOV].[4]" ))'<br>

select<br>

а CROSSJOIN(<br>

ааааа { [Date].[DateParam] },<br>

ааааа { [Measures].[NumProjs], [Measures].[NumProjsLastMonth],

[Measures].[NumProjsThisMonthLastYear], [Measures].[NumProjsYTD],

[Measures].[NumProjsYTDLastYear],а [Measures].[NumProjsLastYear] }<br>

а ) ON COLUMNS,<br>

а NON EMPTY [Area].[All Areas].Children ON ROWS<br>

from [Enquiries]<br>

where (<br>

ааа [Activity.Activity Type].[All Types].[Created]<br>

)</font></span><span lang="en-us"></span><span lang="en-us"></span><span

 lang="en-gb"></span></p>

  <p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span

 lang="en-gb"></span></p>

  <p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span

 lang="en-gb"><font face="Arial" size="2">But this query only returns</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"> <font

 face="Arial" size="2">9</font></span><span lang="en-us"></span><span

 lang="en-us"></span><span lang="en-gb"><font face="Arial" size="2">

rows</font></span><span lang="en-us"></span><span lang="en-us"></span><span

 lang="en-gb"><font face="Arial" size="2">, and</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"> <font

 face="Arial" size="2">all measure</font></span><span lang="en-us"></span><span

 lang="en-us"></span><span lang="en-gb"> <font face="Arial" size="2">values

are zero apart from column</font></span><span lang="en-us"></span><span

 lang="en-us"></span><span lang="en-gb"> <font face="Arial" size="2">[Measures].[NumProjs]</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"><font

 face="Arial" size="2">.а The column headers are lovely though, e.g.</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"><font

 face="Arial" size="2"> [Date].[DataParm]/[Measures].[NumProjs]</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"></span></p>

  <p dir="ltr"><span lang="en-gb"><font face="Arial" size="2">I</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"><font

 face="Arial" size="2">Т</font></span><span lang="en-us"></span><span

 lang="en-us"></span><span lang="en-gb"><font face="Arial" size="2">m

confused.а I</font></span><span lang="en-us"></span><span lang="en-us"></span><span

 lang="en-gb"><font face="Arial" size="2">Т</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"><font

 face="Arial" size="2">ve replaced a Member with a Member</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"><font

 face="Arial" size="2">?а Is this a bug?</font></span><span lang="en-us"></span><span

 lang="en-us"></span><span lang="en-gb"></span></p>

  <p dir="ltr"><span lang="en-gb"><font face="Arial" size="2">I</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"><font

 face="Arial" size="2">Т</font></span><span lang="en-us"></span><span

 lang="en-us"></span><span lang="en-gb"><font face="Arial" size="2">ve

converting it to a set with the following MDX query, but then the same

horrible column headers are presented in PRD.</font></span></p>

  <p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><font

 face="Courier New, Courier, monospace"><span

 style="font-family: comic sans ms,sans-serif;" lang="en-gb"><font

 size="2">with<br>

а set [DateParam] as '{ strToMember( Parameter("CalcMDXDateStr",

STRING, "[Date].[All Years].[2009].[Q4].[NOV].[4]" )) }'<br>

select<br>

а CROSSJOIN(<br>

ааааа [DateParam],<br>

ааааа { [Measures].[NumProjs], [Measures].[NumProjsLastMonth],

[Measures].[NumProjsThisMonthLastYear], [Measures].[NumProjsYTD],

[Measures].[NumProjsYTDLastYear],а [Measures].[NumProjsLastYear] }<br>

а ) ON COLUMNS,<br>

а NON EMPTY [Area].[All Areas].Children ON ROWS<br>

from [Enquiries]<br>

where (<br>

ааа [Activity.Activity Type].[All Types].[Created]<br>

)</font></span></font><span lang="en-us"></span><span lang="en-us"></span><span

 lang="en-gb"></span></p>

  <p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span

 lang="en-gb"><font face="Arial" size="2">I</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"><font

 face="Arial" size="2">Т</font></span><span lang="en-us"></span><span

 lang="en-us"></span><span lang="en-gb"><font face="Arial" size="2">m

confused!!</font></span></p>

  <p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span

 lang="en-gb"><font face="Arial" size="2">Phil</font></span><span

 lang="en-us"></span><span lang="en-us"></span><span lang="en-gb"></span></p>

  <p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span

 lang="en-gb"></span></p>

  <p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span

 lang="en-gb"></span></p>

  </div>

  </font></div>

  </div>

  </div>

  </div>

  <br>

</blockquote>

</body>

</html>