Create a Calculation within a Dimension

• tuktukg

  SSC Enthusiast

  Points: 139

  More actions

  January 27, 2016 at 8:16 am

  #150963

  I have a simple cube with one measure and 3 dimensions. I’m trying to create a calculation in the dimension “CRED IVR END REASON DIM V”.

  My goal is to create a calculation where I add the value for “HangUp” and “Blank” and divide by the Total to create “Out %”

  Here was my attempt of creating a calc measure in the cube but it’s throwing and error:

  CALCULATE;

  CREATE

  MEMBER CurrentCube.[Measures].[Out %] AS

  CASE

  WHEN

  ([Measures].[AppCounts])>0

  THEN NULL

  ELSE

  (

  [CRED IVR END REASON DIM V].[IVRCALL VC CALLENDREASON].&[Hung Up],[Measures].[AppCounts]+

  [CRED IVR END REASON DIM V].[IVRCALL VC CALLENDREASON].&[NULL],[Measures].[AppCounts]

  )

  /

  (

  [CRED IVR END REASON DIM V].[IVRCALL VC CALLENDREASON].[All]

  ,[Measures].[AppCounts]

  )

  END

  ,FORMAT_STRING = “Percent”

  ,VISIBLE = 1;

  Am I going about this the correct way? This is my first cube and calc’d measure…I’ve read that you can also add this to the DIM V for the dimesion possible w a case statement but not sure how.

  Any advice is greatly appreciated.

• tuktukg

  SSC Enthusiast

  Points: 139

  More actions

  January 27, 2016 at 3:42 pm

  #1854834

  here is what I was going for

  CREATE MEMBER CURRENTCUBE.[CRED IVR END REASON DIM V].[IVRCALL VC CALLENDREASON].[All].[Out %]

  AS

  ([CRED IVR END REASON DIM V].[IVRCALL VC CALLENDREASON].&[Hung Up]+[CRED IVR END REASON DIM V].[IVRCALL VC CALLENDREASON].&[NULL])

  /[CRED IVR END REASON DIM V].[IVRCALL VC CALLENDREASON].[ALL],

  FORMAT_STRING = 'Percent',

  VISIBLE = 1;