Tuesday, 28 October 2008
And this is what it looked like outside my front door this evening.
Wednesday, 22 October 2008
Data recovery in Yellowfin
So, while you’re working in Yellowfin, maybe your finger slips and you click delete, or it happens while you are thinking about something else. However it happens, you’ve done the inevitable, you’ve deleted your SQL datasource.
After you quickly add it again, you realize that just re-adding it doesn’t restore your views or reports. The CEO will be doing his regular daily review of the organization in 20 minutes and he starts with the reports.
Fire up your SQL database client, open the Yellowfin database and manually edit the following tables.
Restoring your Datasource
Open the ‘ReportViewSource’ table and look for your deleted datasource. You’ll find it because it will have ‘DELETED’ in the ‘AccessCode’ column. Change the value from ‘DELETED’ to ‘UNSECURE’. (You may need to change it to ‘ACCESSLEVEL’ if you had security applied to the datasource.) While you’re at it, make note of the value for the record in the ‘SourceID’ column. We’ll need it shortly.
Restoring your Views
Open the ‘ReportView’ table and look for your deleted views. You can match them to the datasource by comparing the value in ‘SourceID’ to the number you wrote down while restoring the datasource. To bring them back, change the value in ‘ViewStatusCode’ from ‘DELETED’ to ‘OPEN’.
Restoring your Reports
Open the ‘ReportHeader’ table and look for your deleted views. Once again, you can match them using the ‘SourceID’ column to the number you wrote down while restoring the datasource. To bring them back, change the value in ‘ReportStatusCode’ from ‘DELETED’ to ‘OPEN’.
Great, you’re all done. Restart the Yellowfin engine and you will be good to go!
Friday, 10 October 2008
Thursday, 9 October 2008
Love you dear...
Tuesday, 7 October 2008
USA vs the rest of the world
I placed 50 states in 231 seconds, with an average error of 11 miles over 6 states misplaced.
I challenge everyone else to try. I wonder who will have the best score, an American or someone from elsewhere?
Thursday, 2 October 2008
Good use of Browser Resizing
It'll open it in a new window.
Wednesday, 1 October 2008
I need a day clock.
I need a day clock this week. It's the perfect gift for the overworked IT individual.