Sprint 1 (Nov 6 - Dec 1 2009)

Status

Complete

Sprint 1 Goals

Deliver the first milestone to the community highlighting the main components of the Agile BI initiative including:

• Project Startup - setting up JIRA, SVN, CI, Wiki projects
• Starting from a table or transformation step, designing/generating necessary metadata for reporting and OLAP
  • Modeling UI - defining measures, dimensions, levels, etc
  • CRUD operations on models
• Analyzing data using Pentaho Analyzer within Spoon

Sprint Review

<<<Recording of Sprint 1 Review and Demo>>> 

Committed User Stories

Note: Agile BI Test Plan is attached to this page. Click Agile BI Test Plan to view it.

Sprint Updates

Monday, Nov 9th 2009

Ezequiel: working on implementing the mechanism for visualization plugins
Bill: cleaning up UI behaviors
Nick: working on cleaning up the controller and model code, hoping to show it off near the end of the day
James: Introduction presentation recorded, going to put up on the website. Updated the wiki space, waiting on IT for permissions. Working on new model path, working on quick visualize.
Golda: ramping up on PDI
Marina: Entered my doc related JIRAs. Spoke briefly to Brett over IM about the project name. Re-watched James' Friday demo so I could start drafting some early Wiki doc
Will: created agile-bi project in kettle repo, created kettle 3.2 branch and ci build to publish to ivy repository
Brett: Discussed with Nick B combo button concept for Visualization selection on Friday. Quick IM conversations with Will and Jake this morning to review stories. Downloaded kettle 3.2 from CI to review Agile Bi UI and UX items. Will be working with this build for Mocks. I have been working on all Mock up stories I have at this time. Burnt hours on them. Going to review mocks that I have with Jake and KC tomorrow morning. Most likely there will be some modifications but I plan to have initial mocks available for review by end of day tomorrow. All mocks and notes will be posted in UX section of wiki. I'll send out the link once they are available.

Tuesday, Nov 10th 2009

Ezequiel: Working on plugin infrastructure for visualizations. Mainly done, ready to integrate.
Bill: Moving temp code into the Agile BI project for menu customization until XUL in place.
Nick: Continuing to work on UI model celan-up. Has metadata generation working with UI models directly. Working on OLAP.
Will: Jetty server integration. Mostly ready to check-in. Checked in new model Metadata changes for Nick. Chatted with Mark about Analyzer plug-in.
James:
Golda:ramping upon PDI day 2
Brett:Decided against the combo button for visualization on the modeling screen. Keeping to what we do in our other products we will use the drop down for selection visualization method and button to invoke. Mock up will be provided shortly. After review of inital mocks and use case flows idenentified interacions/behavors that needed to be revised. Been in UI meetings all morning to review mocks and create multiple alternavie solutions for problem areas. I will not have mocks availabe at end of today as I had hoped. I will continue to move forward on mocks through tomorrow. I am blocked by other sprint meetings.

Wednesday, Nov 11th 2009

Nick: Checked in the refactored modeler code into the agile-bi project.  Looking into model generation code.  Looking into menu system to support Bill.
Kurtis: Updated JIRA to AGILEBI, did some knowledge transfers to Marina.
Marina: Decent conversation with Kurtis this morning.  Moved a very early draft of doc to the project page of the wiki, based on James' demo and Kurtis' feedback.  Mushing stuff through my brain.
James: Attempting to move the publish and quick visualize stories down the field.  Creating a client for the connection service, also making it possible to publish metadata models as any name.
Golda: no update, doing testing on PDI 4.0
Brett: Continue to move forward on mockup stories, working them all in parallel.  Doing research on other types of tools for scenarios, hoping to present tomorrow at the team review.
Will: Checked in embedded bi-pllatform assembly code into agile-bi, discussing Kettle 4.0 features, some which overlap with requirements of Agile BI (plugins, repository, etc).
*Ezequiel:*Integrating the work done so far for the visualization plugins into the 3.2.3 agile bi project.

Thursday, Nov 12th 2009

Marina: Added content and moved it to http://wiki.pentaho.com/display/AGILEBI/Documentation (Documentation)
Brett: Presented UI storyboards for team review. Blocked on PDI 4.0 meetings.

Friday, Nov 13th 2009

Marina: Did some cleanup on the content early this morning before the PDI Sprint 4.0 planning; don't have anything planned for this sprint for the remainder of the day. My focus is completing PME Guide and other deliverables for 3.5.1 GA.
Bill: Working on getting menus in there, making good progress.  Up next , popup menus.
Nick: Working on menus, very tricky conditional behaviors.  Menus, fly out menus, and combo boxes are now supported.
Ezequiel: Got the visualizer running.  Updated the xerces in agile-bi, had to download xul-runner and install it.  Had to figure out the URL.
Brett: Blocked by PDI 4.0 meetings, working on collecting feedback from the review.  Scheduling a meeting for Monday.
James: Lunch.  Still working on the connection service client, next task is to work on a very simple dialog. 
Will: PDI 4.0, dealing with 1.6 fallout.

Monday, Nov 16th 2009

Brett: Team design session to review impact of perspective concept on current stories. Reviewing latest modeling UI and identifying any behaviors we might address for this sprint. Also looking at creating additional sketch wire frames for investigating perspectives UI. Going to be blocked for remainder of day on other sprint tasks.
Ezequiel: Wrapping up the work on the viz plugin.  Spoke with Nick, going to work on Modeling exception handling.
Marina: No Update.
Golda: Download Agile BI Project, need help working with it.
Will: Implemented AgileBIDatasourceService, VFS support for embedded platform metadata / mondrian file access.
Nick: Finished reimpl of the application menuing system in SWT-XUL.  Also added support for cascading menus.  Today I committed changes for acceleration support of menu items.  Also implemented popup-menu support.  Committed initial passthru of exception handling.
Bill: Unblocked thanks to Nick.  Got the menuing system in, showing key names instead of i18n as of now.  Next up, enable and disable menu items, and contextual menus.
James: Still working on the publish story, I have a datasource publishing, I can see the datasource in the admin console and test it.  I'm going to work on a prototype of the perspectives switch.

Tuesday, Nov 17th 2009

Nick: Working on Analyzer help dialog,at the same time knocking out an analyzer bug.  
Brett: No update.
Bill: I18N checked in for menus, working on enable / disable for the menus.  Continuing to work on menu system.
Ezequiel: Model exception handling is done, along with some code refactoring.
Golda: No update.
Will: Worked on embedded JAR issues.
Marina: No update.

Wednesday, Nov 18th 2009

Ezequiel: Working on serialization. period.
Golda: Downloaded Agile BI,  looks like there is some issue with models showing up, and with the right click menu.
Bill: Got the popup menus working and the internationalization working, now working on  enabling / disabling.
Marina: Downloaded Agile BI, got a general idea where were going.
Nick: Fixed the analyzer help, now popups a div.  Working with Ezequiel to hammer out a serialization strategy.
Will: Working on free analyzer integration.
Brett: Brief conversation with Nick regarding modeling UI.  Will use tomorrow's review as a check point for UI decisions.  Mostly hands off.

Monday, Nov 23rd 2009

Nick: Checked in Save / Open Model functionality.  Required kettle spoon changes.  Got the Agile BI plugin adding items to transformation popup menu.  Going to work on toolbar implementation.
Marina: With help from Nick and Golda looked at current build, saw transformation in action.  Doc Blocked.
Golda: Started to write test plan, logged a bug, when you have a field name which has type text, it wouldn't create a table.
Bill: Got all the menu systems working, needs testing.  Got the dynamic menu building thanks to the help of Nick.  Now working on getting Bindings resolved so we don't have to use this giant update menu.
Will: Completed initial implementation of free analyzer, including save and open.  Working on kettle integration of save and open, going to start work on launcher.

Tuesday, Nov 24th 2009

Bill: Still messing with getting the bindings right to remove and add them at the proper times.  Also going to work on the toolbar.
*Golda:*Downloaded latest CI build, works without bat jar issues.
Will: Implemented launcher.jar for Spoon.bat and spoon.sh, working on open and save of analyzer reports.
James: Some of my unblocker publish code checked in to trunk, need to merge into 3.5.2
Nick: Checked in Spoon UI plugin infrastructure, no more runtime code in spoon to exec agile bi.  First stab at toolbar implementation, text, images, tooltips, separators and click support.  Unblocked Gretchen on PDI 4.0 sprint.  Now we can bind on selected items on a table or tree.  Also issues with popups and dialogs.  Started writing unit tests for serialization / deserialization.
Marina: Downloaded latest build, played around.  Also did some documentation updates on the introduction to Agile BI. Plan on continuing tweaking the doc. 

Friday, Nov 27th 2009

Marina: Performed a light edit of the Agile BI Test Plan and posted a PDF copy on both the open and iWiki Sprint pages.

Monday, Nov 30th, 2009

Brett: Getting back to UI reviews.
Bill: Unblocked by Nick on toolbar stuff.  SWT / XUL weirdness.  Getting other menu bars up to speed, including strings.  Need the mode that we cannot use.
Nick: Lots of SWT/XUL support for Bill and Gretchen.  Got Kettle and Agile BI built, working on dropping in Analyzer.  Working on interaction between modeler and visualizer. 
James: Migrating changes into Agile BI branch before committing.
Kurtis: Got app working on the Mac.  Right click menu is not working.
Golda: Plugged in Analyzer, Modeler tab would not show tab name, also had save and save as issues.
Will: Code review of agile bi version of Analyzer.  Fixed issues with Mac and Windows users.  Working on review items to complete analyzer integration.
Marina: Blocked due to no UI. 

Tuesday, Dev 1st, 2009

Brett: Working on designs for next sprint.
Bill: Working through toolbar.  Massive check-in soon.  Still need a couple of days.  To fully remove xul, there is a tab implementation.
Marina: Knowledge transfer with Nick.  Finished creating wiki page for M1.  Playing with app.
Kurtis: Ran through this morning's build.
Nick: Lots of fixes, tab renaming, save, go to vis requires save.  Fixes to reordering of levels, removal of hierarchies fixed. Model name is being rehydrated.  Got rid of none agg type, still not honoring previous selections. Updated terminology in save / open.
Golda: Testing CI builds.  Found lots of bugs.
Will: Completed Analyzer distribution, finished culling of BI Server, fixed bugs, wrote build doc.
James: Still working on getting stuff merged.

Sprint Retrospective Notes

Positives

• Got a lot of stuff done
• Shared tasks well, firing on all cylinders
• Ahead of team UI design-wise
• Identified perspectives early, better UI design time management
• Good communications between doc and qa
• Having CI to test for quick iterations

Negatives

• Need better estimations
  • XUL menus, popups, toolbars were a surprise
  • Quickly de-scoped repository
  • way over committed
• We need to do a better job at updating story acceptance criteria when decisions are made
• Need more doc feedback
• Dev setup is bad