Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


AggregateFunction = None displaying null values

AggregateFunction = None displaying null values

AggregateFunction = None displaying null values

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.



RE: AggregateFunction = None displaying null values

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close