9/26/2014

ETL, Cubes, Reports and Dashboards

Been working on a new project a few days this week.  It's already mid flight for a few weeks, I'm just filling in for a few days.

So what have I been working on?  ETL a half dozen tables into the Data Warehouse from a pre existing data warehouse.  Then created some views.  Then brought into the SSAS cube.

And that's where I got stuck.  Kept throwing the same error.  Looked up every possible bug fix.  Turns out one of the existing views was limiting some of the data from the cube to speed up development processing time.  Once I knew that, applied a fix, and the cube compiled.

So the data was available for viewing, I took the old developers Power View, brought down a local copy, renamed and pushed back to SharePoint.  And changed the Data Source to the new Data Warehouse Cube.  And added the fields back.  Report #1 done.

Next up, some SSRS reports.  Took the old developers Stored Procedure on to the new server.  Changed the table and column names to use the new ones, it compiled.  Then took his SSRS reports, created new Data Source, pointed to new Stored Proc, it ran.  Added a few parameters, uploaded to SharePoint, only problem, the reports are timing out.  And I still need to figure out Row Level Security and add one more parameter.

Then I ETL 2 giant tables into the new Data Warehouse, applied standard naming conventions, all prepped to import into the Cube this weekend.

So that was two 8 hour days of work.  And I have 3 more reports to complete by Monday over the weekend.

Monday, my other project is having their Go-Live, a real big event, the project is about 5 years in development and it should be exciting.  I'll be there for the kick off and if any problems arise with my reports.  Perhaps they'll have some additional work down the road, who knows.  I heard they are supplying bagels, score~!

After that, a new project is starting up, this one's in Orlando, doing Crystal Reports, Business Objects, Webi and Edge.  About 250 reports in total, should be fun~!

And there's another project doing some SSRS Dashboards against a Data Warehouse I created last year around this time.

So vacation's over.  Just passed my one year anniversary being a full time consultant.  Not too shabby.  No complaints from here.