ssas - How to establish in a mdx query 2 measures and a hierarchy -

i have query:

select non empty {     [art].[art].[art].allmembers * [measures].[costs] * [measures].[margin] } on columns   [model]   cell properties value, back_color, fore_color, formatted_value,     format_string, font_name, font_size, font_flags 

i error, stating cannot done. idea show, each member, cost , margin, follows:

article 1     | article 2     | article 3 cost | margin | cost | margin | cost | margin  

which correct way? way, tutorial or website learn creating mdx queries?

your query crossjoining measures together: [measures].[costs] * [measures].[margin] idea expected results different. show in expected result crossjoin of 2 sets: {articles} * {measures}

i suggest more this:

select      {[measures].[costs], [measures].[margin]} on columns,     non empty {[art].[art].[art].allmembers} on rows  [model]   cell properties value, back_color, fore_color, formatted_value, format_string, font_name, font_size, font_flags 

or if want on columns, expected result:

select      non empty {[art].[art].[art].allmembers} *          {[measures].[costs], [measures].[margin]} on columns [model]   cell properties value, back_color, fore_color, formatted_value, format_string, font_name, font_size, font_flags 

for learning mdx, recommend book "mdx solutions" gentle introduction.