[wdmmg-discuss] OLAP analysis
donovanhide at gmail.com
Mon Jun 7 10:35:03 BST 2010
the Silverlight bit is just a rough front-end to the OLAP model.
There's much more to see if you use the desktop client. Have a look
when you come in.
The Programme Object hierarchy is initially grouped by the short code
(eg. PO1) and then by all groups beginning with that same prefix and
then by all individiual items beginning with that same prefix.
Makes it more interesting to drillthrough.
On 7 June 2010 10:28, Francis Irving <francis at flourish.org> wrote:
> Saw it briefly last night under OSX before I went to bed, but
> similar) in front of your OLAP server, so everyone can see something?
> Will get you to show me the user interface later on too - looks like
> it did enough to do all grouping totals, and presumably graphs as
> well, that you might want easily. I couldn't work it out quickly, but
> I'm not used to Desktop type interfaces these days.
> Two things about the underlying model:
> 1. In one report it had the programme object code, without
> description. Can you somehow merge together fields from the CSV with
> their relevant _description field?
> Nearly always you need to see both to make sense of them - in most
> cases even just string cocatenating them (with a space) is better than
> them being separated off. But even better is if OLAP lets you mark
> them as descriptions explicitly, and the user interface uses them well.
> 2. For 2008/09, I agree that "Outturn" is probably the most
> straightforward interesting one to use. However, for 2009/10,
> "Outturn" is only up to date to February (apparently, I haven't
> checked in the actual data) and won't be ready until probably
> September - instead use the latest forecast which is "Forecast
> Outturn March". (Although that is split by month making comparing more
> complicated... And no doubt has other accounting differences)
> On Mon, Jun 07, 2010 at 12:14:15AM +0100, Donovan Hide wrote:
>> I've put together a rough package of the COINS data using Analsysis
>> Services and a demo of a Silverlight OLAP viewer. It can be seen here:
>> Silverlight is required and Moonlight doesn't work, unfortunately.
>> Click "Open" in the top left and then select "Shared Folders". Choose
>> one of the reports and have a browse!
>> You can drill down by clicking the "+" icons.
>> Feel free to build some more reports. Remember that "Data Type" is
>> best set as "Outturn"
>> wdmmg-discuss mailing list
>> wdmmg-discuss at lists.okfn.org
More information about the openspending-discuss