follow the code for doing reports in the BI. you have add more forms to have the input for the report.
========================= BJ Freeman Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52> Specialtymarket.com <http://www.specialtymarket.com/> Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man
smithav sent the following on 11/15/2010 4:04 AM:
I am using the datawarehouse model BI. I am using the already existing Date and Currency dimensions. I have defined Product, Customer, Location,Slaes dimensions in addition to them. Here Sales is a fact table. It contains foreign keys of all the dimension tables along with a field called sales. I have to now write a query that either takes yrs or location as input from user and gives the aggregate sales as output for that period or particular location respectively.
