We are an OLAP-heavy org but have some new reporting that is detail relational but noticing that Tree Prompts only work with DMR/OLAP and 3+ cascading source prompts seems burdensome
We've used cubes as prompt sources before but that seems backwards given C8 reporting from both Cubes and DB
Anyone hurdled this before?
Have you considered drill-thru from the report using OLAP package to the detailed report using relational package?
That way, you use the Tree Prompt of the OLAP report to run the detailed report without having to use any prompts in the detailed report.