I'm not sure that you can create a filter like this: "Store Number, Product Number in ( 100, 2; 100, 3)". But it's possible and easy to use a logical subquery in filters. 1. Create and test a subquery for a filter. 2. Create your main report. 3. Start adding a filter for any column. 4. Check "Convert this filter to SQL"…

Here is the exact query (it is based on Oracle's Sample Sales Lite demo, so you can easily reproduce it): SELECT "Products"."Product Type" FROM "Sample Sales Lite" where "Products"."LOB" in (@{p_lob}['@']{'na'}) or '@{p_lob}' = ''

What do you mean by "is not working"? Does It throw an error? Or does it give the unexpected result? Or no result at all? It works for me. See this sample video. https://gfycat.com/ForsakenUnsightlyHorsechestnutleafminer

Here is the doc, that solves your issue: https://docs.oracle.com/cd/E21764_01/bi.1111/e16364/actions.htm#BIEIT1671 You need to define an alias in the <Oracle Middleware Home>\user_projects\domains\bifoundation_domain\config\fmwconfig\biinstances\coreapplication\ActionFrameworkConfig.xml Something like this: Server1…

Well, in this case, I can offer you two options. You can change this style definition at the system level. It means that all of your prompts won't show this operation label. But in my opinion, that's a too complicated solution for a small problem. Though that could be your intention, of course. If you are OK with this,…

I hope you aren't trying to invent "Limit values by" function? But here is my version of the query: SELECT "your column" FROM "your subject area" WHERE ("your filter column" in (@{your_variable}['@']{'na'}) or '@{your_variable}' = '') ORDER BY 1

It depends on the way you run your report. If you run your report from a dashboard (no matter which type of prompt you use), my solution works for you. If you start this report directly from a catalog, it won't work. For the case of a dashboard. * Create a report as usual with a report prompt. * Put it to a dashboard page.…

You can redefine label's style using a text object with the following HTML: <style> .promptOperatorLabel { display: none; } </style>

nullif("Agreement Sent Date"."Date", date '1969-12-12') ?

One more idea, that I've used today. I created a typical master-detail report with an ordinary drop-down box. And then set style "visibility:hidden;" to the column's value and header. This method is still not perfect because there is still a row on top of my detail report.

You can set in your DetailReport filter "Month is prompted" and navigate from the MasterReport to the same page (test_1) instead of the DeailReport.

I know that's not what you want to hear, but “People don’t want to buy a quarter-inch drill. They want a quarter-inch hole.” From my experience, the best you can do is to show how to solve any of the customers problems. If you come and show tables or charts, nobody is impressed. They've already seen any table and chart you…

Not a complete answer to your question, but 12c's new look is very good. We were presenting OBIEE 12c to a customer recently, and our dialogue was something like this: We: We want to show you OBIEE 12c. Cust: We already have OBIEE 11g, and we don't like it. It's ugly. We: Look at this 12c demo. Cust: Wow!