This is great, thanks Callum. The information I was looking for is in the dsod_criteria_tab table. I then ran the following SQL to extract all the filter criteria, per repeater row. This will allow me to review all the filters for all BA/BR reports. The result is similar to what you see in the Advance Filter Criteria section. SELECT template_id, set_id , LISTAGG(c.dimension_item_id || c.fact_item_id || c.operator || c.bind_value, ' ') WITHIN GROUP (ORDER BY function_no) AS CRITERIA_TEXTFROM ( -- criteria row functions in order select * from dsod_criteria_tab c where c.template_id like '0%' order by 4,3,2,1 ) cGROUP BY template_id, set_idorder by 1,2; I tried a database UPDATE of the bind_value for one criteria. Unfortunately, after the update is committed subsequent downloads of the BA/BR report don’t show the change to the bind_value. It would be nice to be able to UPDATE the values. But it appears that we need to make the changes in the BA/BR reports themselves. At leas
Yes, the print agent logs show a successful connection and the pickup of print jobs routed using the Printer Definition Page, Report User Printer tab. However, when routed thru report rule the agent continues to check for print jobs but report that none were found. This is a bug with Report Rule: After extensive testing, we found that the report rule is not doing what’s necessary -- whatever that is-- to allow the remote print agent node to see the print job and pick it up. Since the report rule is able to do everything else we left the rule in place and setup the Printer Definition Page, Report User Printer tab to make the rendered report visible to the print agent. This two-part solution, while ugly, does work.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.