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 [email protected] 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 -~----------~----~----~----~------~----~------~--~---
