Home > SSAS > Cube has died a harsh death

Cube has died a harsh death

After 8 months away from the bank, I recently went back to the same team, and got back my old job.

At the time of my leaving last year, it seemed that the direction was favoring Analysis Services (SSAS, or cube, as we all “affectionately” call it) and moving away from Reporting Services. As the chief cube designer told me, the cube has encapsulated all the business rules, therefore, it represents the “truth”, and the only truth of the data. He was very unhappy when I told him that my manager has not told me to use his “master” cube as the only data source yet.

After the first few days of getting re-acquainted with my old co-workers, my first real technical question is what happened to the cube. I see that majority of the SSRS reports I developed are still in use. The answer is “it died a harsh death”. One day, the word came from the above, abandoning the cube, no more SSAS, no more MDX, just old plain SQL and SSRS, and SSIS. The lesson is, according to my co-worker, we need more experience, more best practices, and more standards for developing cubes.

You can imagine how “disappointing” I am. Not really. I am glad that it has died because it wasn’t designed right to be the only truth. Hopefully we have all learned our lessons.

Categories: SSAS
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: