Since everything has moved to github, might be a good idea to update reference links on the rubyforge pages, etc.

I added AW on rdoc.info and now there are fresh auto-generated docs from the github project.  Also, it will auto-update when new commits are made, or you can just click the update button.

http://rdoc.info/projects/aeden/activewarehouse

John

Paco,

You're a saint!  Thank you!  I got the DateDimension setup and loaded successfully, and will start working on the other bits tomorrow.  When I get everything working, I'll post a blog (I'm keeping notes).  Call it AW for noobs

One other question.  How does the view stuff work (high level)?  I saw one of the commits on github referring to Yahoo UI charts/datatable.  Do I need Yui4Rails to help with views? Or does AW generate view HTML by itself?

Thanks again for the quick response.

Regards,
John

Hi,

I'm trying out AW for a rails (2.3.2) project.  I've used BI software (siebel analytics) in the past so I'm famiilar with warehousing concepts in general.

I've found several links to the tutorial http://anthonyeden.com/2006/12/20/activewarehouse-example-with-rails-svn-logs but it is gone and others posts suggest it is very out of date.

So how else to get started with AW?  Or is there a copy of that tutorial floating around somewhere? 

I installed AW from the git repo as a plugin, added the gem dependencies and no errors.

Then I ran the generator for a fact table, and populated that fact table with some test data.  No problems.

So, what is the next steps to get a basic date drill-down?

I tried to setup the standard date dimension table 'rake warehouse:build_date_dimension' but get a unitialized constant DateDimension.  Looking through the plugin, I can see builder/date_dimension_builder.rb is in the require path/chain from init.rb

Suggestions?  Is anyone running AW with rails 2.3.2?

Thanks!
John

Hi,

a question I have received a number of times is: what's the proper(s) way(s) of doing upserts when working with AW-ETL ?

Is there some way to avoid doing updates records by records (like a bulk update) ?

Any hint will be most welcome,

regards,

Thibaut
--
[blog] http://evolvingworker.com - tools for a better day
[blog] http://blog.logeek.fr - about writing software

Hi guys,

Hi there,
I'm pretty new to activewarehouse, and was wondering what techniques are used to add and remove fields from the destination file. Right now it appears I have to delete fields by omitting them from the bulk import section, and add them by either renaming them on the fly or copying them. (Please let me know if this is not what activewarehouse is for .

Here's the goal:
take a list of employees and their phone numbers, and place each phone number on a different row with a corresponding phone number type like so:

original format and sample row:
=> id, first_name, last_name, phone, fax
=>10,ben,tom,4444444,5555555

final format and TWO rows:
=>id,number,phone_category
=>1,4444444,phone
=>2,5555555,fax

Notice I removed the first and last name columns...here are the beginnings of a row_processor (clearly written incorrectly or against conventions):
      def process(row)
        bp = row[:business_phone]
        fp = row[:fax_phone]
        rows = []
        biz = {:business_phone => bp, :first_name => 'biz'}
        fax = {:business_phone => fp, :first_name => 'fax'}
        rows =[biz,fax]
      end