Contact US

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!

*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

Displaying Aggregations

Displaying Aggregations

Displaying Aggregations

Has anyone tried to add, remove, or display aggregations.  I am trying to write a VB program to do just that, but when it comes to finding aggregation information, it has been very difficult.  My main problem seems to be finding the DSO properties that define the aggregations.  I have been able to display the Server, the DB, the Cube, the Partition, but when I get to the Aggregation, it finds all of the dimensions in the cube but I can't distinguish the dimensions from the aggregation fields.  There must be a property that does this.  Also, I was able to add my own aggregations to the cube, but when I process the cube, it processes it using ROLAP instead of MOLAP which is what we are using.  So there must be a field for that as well.  
I have searched books and have found code on everything but this ellusive subject.  Can anyone help me with this.
Tom Luskin
Shared Medical Systems
Data Warehousing Analyst

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! Already a Member? Login

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