Rename The Columns Of A MDX Dataset

Hi,

I have a dataset in MDX using an OLE DB connexion. Here is the query:



Code Snippet
WITH
MEMBER [Number Proposal Issued] as
'[Measures].[# Proposal]'
MEMBER [Value Proposal Issued] as
'[Measures].[Amount - E]'
select
{ [Fact Proposal].[Proposal Status].allmembers*{[Number Proposal Issued],[Value Proposal Issued] }} ON 1
,non empty
[Time Key Issuing Date].[Month].children
ON 0
FROM [BV Sales DW]
where {[Time Key Issuing Date].[Year].&[2008]}




It is simple, it works. BUT, the dataset fields take the name of the returned columns and in this case, the [Time Key Issuing Date] values. The aim of this query is to be able to change the year at will (in the where).
For the moment, the fields has the full tuple name like Time_Key_Issuing_Date_Month__2008_1 for january. If I change the year to 2007, I will get Time_Key_Issuing_Date_Month__2007_1 so a different name.

So my question is: is there a way to call the first column for example "January" whatever the year is so I can call it in my report? Something like:

[Time Key Issuing Date].[Month].&[ (param year) ]&[1] as January
,[Time Key Issuing Date].[Month].&[ (param year) ]&[2] as February
...
on 0

I have tried to rename them in the dataset fields tab but when I put another name, it says the field doesn't exist.

We have managed to do it with code in the report but it a huge code not very easy to handle.

Thanks in advance for all help you can provide.