Display valuw in cube --Pls help

• gugan_ta

  SSCommitted

  Points: 1649

  More actions

  November 30, 2010 at 11:47 pm

  #142761

  Hi,

  Pls help how to display the value in cube with out updating original table

  Table

  ---------

  p1 date qty

  100 20100101 1000

  100 20100201 0

  100 20100301 0

  200 20100401 500

  200 20100501 0

  In cube i need to display as follows (i.e, qty should be displayed for all same p1)

  p1 date qty

  100 20100101 1000

  100 20100201 1000

  100 20100301 1000

  subTotal 1000

  200 20100401 500

  200 20100501 500

  subtotal 500

  Thanks in advance

  Regards...Gugan

• amit_gupta01

  SSChasing Mays

  Points: 605

  More actions

  December 1, 2010 at 11:13 pm

  #1257729

  use firstchild MDX function to achieve this.

  Thanks,
  Amit G
  http://www.msbiconcepts.com