MDX : Rename column titles as calculated Mmeber

Question

I have an OLAP Mondrian cube published on JasperServer within MDX script

My cube looks like this:

The MDX code is the following:

select NON EMPTY {[Measures].[Time consumed]} ON COLUMNS,
  NON EMPTY Hierarchize({([Users.User].[All Users.Users],[Projects.Project].[All Projects.Projects],[Tasks.Task].[All Tasks.Tasks], [Imputations.Imputation].[All Imputations.Imputations])}) ON ROWS
from [cubeSifast]

As I see in the display view i have standr columns nomination, so how may I change for example :

1. the column headers titles (circled with blue line)

2. the children titles which are the names of dimensions (yellow)

I think that can be within the calculated members with MDX

"with member as"

but how exatcly, any suggestions?

Answer 1

You could try it with a Set.

with
set myNewName
as
[Users.User].[All Users.Users].MEMBERS
select 
    NON EMPTY {[Measures].[Time consumed]} ON COLUMNS,
    NON EMPTY Hierarchize({(myNewName,[Projects.Project].[All Projects.Projects],[Tasks.Task].[All Tasks.Tasks], [Imputations.Imputation].[All Imputations.Imputations])}) ON ROWS
from [cubeSifast]