Hi, Just came across this blog where it seems that instead of full outer joins, left outer joins are used. I am not sure about whether or not an upgrade to a higher version from 11.1.1.7.0 would help and even if the higher versions use the left outer joins, the scenario described using the SH schema (based on the actual…

Thomas and Christian, thanks once again. Christian, the DBA spotted a full outer join in an OBI EE generated Query, hence his questions about why and how. He asked whether or not an equi join could be used but the business needs a left outer join as described using the SH schema. I guess the only option is using a database…

Thanks for your reply, Thomas, to which I agree. It's sometimes bit confusing for me to explain to a colleague what OBI EE can do and can not. For example, if I were to model the BMM Layer based on an OLTP schema, how the joins can be configured. But as a true Star Schema follower, I agree 100% to the above. Regards, Manoj.

Thanks for the reply, Thomas. Yes, I would like to avoid the above single LTS configuration. There are three more Presentation Tables in the subject area - 'Fact - Costs', 'Fact - Costs and Sales' and 'Fact - Sales'. The 'Fact - Costs and Sales' has got two LTSs. When I use any of these, OBI EE generates a full outer join.…

Thanks Thomas and Christian. I did go through the contents of the earlier post you had suggested, Thomas. Unfortunately, it did not help in generating the correct Left Outer SQL. Below are more details about the issue. Oracle Table Data OBI EE Analysis SQL Generated Full SQL is WITH SAWITH0 AS (SELECT SUM(T61718.UNIT_COST)…

Hi, What I would like to know is how do I implement / configure the below SQL Query in OBI Repository (RPD) esp., in the BMM Layer. SELECT sf.DAY_KEY , sf.prod_key , sf.customer_key , sf.channel_key , sf.promotion_key , sf.amount_sold , sf.quantity_sold , cf.unit_cost , cf.unit_price FROM sales sf LEFT OUTER JOIN costs cf…

Ok, thanks.

Thanks Thomas. I shall try out the driving table. Other things have been tried out. Regards, Manoj.

Hello Felipe, Yes, there is a conformed dimension. For example, CDim.Col1, Fact1.MeasA and Fact2.MeasB. When used with a non-conformed dimension, it fetches data only from Fact1, for example, NCDim.Col1, Fact1.MeasA. Fact2.MeasB is automatically set to NULL by Oracle BI. Regards, Manoj.

Hi, What does your own experience say about your skills/expertise and relevant certification? You seem to have worked on different tools. And it appears that you've asked questions related to certification elsewhere. The same theory applies to OBI EE as well.

Hi Christian, Thank you for your reply. I referred to http://yangiiiyang.blogspot.co.uk/2012/05/chart-is-worth-thousand-words-only-when.html to understand the logarithmic scaling. As per an example given, I changed my graph to line. This shows me a continuous line if there is any non-null value thereby indicating the user…

Thanks Richard. I was also thinking something similar - 20/80 rule.

Okay, thanks for the feedback. I see what you mean now. Will swapping the slices and pies help?

Edit: I hope you can find a way to change the title size?

Hi, Did you consider using filter based on results of another analysis? As the data between the two columns is more or less the same, it might work. Regards, Manoj. Edit: Looks like the revenue has both the dimensions. So, where is the issue? If you filter the second report by Org, then that should also work, right?

OBI generates SQL Queries, sends them to a backend source(s) so that once the data is returned, it can display on the UI. In your case, however, there seems to be some issue with the execution of the SQL generated by OBI. Did you refer to Oracle Database Manauls esp. related to Data Definition and Error messages? What does…

Yes, there are some issues / bugs with later changes to the Gauge. About the other point, I just thought the thresholds are / should be relevant to only a measurement. The users may get confused whether the thresholds are related to the line or the needle. May be you could: 1. Use a narrative view for the forecast or if…

Hi, What version are you using? 11.1.1.7.0 seems to be working if I've understood the issue correctly. Regards, Edit: The UI seems to be confusing, though. Do you really need it that way?