vineet_dubey1975 (2/5/2015)
Hi ,I am having a DimProject with the TypeID , Capacity attributes.
factOut contains measure.OutPutVal.
my Data is something like
ProjectID , TypeID , Capacity
1 1 100
2 1 100
3 1 100
4 2 100
5 2 100
I need OutPut
TypeID TotalCapacity
1 300
2 200
Thanks for the help
VD
Facts will naturally be aggregated for dimension members, assuming that your properties have been set for that measure to Sum and if the attribute relationships in your dimension is correct.
You wouldn't need any specific function in your mdx query. Why don't you give it a try and post your attempts...it makes it easier to help that way as opposed to just give you the solution.