You've just finished creating your Framework model and published it to your portal for your users. You now have the task to create a functional specification document that your users, future developers, business sponsors etc. will need to reference. The Model Report available in Framework Manager is not in a format that most users can follow so what are your…
If you need to move the tempdb to another drive in SQL Server, use this SQL:
use master
go
Alter database tempdb modify file (name = tempdev, filename = 'E:\Sqldata\tempdb.mdf')
go
Alter database tempdb modify file (name = templog, filename = 'E:\Sqldata\templog.ldf')
Go
Don't forget to modify the paths according to your own server paths.
If you ever migrate a SQL Server database from one server to another, you'll find that the database IDs get messed up when you reattach the database.
Use the SQL below to migrate the database's legacy ids to the new server's ids:
USE dbname
go
EXEC sp_change_users_login 'Update_One', 'oldid', 'newid'
Whether you're working in Cognos, Pentaho or some other BI tool, you'll inevitably be given a data element with a date format your system doesn't like.
Usually it involves a month abbreviation and having to convert it to a number.
Not all formula languages provide this type of conversion with a built-in command.
The first solution that usually comes to…
www.computerworld.com — Is it that hard to teach BI in courses?
A lack of dummy data? Haven't these professors heard of crowdsourcing? Microsoft's own dummy data is available for download.
I see a lot of excuses that might have flown 10 years ago, but they don't fly with me today.
www.perceptualedge.com — In a counter post to my previous link to a Beye white paper. While the Beye paper is really sponsored advertorial, Stephen Few's post provides better insight between the differences between "Big BI" vs. "Small BI", and the difference is usability.
www.beyeresearch.com — Registration Required.
BeyeResearch has a white paper on usability in business intelligence tools.
Keep in mind that the author is NOT a usability expert in the same vein as a Jakob Neilsen or Donald Norman, but you might find something interesting there. I didn't find anything more than common sense stuff.
The main problem with enterprise software developers is that…
