Hi Camilo, if there is a key between the two tables, or a bridge with a key(s) between the two tables such that every entry in the driving fact has a 1:1 join then all you have to do is drag the column across to the other fact and your query will work okay. If your keys don't do that for you, then the result will not be…

On 2 if you use the option to keep references to the original name then other dashboards etc navigating in will still work, it is after all possible that people are landing on your dashboard from other systems.

Not as standard, you would be looking at using jscripts for this, see; - https://www.rittmanmead.com/blog/2013/06/embedding-a-d3-visualisation-in-obiee/ And other blogs of its kind...

Another alternative is to convert the time into decimal time (sic) by multiplying the value after the dp by 100 / 60, add that to the column before the dp, and then translate the number after the dp by 60 / 100 - but I concur, your ETL developers should have given you a display time value (text!!!) and a timestamp or…

You need to set the column width to a fixed size, the size must be big enough to contain the words Product Name. Your outer container needs to be large enough such that other fields growing won't force the field to wrap. On this last comment text content that does not include spaces will force fields to expand rather than…

Hi, if you have any text in the field in question that does not have a space, or as a space very late in the string then you will find that the column will still expand to NOT break the "words" mid-word. So if you have something like this abcdefghijklmnopqrstuvwxyz 123 Then if your width is smaller than…

Sure, I can only hope to point to the moon, he has to raise his sight to see it....

Your administrator also has to give your security group rights to use html in report content.

okay; - Create a physical measure called Monthly Order Average. Use logic as below to assign values based on their number of days. Set its aggregation to SUM. pseudo logic number of orders / case when order month has 30 days then divisor = 1/30 case when order month has 31 days then divisor = 1/31 case when order month has…

Caching is no small question, I would recommend getting your head around; - https://docs.oracle.com/middleware/12213/biee/BIESG/GUID-94B30F1B-69F3-49DC-91D0-59C2CAFEC6A6.htm#query_cache_architectu… And then come back for specific areas of clarification, once you have ascertained the current aspects of your current cache…

You don't say; - is your average computed; - a. in answers b. in rpd as a physical calc c. in rpd as a logical calc If b / c you also don't say what level of the time hierarchy (if any) the calculation is set to i.e. detail / month / not set? Also, if b /c what is your calculation set to in terms of aggregation and what…

As to is red a problem, I would say 'no' for non-data warehouse sources where life is rarely simple, but 'yes' (or at least it is a warning that it is suboptimal) for data warehouse sources, where the most performant join is always a single key to key join, but others may disagree with me on this...

Yes, but one man's design feature is another man's bug, you don't always want this, so typically you either create a prompt that is not connected to the underlying column, setting a variable with it, and then explicitly filter on the variable only where you want it, or use the afore mentioned filter lock functionality.

I have noticed also that if a 'column' as a filter on it it can be 'over ruled' by navigating in with corresponding parameter from the same subject area. This is where the lock icon on the filter comes in, if you set it it prevents the filter that you have explicitly set from being over ruled.

Sure, hope you get there. Kindly also mark whatever helped or turned out to be correct for the benefit of those who follow. Robert.

My point is a crucial one. Keys are of paramount importance in OBIEE. In the AL_PERIOD_SCH_SHIP_DATE I would expect (in one row for todays date as an illustrative example); - YEAR_ID 2017 QUARTER_ID 201704 MONTH_ID 201711 WEEK_ID (I see this is not present in your table, sound of alarm bells here!!! - your week probably…

Hi Luigi, thanks for the screenshot, what I am asking you to do is to click on the WEEK key in your business model hierarchy as per your screenshot above, query the PHYSICAL column. Then when you are 'on' the physical model column use the tool to query the underlying database and ascertain if your key; - a. truly…

There are 2 aggregations. When you create any measure in the rpd you specify its aggregation. Independent of this there is also the aggregation of what answers should do as an aggregation when you add a total specifically to a report field, or to an area in a presentation or similar. It does not always make sense for the…

If you have EBS you might also want to look into OBIA for BI against EBS financials / HR etc with predeveloped data warehouse, ETLs, subject areas, dashboards etc etc

This is one for javascript, just search the board, questions of this nature have been asked before.... See => You just need to add the code to change your filters which should not be difficult.