Assume you have following objects:
Vendor Dimension
Sale_Date Dimension
Sale_amount Measure
For displaying MTD figure, create a variable like below:
Variable Name : MTD
Formula : = If <Sale_Date> >= ‘1/1/98’ And <Sale_Date> <=
‘1/31/98’ Then “Y” Else “N”
(Replace the dates ‘1/1/98’ and ‘1/31/98’ with formula, which I think will not be a problem)
Now create a report with two cells. First cell will display . Second cell will have the formula:
=<Sale_Amount> Where (=“Y”)
You can follow same logic for other fields too.
Hope that helps
– Vasan
From: Chris Kesik
We are using BO 4.1.3
What we want to do is create a report summing a single measure across the date periods of Previous Day, MTD, QTD, YTD. We would like to do this for any dimension object on any measure.
For example: for Vendor divide up the extended sales in to these columns in
the report.
or for Product divide up the freight out into these columns
Vendor Name Previous Day MTD
QTD YTD
We are able to get the values for the previous day loaded date, month, quarter, and year from a metadata table.
Currently the generated SQL is restricting the result set to Previous Days data only. How do I sum up the measure for each different time period column?
Chris Kesik
BDS
714-382-5175
Listserv Archives (BOB member since 2002-06-25)