AggregateFunction = None displaying null values

[pjohns]

I have a fact table that contains a few percentage values as well as numerous numerical values. Naturally I want to aggregate the numerical values, but not aggregate the percentage values using Analysis Services 2005. I have set the property AggregateFunction = Sum for the numerical values and AggregateFunction = None for the percentage values. When I process the cube and display the values (at the lowest grain), I see the numerical values but the percentages are all null. I checked the data source and there should be valid percentage values displaying.

Any thoughts on what the problem is? I've googled and found multiple instances of the same problem with other people, but no solution was offered in all cases.

Thanks.

...Phillip

 

[MDXer]

Null would be the expected result for Setting the aggregate type to none, except possibly at the lowest level. you are probably better off doing you percentage calculations as a calculated member in the cube, This will allow your value to be representative of what you have showing on columns and rows.