Add new field in a SSAS 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?



  • Edited by D Henson 6 hours 40 minutes ago
August 26th, 2015 7:43pm

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,

Free Windows Admin Tool Kit Click here and download it now
August 27th, 2015 3:36am

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

Other recent topics Other recent topics