This content has been marked as final. Show 7 replies
Goto criteria tab on your report.
select the selection step icon (green color down arrow on the left side).
Then under selection steps, Edit your hierarchy column (start with column name).
In the new window select the top level of hierarchy and check in Override with prompt check box.
Try this will work.
Well Haree, your idea don't activate filter
My BI version is Oracle Business Intelligence 126.96.36.199.0
I've checked that hierarchy column value from Time hierarchy selected via filter on dashboard A can be sent through Go URL
to new report B opened in new window, but BI don't suppport including hierarchy column in filter section of target report B.
So, other words, I've faced already 3 weeks against the same issue.
User select in Dashboard A subset of Time hierarchy along with common filters say Supplier, but it is not possible to drill through Supplier to its Customers with keeping
selected dimensions of Time hierarchy, say couple of selected weeks of September, in new target Report B.
And I wonder why BI allow pass hierarchy column value in Go URL but don't give to use its value in navigated report.
May be it's tiime to set Patch 188.8.131.52.2 BP1 ?
Any advices greately appreciated
Thanks for the information about the bug.
I have logged a bug against EM to certify with BIP 184.108.40.206.2, EM bug 14725779.
Please wait to try out BIP 220.127.116.11.2 until EM has a chance to certify this combination in-house.
For now, you can use EM 12cR2 with BIP 18.104.22.168.0.
Thank you, mariakaval.
Could you be so kind recommend me way to pass another issue, i believe I found new bug (google don't have results for search it ) to Oracle BI support team ?
Shortly speaking, I've found BI generates broken SQL query in Answers ( the subquery has reference to table X in WHERE, but no such table X in FROM section ) in multi-star rpd..