Omicron Llama

Coding all day, every day.

August, 2010

Getting the current date with MDX – Another Way

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 […]

SharePoint Search API Gotchas

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 […]