Archive

Archive for the ‘Uncategorized’ Category

Spreadsheet Audit and Control in SharePoint 2013 Preview

August 22, 2012 Leave a comment

One of the Great New Things (TM) in SharePoint 2013 is the technology Microsoft acquired from Prodiance. This allows organisations to discover and audit the spreadsheets within their organisation. The spreadsheets could be tracked based on number of attributes (some of the more relevant to BI are data connections, conditional formatting, data changes in Pivot tables, file size). Once a set of critical spreadsheets are identified, users and IT administrators can compare spreadsheets
individually (pair-wise) for data consistency, formula errors etc. with Inquire in Excel. You can find out more here: http://blogs.office.com/b/microsoft-excel/archive/2012/07/26/office-business-intelligence-the-way-people-experience-data.aspx

However if, like me, you want to get the server bits for this and evaluate them, it can be quite tricky to actually work out what to download. Well, this is what you need:

http://www.microsoft.com/en-us/download/details.aspx?id=30353

 

Advertisements

Bubble-up Exceptions in SSAS KPIs

June 16, 2011 Leave a comment

A requirement to see, at a summarized level, how many exceptions appear at lower points in a hierarchy is a pretty common OLAP scenario, known as ‘bubble-up exceptions’. ProClarity’s KPI Selector did a great job of defining these, but when it’s not available, you can define them as a SSAS KPI. An example from AdventureWorks showing how many products there are with below 37% GPM (paste into the Value Expression in BIDS):

IIF
(
    Count
    (
      Filter
      (
        Descendants
        (
          [Product].[Product Categories].CurrentMember,
          [Product].[Product Categories].[Product]
        ),
        
            (
              [Measures].[Internet Gross Profit Margin],
              [Product].[Product Categories].CurrentMember
            )
          > 0
        AND 
            (
              [Measures].[Internet Gross Profit Margin],
              [Product].[Product Categories].CurrentMember
            )
          < 0.37
      )
    )
  > 0,
  Count
  (
    Filter
    (
      Descendants
      (
        [Product].[Product Categories].CurrentMember,
        [Product].[Product Categories].[Product]
      ),
      
          (
            [Measures].[Internet Gross Profit Margin],
            [Product].[Product Categories].CurrentMember
          )
        > 0
      AND 
          (
            [Measures].[Internet Gross Profit Margin],
            [Product].[Product Categories].CurrentMember
          )
        < 0.37
    )
  ),
  NULL
)

.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }

Here’s your result:

image

Categories: Uncategorized

MOSS/PPS/SSAS Testing and Tuning

June 8, 2009 2 comments

I often refer to the Charlotte-Mecklenburg Schools’ dashboard in my presentations, workshops etc. as it’s a live, internet-facing, real-world implementation of PerformancePoint that anyone can visit. I’ve also recently discovered a blog post from David Darden that talks about the testing and tuning of an internet-facing PerformancePoint dashboard. I don’t know if the two are related, but taken together they do offer a great indication of both the design process and final outcome of a dashboarding project.

He makes some interesting points about the security methods chosen, hardware configurations, load testing and very specific tuning methods for this scenario. Most interestingly, some hard and fast performance stats:

“With our heaviest test case, I was able to run 1,500 concurrent users. The WFE processor was at ~70% utilization, averaging 300 requests per second with no contention or queuing. The database server was at ~20 utilization, no issues. Responses were < 1 second, with an average response time of ~.3 seconds”

Good read for anyone looking at PPS in large user volume scenarios, especially web facing…

Categories: Uncategorized

Time’s Best Inventions of the Year

November 7, 2008 Leave a comment

Time magazine produce a list of the best inventions every year, ranging from cars, to robots, to gadgets and even software. Top of the list this year was the Retail DNA test – controversial decision in my opinion as DNA testing has been around for quite a while but as Time’s commentator says, this is the sort of thing that cannot be un-invented; there will now always be demand for DNA checks from the general public.

For me, the entry I’m most pleased about is number 15: Dr Horrible’s Sing Along Blog. A 3-part evil villain musical comedy (seriously) created by Joss Whedon (of Buffy the Vampire Slayer fame), it really proved the potential for success of episodic, internet-based content. Not only was it truly fantastic and hilarious, but despite being written during the American writers’ strike it’s enjoyed huge success. Originally free to watch on the website, I now have one major issue with it: the decision to make it available for download only via iTunes. I don’t like their DRM and format specific stance and I’m really surprised that Joss Whedon hasn’t chosen a more universal distribution method. Ah well, maybe one day hulu.com will be able to show it around the world.

Categories: Uncategorized

Radiohead

June 26, 2008 Leave a comment
Awesome. Just got home from Radiohead playing Victoria Park, London. I’ve wanted to see them live for such a long time, and they didn’t disappoint! They did a really good mix of old and new, a bit of Lucky near the start, the fantastic Everything In It’s Right Place and Idioteque in the middle which really got the crowd going, and finished with Karma Police and Iron Lung at the end. Fantastic.

Pictures in the mobile pics bit of this site…

Took an age to get home though 😦

Categories: Uncategorized

Joy of Joys

March 19, 2008 Leave a comment

Portishead are back with a third album, originally entitled ‘Third’:

p6_2

Heard the first track, ‘Machine Gun’, on Zane Lowe’s show tonight and love it. Certainly not to everyone’s taste, but I have a soft spot for any band who list the Wurzels as an influence

Categories: Uncategorized

Lone Server

January 13, 2008 Leave a comment

Ok, I’m a) enough of a geek to find this interesting and b) enough of a Microsoftie to find this funny:

www.loneserver.com

Either way, I think it’s great that MS do the ‘eating your own dogfood’ thing in quite such public and exposed roles. The first scene in the alley reminded me of a pic I took in Seattle:

2003 in the bin

Categories: Uncategorized