Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to build a report Daily Sales Report as below:
Example: I want to create a date prompt where user can select a Date depending on which the below mentioned report should change.
Here is the details of the Dimension & Fact I am using for the report:
TABLE: REVENUE_FACT (Data Warehouse)
BRANCH,
CUSTOMER,
CUST NO.,
SALES,
INVOICE DATE,
TABLE: TIME_DIMENSION
CALENDAR_DATE,
CALENDAR_MONTH,
CALENDAR_QUARTER,
CALENDAR_WEEK,
CALENDAR_YEAR
DIVISION | BRANCH | CUSTOMER NAME | CUST. NO | DAILY SALES | TONS | (YTD.SALES) | (QTD.SALES)( | MTD SALES) |
1 | A | AB | 100 | 1000 | 2 | |||
1 | B | BC | 101 | 2000 | 5 | |||
2 | C | CD | 102 | 3000 | 7 | |||
3 | D | EF | 501 | 4000 | 9 | |||
2 | C | GH | 502 | 5000 | 10 | |||
3 | D | HI | 1000 | 10000 | 20 | |||
4 | E | JK | 1001 | 11000 | 13 | |||
4 | E | LM | 1002 | 12000 | 12 | |||
5 | G | OP | 5000 | 3000 | 11 |
Hi!
Give this a read: http://iqlik.wordpress.com/2010/11/27/the-magic-of-set-analysis-point-in-time-reporting/
Mike.