in

Adatis BI Blogs

Browse by Tags

  • XLCubed Version 5 Released

    Interesting to see yesterday that XLCubed have released version 5 of their popular OLAP reporting tool. As I've mentioned before , I've always found XLCubed to be very powerful and easy to use, and therefore, in my opinion, it's definitely one of the best Excel OLAP reporting tools out there...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 03-13-2009

  • Analysis Services 2008 Performance Guide

    As Chris Webb has already blogged, the Analysis Services 2008 Performance Guide has now been released. Like the 2005 version, the 2008 guide contains a wealth of information and is a must read if you are trying to tune either query or processing performance in Analysis Services. The document can be downloaded...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 11-17-2008

  • Day 1 at the BI conference

    So here we are in Seattle at the BI conference.  Day 1 and it's been great to catch up with some old faces and meet some new ones.  We were promised some big news today and as is being reported by Chris , Mosha , Marco and all, we weren't disappointed.  Both "Kilimanjaro"...
    Posted to Tim Kent's blog (Weblog) by Tim Kent on 10-07-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

  • SQL Server 2005 Cumulative Update 8 for Service Pack 2

    Microsoft have just released Cumulative Update 8 for SQL Server 2005 Service Pack 2. Amongst the changes are a few fixes for small problems in Analysis Services, such as: Infinite recursion occurs in the CalculationPassValue function in SQL Server 2005 Analysis Services; A data source view that connects...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 06-19-2008

  • XLCubed Version 4 Released

    XLCubed Version 4 was recently released, adding support for increased data visualisation via MicroCharts, as well as enhanced web publishing. I've been using XLCubed since version 1 and have always found it both powerful and easy to use. All the standard functionality that you'd expect from an...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 06-11-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

  • Setting up PerformancePoint Monitoring Design Role Security

    There's lot of info out there about setting up the application pool identity so that you can set up data sources for dashboards ( For example ). However there seems to be very little about the various roles that are used in the Dashboard Designer and how to set them up. If you try and connect to...
    Posted to Tim Kent's blog (Weblog) by Tim Kent on 11-01-2007

  • Multi-dimensional modeling (ADAPT)

    Everybody hates documentation but this is a really neat, free tool for modeling multi-dimensional databases and is particularly suited to MSAS 2005. ADAPT™ (Application Design for Analytical Processing Technologies) from Symmetry Corporation is a Visio stencil. Example of a time dimension is shown below...
    Posted to Tim Kent's blog (Weblog) by Tim Kent on 09-30-2007
Page 2 of 3 (25 items) < Previous 1 2 3 Next >