Weather Woes

Personally, I love it when my weather person starts with a bit of humor before delivering bad news.

And this is what it looked like outside my front door this evening.

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.

 

No problem.

 

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!

Running Routes

Here's a neat tool to allow you to figure out your running routes and accumulate your mileage.

http://www.gmap-pedometer.com/

Happy Anniversary!!

Alright, I'll be honest, my wife doesn't read my blog, but if she someday happens to, she'll know that I'm wishing her a happy 3rd anniversary.

Love you dear...

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?

Good use of Browser Resizing

Good use of browser resizing.

It'll open it in a new window.

I need a day clock.

You know, why do some weeks just go like this?

I need a day clock this week. It's the perfect gift for the overworked IT individual.