January 16, 2018 at 3:44 am
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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply