add non additive measures to a cube

• sairah

  Old Hand

  Points: 399

  More actions

  September 15, 2003 at 1:30 pm

  #159912

  hi,

  all i want to know how is it possible to add non additive measures to a cube..

  i want the non additive measures to be shoen only at the lowest level of the cube..

  i would be very grateful if some one can guide me..

• Keith Henry

  Hall of Fame

  Points: 3759

  More actions

  September 17, 2003 at 3:29 am

  #474582

  You can remove the "all" level, but part of the point of dimensions is this combination of values (can be SUM, COUNT, AVG)

  Keith Henry

  
  
  
  Keith Henry
  

  ---

  
  According to everyone I know I "do something with computers?" for a living, so there you go.

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  September 21, 2003 at 5:57 am

  #475167

  You could take a look at custom rollups or calculated cells. But this could end up being a lot of work to di through a large (many dimension) cube. Are you sure you want to use OLAP Vs relation/operational reporting?

  HTH,

  Steve.

  Edited by - stevefromOZ on 09/21/2003 06:00:57 AM

  Steve.

• ray_higdon

  SSCarpal Tunnel

  Points: 4589

  More actions

  September 21, 2003 at 6:25 am

  #475168

  When you say lowest level, do you mean on the dimension? Like the user would have to drill down to get to this level? If so, should be no problem adding the level to an existing dimension.

  Ray Higdon MCSE, MCDBA, CCNA

  ------------
  
  Ray Higdon MCSE, MCDBA, CCNA