Browse by Tags

BI Evening, TVP, 17th July 2008

I'll be giving a talk titled 'PEL Vs MDX' at the UK SQL Server Community's BI Evening on the 17th July at Microsoft's TVP offices in Reading. The content will be geared towards MS BI developers, and will highlight the differences between the two languages, with the aim that those...

Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 07-04-2008
PEL Business Rule Re-use and Pre-defined What If Scenarios

You’ve built a rule set to satisfy an original set of business requirements for calculating budget, and all is good with the world. Then, a change order is raised and approved that requires, for want of a better description, a set of pre-defined what if* scenarios to apply to the calculated budget. The...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 04-30-2008
PEL Allocate Statement Vs Associations

PerformancePoint provides you with a few options when you want to move data between models, the most obvious of which is Associations. However, there is also the powerful PEL Allocate statement.... So which method should you use to move data? Associations are very easy to setup and will transfer your...

Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 04-06-2008
MDX - 12 Months to Date

Analysis Services 2005 comes with the useful Add Business Intelligence wizard, which will assist you with numerous calculations, including 12 Months to Date. However, I tend to write such calculations myself, especially having found out that the 12 Months to Date MDX generated by the Business Intelligence...

Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 03-06-2008
MDX Stored Procedures (Part 2)

What seems like a lifetime ago I posted about MDX Stored Procedures and how we've built a helper class that provides a wrapper to an MDX query. The helper class has been stable for quite sometime now and a few people have been asking me when I'm going to release it. Well, today is the day. You...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 11-20-2007
Basket Analysis using Analysis Services 2005

My job is pretty varied these days :o) Today I've been looking at satisfying some basket analysis type requirements where, for example, we need to determine what other products customers have bought in addition to a known product. We could have used data mining for this but decided not to as, in...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 08-22-2007
MDX Stored Procedures (Part 1)

UPDATE: You can find part 2 here , along with a link to download a C# quick start. A long time ago I realised that inevitably, however well specified the requirements or however tight the deadlines are, clients always throw a curve ball. To that avail, like many, I adopt an agile approach to project...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 08-17-2007
Analysis Services Stored Procedures\Views

Whilst not changing nappies and singing lullabies, Sacha is developing a .Net mdx helper class that behaves very much like an ADOMD command and runs an mdx query that returns a data table. "Why not just use ADOMD?" I hear you ask - as Sacha mentions there are a number of reasons such as the...

Posted to Tim Kent's blog (Weblog) by Tim Kent on 08-02-2007
XML Namespaces and the ADOMD XML Reader Result Set

I'm building a generic helper class to flatten an ADOMD data set to a data table for easier consumption by default and third party .NET controls. I can't rely on the Load method of the data table, nor the CellSet object as in some cases not all the information is persisted; datatypes and top...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 07-31-2007
Best BI Blogs

These days if you want to keep up with all the latest news and developments (especially in our small little BI world) you need to follow the blogs of those who are in the know. Here are some of our favourites: An idea or two... SSIS expert Colin Kirkby (and top guy) Cutting edge! Chris Webb's BI...

Posted to Tim Kent's blog (Weblog) by Tim Kent on 06-14-2007

Page 1 of 1 (10 items)