I am new in Business Objects report

[seethina]

I am new in Business Objects reporting ,
I have products, products quantity and date column in the universe.

question 1: (in BO report)
i want the report with
products , products quantity for the the given date , product quantity for the previous date (ie given date -1).

total 3 report columns

product, currentday_quantity, previousday_quantity
product1
product2
product3

how do i do in business report. please give the steps.

question 2if i want to do in the univers)
if i want to have today products quantity (ie. current day products quantity) and yesterday product quantity for the products in the database, shall i define to measures ,one for current day product quantity and other for previous day product quantity in the univers . how do i do this.
please give the steps

Thanks you very much for your help

 

[nimmy99]

For Giving date use prompts. For date-1 use variables or formulae

 

[PruSQLer]

In the report, simply drag a dimension to the Condition panel on the bottom right and put in your criteria using the operators provided. But I don't know how you'd get 2 different dates for 2 different measures using that method. If you press the SQL button on the toolbar, you can go in and create conditions you would need for this. Just make the changes and then click the "Do not generate SQL before running" checkbox. That should do it in report.

In Universe, you would double click on the measure and fill in your date criteria in the SELECT clause box provided. But that's a pretty inefficient way to do it if you're going to rerun this report frequently. You'd be better off using a prompt to allow the user to specify the correct dates. Check HELP for how to do an @PROMPT.