Post reply

Report layout for different time dimension

  • November 12, 2008 at 10:09 pm

    #383369

    Hello friends,

    My company is trying to build a report for comparison purposes.we have various fact measures to be compared .

    but each fact measure have facts in different time dimension which makes the job challenging .we have basically all the time dimensions year,quarter,month,week,day.

    basically we need to look at the historical data like how our sales and revenue were happening and based on which we are going to forecast the demand.for if the fact measure is in month and other one is in work week,the comparison is happening between pricing and the quantity which should be displayed in week in report.i am not sure how the layout should.how to we compare the data for different time dimension and create a report layout(how the report would like and what columns and keys are to be used)

    can someone help me regarding this

    for example,

    one fact measure has fact in week time dimesndion and has historical data of 100,90,80,70 products sold for rs.100,150,160,180 for jan 2005

    another fact measure has fact in month time dimesnion and has data of 360 products sold in jan 2005 (may be at a diferent location) at the price of 90 for jan 2005

    we need to compare the data for which we need to create a report and how report layout can be laid out?????

    thanks in advance

  • November 14, 2008 at 7:44 am

    #898591

    We have a plan that is in monthly buckets, where sales is in daily buckets. We spread the plan down to the daily buckets to allow more flexibility.

    Other considerations - fiscal week / month vs. Calendar month. And we also have a concept of shop days and sales days. We sell on days we do not run the shop. And if you spread something out, partial qty's can also be a consideration. We split in whole numbers, and always load the remainder into the beginning of the week.

    Assuming that your calendars are both fiscal month, I'd just extend both the Qty and $ out in the weekly buckets dim and total them up for the month. Extended Qty and $ would then be comparable to something that only had a monthly bucket.

    So no layout - but maybe a couple of ideas you'll find useful.

    Greg E

  • November 14, 2008 at 11:53 pm

    #898957

    thanks greg

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply