I’m building up for my running challenges of 2011 and breaking in my new treadmill so I am slowly building up my miles.
On incentive is the Marcothon group on FaceBook, the basic premis is to run for either 3 miles or 25 minutes in every day in December.
I have also been mucking around with Xcelsius for a parkrun project, more on that later.
To keep an eye on my progress I have built a dashboard to track my running over the current year and so I can visually compare my training year on year.
photo credit: eshm
I was having a flick through my employment contract and I found the following clause:
You agree that during the course of this contract and after the termination of the contract for whatever reason without limit in point in time you will keep in confidence and shall not disclose to any person unless authorised to do so with the prior written consent of the Company the following:-
13.2.1 Any consultancy know-how, methods, tools, techniques or intellectual capital.
I realised that some of my blog entries or tweets could fall foul of this clause so I asked for written permission to continue blogging generic “work related” content such as Business Intelligence, Data Warehousing, Data Modelling and Business Objects.
Rather than granting this and leveraging the fairly good google rankings that my posts seem to get I was asked to remove all work related posts. Business Objects Best Practice (higher ranking than BusinessObjects.com) Business Objects New Features (Page One) Dimensional Modelling (Ralph Kimball ?)
As such I have password protected all of my work related posts.
If you are struggling to find content there are a variety of searches that could turn up interesting content.
Alternatively you can go to my company site, contact details can be found here or here.
This is really obvious with hindsight but it took me ages before “the penny dropped”.
Most of the time I find myself using the “Filtered Rows” option on my selectors.
The main selector that I want to use is the “Filter”, but strangely this does not have the option of filtered rows.
What I have resorted to doing in the past is to use multiple selectors:
A date drop down list box filters the rows from “Raw Data” sheet to the “Monthly” sheet.
A product drop down list box filters the rows from the “Monthly” sheet to the “MonthlyProducts” sheet.
A customer drop down list box filters the rows from the “MonthlyProducts” sheet to the “MonthlyProductsCustomers” sheet which now lists all of the sales made for that combination.
The filter component could do that, but this component assumes that there will only be a single row in the output. As soon as you have multiple rows in your result set then you can’t use the filter component. Ahhh, but you can with a little lateral thinking; that’s what Xcelsius is all about. Continue reading Crystal Xcelsius – Filtered Rows From A Filter Component
I know that I covered this in my video post, but I hated the quality of the video, so here is a similar post with pictures (click on hem to see larger versions).
You no longer need to splash out on fancy dashboarding software (although Xcelsius is good !) to quickly highlight when your data is changing. A new feature in Business Objects Web Intelligence (WebI) 3.0 allows you to add this feature to any document.