The main one that got down to some of the useful details was this one. http://ciobriefings.com/Publications/WhitePapers/DesigningtheStarSchemaDatabase/tabid/101/Default.aspx highly recommended reading.
When I finally get my stuff together and have a nice re-usable package i'll probably post a write-up and relevant code somewhere (maybe the bakery?). On Sep 19, 6:39 pm, BrendonKoz <[EMAIL PROTECTED]> wrote: > Martin, I would be interested in reading over the articles you read > while researching this topic. Do you happen to still have any of them > bookmarked? > > On Sep 19, 7:20 am, "[EMAIL PROTECTED]" > > <[EMAIL PROTECTED]> wrote: > > I have been scratching my head a bit recently with similar requests. > > I quickly found articles about "Star Schemas", dimensions and facts... > > and realised that really advanced reporting for any application could > > easily become a whole application of its own. > > > Solving this quickly, I would recommend you look at one of the > > available products and projects devoted to creating reports and > > "business intelligence" (as they like to cal it). > > > If you have more time and an interest in trying to build the reporting > > module yourself, I put part of my code up on the paste bin. It shows a > > custom find function I wrote for finding facts based on any dimensions > > I want.http://bin.cakephp.org/view/1729436874 > > > You need some understanding of the theory though. I just started > > reading about this earlier in the summer out of necessity and I am > > hardly an expert. The cool thing is that once the data you want to > > look at has been gathered into this new schema you can very quickly > > query the data in many different ways. > > > A quick overview: > > First you need to figure out your facts, dimensions and grain ( number > > of sold products <by client> <per day> would give you a number-of- > > units-sold fact, a client dimension and a time dimension with at least > > a daily grain.). > > Then you need to take your normal data and create facts and related > > dimensions in your new "reporting tables". > > Then you need to figure out how best to query those facts to get the > > data you expect. This is where I created a general find function that > > I can use for any fact and any dimension I have. > > > good luck :) it's a whole new world of reporting I never knew existed. > > > /Martin > > > On Sep 19, 5:56 am, AussieFreelancer <[EMAIL PROTECTED]> > > wrote: > > > > Hi All, > > > > My client is requiring some reports, their site is built using 1.1, > > > but they would ideally like the ability to completely customise the > > > report, so for example, they choose the tables included in the report, > > > and the fields etc. > > > > I think that maybe it isn't possible due to the amount of combinations > > > that there could be, but I was wondering if there is already a module > > > that achieves this, and if not, if anyone has any thoughts on how I > > > could achieve this, if it is even possible. > > > > Thanks > > > > Patrick- Hide quoted text - > > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
