We have 5 dashboard pages and on each dashboard page there are approx 15 prompts. Few of the prompts are on the same subject area columns on the 5 pages so you can assume that few of the prompts(columns) like Accounting Period, Lines of Business, States are repeated across the prompts. We have set the scope of all the prompts sesction across the pages to Dashboard.
Accounting Period column prompt is getting its data in this way: SELECT "Renewal Retention"."Evaluation Period" FROM "DM Retention Rpt" union select "Time Dimension"."Eval Prd Year Nbr" from "DM Retention Rpt" WHERE "Time Dimension"."Eval Prd Year Nbr" = VALUEOF(NQ_SESSION."S_RTN_Curr_YR") (values would be *2012*, 201201, 201202, 201203, 201204,...)
However rest of the prompts are getting the data in plain boring fashion (from the columns itself). We have set the APPLY button NOT AUTOMATIC as there is a huge number of prompts and we dont want the user to wait after he/she selects each value. So we have given the ability to select all the prompts and then click on Apply button. We have action links which take us from SUMMARY REPORT to DETAILED REPORT and the same filters are applied (NO PROMPTS ARE ACTUALLY PRESENT ON DETAILED REPORTS. WE USE PVs from SUMMARY Prompts to filter the detailed reports) to the DETAILED report with the help of presentation Variable (They do not get applied by default since the the aggregate navigation has not been implemented through one star model. Instead 2 star models are there. CLICK on SUMMARY STAR MODEL and it will take you to the DETAILED STAR MODEL. Don't ask why we implemented that. Its a long story.)
The project has reached production environment. There is a very confusing issue that came into picture last week. you select some prompts on SUMMARY DASHBOARD PAGE 1 and hit APPLY. The filters get applied. When you move to DASHBOARD PAGE 2, you can see that the ACCOUNTING PERIOD filter shows the value that you selected on prev page (say 201206) but it applies only the default filter say 201212, However rest of the filters say State = Michigan gets applied automatically with the Accounting Period 201212 (defaulted). We have to explicitly hit tyhe APPLY butoon to see the data corresponding to both 201206 and MICHIGAN. The issue doesn't end here.
When we click any clickable (action linked to detail) value on the summary report. It opens up a page and it pulls out all the data from the detailed report irrespective of the filters that we chose on the SUMMARY REPORT.
1. DASHBOARD PAGE 1-> select accounting Period 201206 State= Michigan Hit APPLY. 2. Go to DASHBOARD PAGE 2, you will see that selected values are period = 201206 State = Michigan. But filter applied for Default date 201212 and State = Michigan, PLEASE DO NOT HIT APPLY. 3. Click action link for example click policy count for Michigan. It will fetch you detailed data for all the months and all the states. None of the filters got applied.
1. DASHBOARD PAGE 1-> select accounting Period 201206 State= Michigan Hit APPLY. 2. Go to DASHBOARD PAGE 2, you will see that selected values are period = 201206 State = Michigan. But filter applied for Default date 201212 and State = Michigan, PLEASE HIT APPLY. Data will refresh and filters will be applied for 201206 and Michigan 3. Click action link for example click policy count for Michigan. It will fetch you detailed data for 201206 and Michigan. All the filters got applied.
This apply button problem is killing me. The client is not ready to train himself to hit the APPLY BUTTON once he changes a dashboard page. He has just one thing if he has paid a million dollars for the tool, the tool should do everything that is advertized. Aah! I hope Oracle trained their marketing/sales guys or maybe the developers to speak some truth.