Post reply

different measures for different levels of cube

  • September 15, 2003 at 6:40 am

    #151926

    i am making a cube in analysis services is it possible tht at one level of the cube i have some measures which are not avaliable at a higher level..if so..how..

    what i actually want is that i shd have maxrate and minrate at the lowest level in the cube. i want it to get the maximum of maxrate for a specific date when i roll up to a level in the cube how..

    is this possible..

    can anyone guide me

  • September 17, 2003 at 3:27 am

    #474580

    Not in one cube. All measures will be availiable at all levels. You can remove the "All" level of a dimension if totals don't make sense. If you are calculating different things then what you really need is multiple cubes. They can share some dimensions while not sharing others, allowing you to join them in MDX or a virtual cube

    Keith Henry




    Keith Henry


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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply