August 2010 | Omicron Llama

August, 2010

28 08 2010

Getting the current date with MDX – Another Way

Jimmywim | Analysis Services, MDX, OLAP, SQL Server, SSAS | 0

I’ve been dipping my toes into the black art of MDX (or MultiDimensional Expressions) and I had a requirement whilst building a KPI that I needed to get the current date from a Dimension I had called “Date”. I had been linked to this blog: http://my.opera.com/duncans/blog/using-custom-sets-in-analysis-services-to-deliver-special-date-ranges-to-end-use but couldn’t for the life of me get his first […]

10 08 2010

SharePoint Search API Gotchas

Jimmywim | moss, search, sharepoint 2007 | 0

I’ve been working with the SharePoint Search API lately to aggregate data across site collections, and came across a couple of gotchas that I’d thought I’d share. CONTAINS keyword & searching for a phrase with a space Let’s say you want to extract results that only exist in “Shared Documents”. You will need to construct […]