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?
- Edited by D Henson 6 hours 40 minutes ago
Technology Tips and News
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?
Hi D Henson,
According to your description, you want to combine the two existing attributes into one attribute. Right?
In Analysis Services, all those attributes are from columns in the underlying relational tables. For your requirement, you need go to the Data Source View, replace the table with Named Query. Then you can combine the two columns into one field in your query.
Regards,