alter Calculated Measure

• Charmer

  SSChampion

  Points: 14903

  More actions

  January 16, 2018 at 3:44 am

  #342374

  Hi Friends,

  I have a dimension and measure groups as follows 
  Other Filters - Dimesnion
     - Revenue Type (Regular/Combined)
     - Projected (Yes/No)

  Measure Group
  Sales
     - Units
     - Transactions
     - Net Sales
  Projected
     - Units Projected
     - Transactions Projected
     - Net Sales Projected

  I want to alter the below calculated measure to a new name as [Measures].[Actual Net Sales]
  And create a new measure as [Net Sales] to include new 
    SCOPE [Other Filters].[Projected].[Yes] then [Measures].[Actual Net Sales] + [Measures].[Net Sales Projected] else by default [Measures].[Actual Net Sales]
  
CREATE MEMBER CURRENTCUBE.[MEASURES].[Net Sales]
AS [MEASURES].[z Net Sales]
, FORMAT_STRING = "#,#;(#,#)", VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Sales';
SCOPE [Measures].[Net Sales];
SCOPE [Other Filters].[Revenue Type].[Combined Revenue];
scope [Store].[Zone].[All];
this= sum(DESCENDANTS([Store].[Zone].currentmember, [Store].[Zone].[Zone]), [Measures].[Net Sales]);
END SCOPE;
SCOPE ({[Store].[Zone].[NRBV ECOMMERCE], [Store].[Zone].[NRBV GLOBALSTORE]});
this=[Measures].[Demand];
END SCOPE;
END SCOPE;
END SCOPE;

  Thanks,
  Charmer