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?
Combine 2 fields for a calculation in a cube?
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 ;
- Edited by pIdrA 3 hours 26 minutes ago
- Proposed as answer by MichaelAdrianJohnson 2 hours 24 minutes ago
Free Windows Admin Tool Kit Click here and download it now
August 26th, 2015 11:47pm