Until I learnd2BA I would have done similarly, but now I’d definitely go with a BA package (after investigation I chose Pentaho [http://www.pentaho.com])
Basic steps are:
- install analysis server
- load your denormalized data
- define the cube (pentaho has the schema workbench for this)
- analyze!
Until I learnd2BA I would have done similarly, but now I’d definitely go with a BA package (after investigation I chose Pentaho [http://www.pentaho.com])
Basic steps are:
- install analysis server
- load your denormalized data
- define the cube (pentaho has the schema workbench for this)
- analyze!