question

Raj More avatar image
Raj More asked

SSAS from Netezza

We were extracting data out of Netezza into txt files, loading into a SQL Server DB and processing our SSAS cube(s) from there.

We want to change that and load the cube directly from Netezza.

Can anyone give me pointers / ideas / gotchas on this?

ssasnetezza
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Joe Harris avatar image
Joe Harris answered

You're taking it out of Netezza to put into SSAS? Netezza should easily blow the doors off anything SSAS can do.

Have you tried just using the Netezza database as a ROLAP source? That would be my first port of call.

If you're not getting mind-blowing speed out of your NZ box try pushing more keys into the lower grain tables (e.g. push Account down into an Invoice Detail table so that you can distribute on Account)

Good luck.

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Raj More avatar image Raj More commented ·
Netezza as a ROLAP? Netezza blows the doors off SSAS? I had no idea. Point me to some reading material on this please. I am very much interested in this.
0 Likes 0 ·
Rob Farley avatar image
Rob Farley answered

So long as you can make am oledb/odbc connection to it, you should be able to make the cube from that.

I wouldn't though. Cubes run best on static data, so I'd still do a regular extraction.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.