Who can help me to write one MDX script

• xywsuper

  Old Hand

  Points: 359

  More actions

  February 4, 2009 at 2:34 am

  #196782

  I have a cube, see the picture in the attachment(cube.jpg).

  Now I have one Mdx script to get measure1 for current year + average value of previous year. You can see the result in the(result.jpg). That's the result for whole site.

  I also want to add the site as the row. Does anybody know how to do it?

• Rick Todd

  Hall of Fame

  Points: 3302

  More actions

  February 4, 2009 at 6:57 am

  #937926

  Where do you want the site to appear? And is it The Site attribute in the Site Hierarchy?

  
  Rick Todd