muhammadaqeel
asked on
Date dim issue in report studio
we have 8 reports, and each report could be seen with different time line daily, weekly,monthy, yearly...is there any way in report studio to dertermine date range dynamically and have one report tht takes tht parameter and run the repot.....currently for each timeline we have one report so if v have 8 reports and 5 timelines....it will be 8 *5 .....tht i dont want....one other solution is to make a routine in FM to determine date rage from date dim..and give tht to report studio.....
I'm not sure I follow your report logic. How is the date range determined for each report? You can easily design your report to generate things like year to date, month to day, etc off of a single parameter.
ASKER
okey v hav one prompt page ...that allows user to select the report and select the time line...lets say repror is sales and time line is yearly.....so wht report authers are saying as sales report could be daily, weekly,monthly or yearly they hav to create 4 reports.....as inorder to get the date for weekly and monthly they hav to create a join to the date dim at report level....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.