US and Worldwide: +1 (866) 660-7555
Results 1 to 2 of 2

Thread: Differentiate Measures based on constant value in other column

  1. #1
    Join Date
    Aug 2013
    Posts
    128

    Default Differentiate Measures based on constant value in other column

    hello,

    I designed a cube in which all the different measures in one column, and other column contains a constant value to differentiate which is which.

    p1----10----type1

    p2----20-----type1


    p3------30----type1

    p1------25----type2

    p3------23----type2

    i want measures for cube as type1, type2 is it possible,
    rt now i achieved this by creating different views for each type and created a cube for each and created a virtual cube to combine all
    Thank U For Your Time
    Suresh

  2. #2
    Join Date
    Jan 2013
    Posts
    521

    Default

    Rather than using two cubes, you can create calculated members which slice to type1 or type2. This would be defined as a simple tuple, e.g.:

    ( measures.[My Measure], dimension.[type1] )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •