Combine 2 fields for a calculation in a cube?

In this cube I need combine flexunits and cy_units fields and subtract them both to make it's own attribute called Delta_Units. What is a good way to complete this task?

August 26th, 2015 11:40pm

Create a calculated member using both measures.

Use Calulations if you are using Visual Studio,

CALCULATE; 
CREATE MEMBER CURRENTCUBE.[Measures].Delat_Units
 AS [measures].[flexunits]- [Measures].[cy_actunits], 
VISIBLE = 1  ;   


Free Windows Admin Tool Kit Click here and download it now
August 26th, 2015 11:47pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics