No, not all over the place but for in all the conformed dimensions used in the full outer join. I think this function is applied to those columns for which Nullable is set to True in the physical column property. I just changed this property for on e of the column where this function was not applied and it resolved the…

Thanks Christian for your response. I am okay with the way the cross-star join is happening and it is difficult at the moment to make any change in the model. My only question is if there is a way to enforce SYS_OP_MAP_NONNULL function to be applied on all the columns used as join conditions?

Thanks for your response. We already have a on-premise system up and running where we have these kind of ad-hoc rules implemented. We are trying to migrate that system to cloud and hence, doing a POC with the trial version. We can create custom roles but we are not sure how to enforce a custom rule (e.g. explicit deny as…

Thank you for your reply. Can you please elaborate on your statement "but rather build and use your own (with it's own inheritance if needed)"? Currently, I am using a trial version of BICS which does allow me to create new application role and add it as member of other existing application roles but does not give any…

Thanks for your reply. There is only one consumer role available under BICS which is "BI Consumer". This gives read-only access to analyses, dashboard and visual analyzer. This will not help to achieve my requirement.

Thanks all for the suggestions. I made changes to RPD and brought "Order Type" column in first subject. I don't need a union report any more.

Thanks for your responses. The NULL value you see in "Order Type" column in the first row is a dummy value i have passed in the column formula, as this column is not available in first subject area. My requirement is to show the data in the following format - Invoice Number Order Type Invoice Quantity 17020004ITA 1001…

Thanks Asim. This has worked with some customization

Sure, let me try. But my OBIEE version is 11g and i was trying something similar in filter condition, (i did not add any dummy column in the report though) and it was throwing error when i select date values from prompt.

Hi Asim, Will this approach work if the date prompt has "between" operator and presentation variable stores two date values separated by comma?

Hi Asim, Thanks for your inputs. We already have two separate reports for "Open" and "Closed" PO in two different sections with conditions. This union report has some additional columns and user needs it in this way to do some consolidation.

Hi Robert, Thanks for your suggestion. I tried this approach, but the problem is that the "received date" prompt has "between" operator on dashboard. So, the presentation variable captures two values delimited by comma. When i run the union report without selecting any value in "received date" it works fine, however if i…

Thanks Christian and Gianni..you solution worked.

Hi Christian I am actually trying to build a report to show "Supplier Bank Branch" information (Bank Number, Bank Name, Branch Number, Branch Name). I have below tables to get this information - HZ_ORGANIZATION_PROFILES_BANK and HZ_ORGANIZATION_PROFILES_BRANCH - Both alias of HZ_ORGANIZATION_PROFILES to get Bank/Branch…

Thanks for the solution. I have a separate path created using two new alias of Tab1, i.e., AliasTab1C -> AliasTab3 -> AliasTab1D which works as expected. But i was wondering if there is a way to leverage the existing set of alias to create this alternate path and then enforce OBIEE to follow this path based on certain…

Yes correct. But, there already exist reports that use the path AliasTab1A -> AliasTab2 -> AliasTab1B and i cannot alter that (perhaps by changing that LTS priority?). But then, I have new requirement of reports which should use AliasTab3 as the bridge between AliasTab1A and AliasTab1B.

Hi Christian Thanks for your reply. This is a pure snowflake scenario where all the tables are dimension tables. The join path will be like - AliasTab1A ---------------> AliasTab2 ----------------> AliasTab1B. After the introduction of new table, which is also a dimension table, it will provide a second path to traverse…

I just created the same analysis from scratch and tried to add a new Graph View. But I got the below error - --------------------------- Message from webpage --------------------------- Assertion failure: m_bTotal != true at line 350 of inc/nq/webconnect/logicalmetadataimpl.h --------------------------- The same happened…

Hi Gianni Thank you for your reply. I am using "Oracle Business Intelligence 11.1.1.7.140715". In the report there was already one graph view available from the beginning. I have duplicated it two create two more views with different columns in vertical axis. Now i want to see the three graphs in a drop down and want to…

I tried below script , but did not work - EXECUTE PHYSICAL CONNECTION POOL "Oracle EBS OLTP Connection Pool" EXECUTE APPS.MO_GLOBAL.SET_POLICY_CONTEXT(''S'',1103)