in

Adatis BI Blogs

Welcome to Adatis blogs

Browse by Tags

  • Allocations in PowerPivot Using DAX

    Although I didn't mention it, the inspiration for my last post was the excellent MDX Solutions 2nd Edition . Whilst flicking through the book a while back, I though it would be interesting to see how DAX and PowerPivot could handle the so called 'Common Calculations and Selections in MDX'...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 02-27-2010

  • Entering Dates in PPS Planning Assignments

    In the recent PPS Planning projects that I've been involved in, the challenges have often been around subjects such as business rules, hence the often recurring theme of this blog. Recently the tables were turned though, as I was told by a user that they wanted to enter dates into a PPS assignment...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 11-27-2008

  • NativeMDXQuery Business Rules in PerformancePoint Planning

    Having posted about NativeSql business rules a while back , I though that I might as well cover NativeMdxQuery business rules also, especially as there isn't too much documentation available on the web for this subject. NativeMdxQuery is a rule implementation type that can be used with assignment...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 10-24-2008

  • Analysis Services Properties for PerformancePoint MDX Rules

    One of the great features of PEL is that you can choose either a SQL or MDX implementation for your rules, depending on what you want to achieve. Whilst the MDX rules are much less restrictive than the SQL rules, they can sometimes run slower, depending of course on how your environment is set up. When...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 09-07-2008

  • 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
Page 1 of 2 (14 items) 1 2 Next >