Browse by Tags

• .NET
• Altius
• Business Intelligence
• Data Warehousing
• Essbase
• ETL
• Excel
• Hyperion
• Integration Services
• Microsoft
• OBI EE
• OBIEE
• Office
• Oracle
• Oracle BI
• SharePoint
• SQL Server 2005
• SQL Server 2008
• SSIS
• SSIS 2008
• write back
• Write-back

• Making public-facing SharePoint sites more accessible

  SharePoint is a great platform for building an intranet site quickly and making it easy for business users to add their own content. It is this ease of use for end users which also makes it ideal to use SharePoint for a public-facing website with its... Posted Sep 25 2009, 09:12 AM by MikeVinson with | with no comments Filed under: How To's, Microsoft, SharePoint

• SSIS 2008 – Package Restarting and Checkpoints

  A feature available in SSIS is to mange the restartability of a package following an error. For example, if you have a package with many control flow tasks and one fails, once fixed, you may not want to restart the package again from the beginning. SSIS... Posted Sep 09 2009, 11:32 AM by TomStagg with | with no comments Filed under: How To's, SSIS, SQL Server 2008, SSIS 2008, Integration Services

• SQL Server 2008 – Change Data Capture (CDC) example

  One of the new features of SQL Server 2008 is Change Data Capture (CDC). CDC is used to track changes (inserts, updates and deletes) made on SQL Server tables. Overview When CDC has been configured for a database and table, the capture process will monitor... Posted Sep 07 2009, 08:43 AM by TomStagg with | with no comments Filed under: How To's, SQL Server 2008, ETL, Data Warehousing

• Building a Custom Search Web Part Solution with Office SharePoint Server 2007 – Part 6 – Tweaking Your Search Results

  This blog series takes you through the necessary steps to configure MOSS for searching and indexing, followed by some sample code which will guide you through creating your own asp.NET web parts which you can install as features on your site. My previous... Posted Aug 20 2009, 08:45 AM by MikeVinson with | with no comments Filed under: How To's, .NET, Microsoft, SharePoint

• Building a Custom Search Web Part Solution with Office SharePoint Server 2007 – Part 5 – Building a Search Results Web Part

  This blog series takes you through the necessary steps to configure MOSS for searching and indexing, followed by some sample code which will guide you through creating your own asp.NET web parts which you can install as features on your site. My previous... Posted Aug 20 2009, 08:43 AM by MikeVinson with | with 3 comment(s) Filed under: How To's, .NET, Microsoft, Hyperion, SharePoint

• Building a Custom Search Web Part Solution with Office SharePoint Server 2007 – Part 4 – Building a Simple Search Input Web Part

  This blog series takes you through the necessary steps to configure MOSS for searching and indexing, followed by some sample code which will guide you through creating your own asp.NET web parts which you can install as features on your site. My previous... Posted Aug 20 2009, 08:40 AM by MikeVinson with | with 3 comment(s) Filed under: How To's, .NET, Microsoft, SharePoint

• Building a Custom Search Web Part Solution with Office SharePoint Server 2007 – Part 3 – Configuring the Shared Services Provider

  This blog series takes you through the necessary steps to configure MOSS for searching and indexing, followed by some sample code which will guide you through creating your own asp.NET web parts which you can install as a features on your site. My previous... Posted Aug 20 2009, 08:37 AM by MikeVinson with | with 4 comment(s) Filed under: How To's, .NET, Microsoft, SharePoint

• Building a Custom Search Web Part Solution with Office SharePoint Server 2007 – Part 2 – Configuring Domain Accounts and the Office SharePoint Server Search Service

  This blog series takes you through the necessary steps to configure MOSS for searching and indexing, followed by some sample code which will guide you through creating your own asp.NET web parts which you can install as features on your site. My previous... Posted Aug 20 2009, 08:29 AM by MikeVinson with | with 3 comment(s) Filed under: How To's, .NET, Microsoft, SharePoint

• Building a Custom Search Web Part Solution with Office SharePoint Server 2007 - Part 1 - Overview

  Recently I embarked upon a piece of development work which required me to create a custom search web part. The main driver behind building this custom web part was making the search results page accessibility compliant. This required that the HTML output... Posted Aug 19 2009, 02:30 PM by MikeVinson with | with no comments Filed under: How To's, .NET, Microsoft, SharePoint

• Putting write-back to work

  Although by Oracle’s own admission the write-back facility in OBIEE is not designed to be data entry tool, it is one of those features that are hard to ignore for long if you are intent on exploring the full capabilities of the software. However, hearsay... Posted Dec 01 2008, 10:05 PM by edhiggins with | with 1 comment(s) Filed under: How To's, OBIEE, Oracle, Business Intelligence, OBI EE, Oracle BI, write back, Write-back

• Enhance your Essbase Month dimension to aid sorting

  Following on from my last blog , I thought I would demonstrate another very practical use of joining a table to an Essbase cube. Essbase cubes designed for maximum performance and minimum size will not usually have what one might call a ‘full’ time dimension... Posted Nov 03 2008, 11:02 AM by edhiggins with | with no comments Filed under: How To's, Hyperion, Essbase, OBIEE, Business Intelligence, OBI EE

• Q. How do you load a .csv file with 4500 columns?

  I suspect that there is a quick answer to this ... you don't. You revisit the data feeds and make them much more manageable. That's not always possible, however, and recently a colleague and I were set a challenge to load some very wide datasets... Posted Jul 31 2008, 09:57 PM by JohnGamble with | with no comments Filed under: How To's, SQL Server 2005, SSIS

• Finding MS Query cell ranges in Excel

  Recently I've had the problem of picking up an Excel workbook which uses MS Query to connect to a SQL datasource and pull back lots of data in to literally hundreds of data grids. We had to point the grids at a new datasource, but the problem is that... Posted Mar 10 2008, 04:28 PM by JohnGamble with | with no comments Filed under: Office, How To's, Excel, Microsoft

• Remote working DNS settings

  Tired of manually setting the DNS settings every time you work from home, and the windows or vendor-supplied interfaces are letting you down? Use these handy command line statments (in a batch file) to automate the setting of static DNS and back to dynamic... Posted Feb 05 2008, 12:18 PM by bloguser with | with no comments Filed under: How To's, Altius

• Who knew?

  There's a dead quick and easy way of exposing events from your controls/components without exposing the component itself. Just create an event and override the add/remove handler operations. Example here: http://weblogs.asp.net/cfrazier/archive/2007... Posted Feb 05 2008, 11:58 AM by BenSavage with | with no comments Filed under: How To's, .NET, Microsoft