Hello,
I am currently having a project to design a cube for a vast amount simulation data and I am a beginner of SSAS for a month. There is a question about the aggregation for the hierarchy. For instance, we have hierarchy
--system
---subsystem
----component
for a measure, downtime, the system level downtime is not the sum of downtime of subsystem. However, the downtime of subsystem is the sum of down time of components, which can be aggregated from components. I wonder if the SSAS 2005 has the capability to perform the aggregation to the subsystem level but store the downtime data for system.
Thank you
I am currently having a project to design a cube for a vast amount simulation data and I am a beginner of SSAS for a month. There is a question about the aggregation for the hierarchy. For instance, we have hierarchy
--system
---subsystem
----component
for a measure, downtime, the system level downtime is not the sum of downtime of subsystem. However, the downtime of subsystem is the sum of down time of components, which can be aggregated from components. I wonder if the SSAS 2005 has the capability to perform the aggregation to the subsystem level but store the downtime data for system.
Thank you