+1

I would be asking the interviewer why the data model warrants the joining of 2 facts. If the grain is the same then there should just be a single fact.

Not sure I understand what you're asking as the way to get what you originally asked is to save the customizations and set them to default for the page and then add to your favourites. I don't think there's any other way this can be achieved.

Have you checked and compared the database properties in the physical layer of the rpd: These could potentially cause such differences.

The problem could actually lie outside of OBIEE as a matter of fact. Are both OBIEE instances querying the same data source? If not, have you checked that both data sources have the same configurations?

I would suggest that you get hold of the SampleApp Virtual Machine and you can do all of your comparisons there. Yes, you can do this type of charting by the way.

The way round this would be to save your dashboard customizations and set it to "make this my default for this page" and then add the page to favourites.

Let me start by agreeing that DDRs should be treated with caution and used sparingly to avoid security breaches as repository metadata layer is bypassed. You can technically perform conditional formatting in a roundabout way but will need to do this with HTML markup. Screenshots below show how this can be done: Finally,…

Follow the steps in the Readme document that is part of the patch

I'd suggest that you check if you might be impacted by this bug - https://support.oracle.com/epmos/faces/DocumentDisplay?id=2319596.1 and then the next option would then be to raise an SR with Oracle if this doesn't help I'm afraid.

In your screenshot, there is a configuration log file listed. Look at that and check if there are any more details of the error.

Good point @Gianni Ceresa. In 11g, there was an option via WLST to do this but the listCred command doesn't appear to be in 12c any longer.

Is the RCU DB (OBIDEVDB) correctly configured? Is there any additional information in the Configuration log file?

You can use the obieerpdpwdchg utility to reset the password.

Hi @3610897 Have you looked at this - https://support.oracle.com/epmos/faces/DocumentDisplay?id=1951733.1?

You'll need to provide a bit more information. What OBIEE version, which OS and what exactly you're trying to do

As @Gianni Ceresa said, a pivot table will do this dynamically. It just depends on how the data is stored. If there are no week 53 facts for non leap years then there won't be a week 53 column.

You'll definitely need to start off with the log files to see if there is anything happening that has been logged. That will be your starting point. If you do come across anything in the logs, share it here and hopefully it should help to point to the right direction.

those joins (across physical data sources) are done in the logical layer. The physical layer only defines joins within each data source

yes