AFAIK you first need to upgrade to 11.1.1.7+ before you can go to 12C, see: https://www.rittmanmead.com/blog/2017/02/obiee-11-1-1-7-is-it-still-supported/ But LFG is right, you've been riding a time bomb by still using 10g and you will be again if you do not upgrade to 12c before Dec-2021

@Charles M Did our answers help you? If so, please close the question.

Christian Berg wrote: ???

Sonkar, If you are planning to post more on this forum and help others I suggest you set a more meaningful display name, that will make it easier to keep track of "who said what"

Like both Christian and the nameless person confirmed: You need to handle this through setting the roles access permissions So, find the dashboard objects in your catalog and remove the write and delete permissions Acquaintance yourself with the OBIEE Security Architecture, you can start by reading:…

What (exactly) did you do already and what are you trying to achieve? To be honest what you are trying to do seems like a bad idea. Why would you grant a user permission to edit dashboards and then take away the tool to do so to make sure he doesn't? That makes no sense to me.

Yes, BMM is where (business) rules typically will be enforced. Be aware though in the BMM you should model a star model (Facts and Dimensions). Although there seem to be no real facts (measures) in the example above, you should plan ahead what measures you are planning to create analyses for, like maybe hours spent per…

My thoughts exactly :-)

Not sure if I understand your problem correctly but I think you might want to use hierarchical columns? https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-3383503F-FBDA-4EB4-99B6-C2E7C3B5F24B.htm#create_manage_dim…

Check if the datatypes of the figures that you use to calculate the percentages, are these integers? If so change them to numeric/double. Alternatively/additionally you can use Cast as Double in your calculation to make sure them outcome will be a decimal number. See also: https://gerardnico.com/dat/obiee/int

Think about your model. Is it really necessary to use union to put the Subject Areas together? Or can you identify Conformed Dimensions on which you can join the facts together? Unions are usually last resort, your model should be able to handle multiple fact querying.

@skull Happy to help, And good to see you are serious about learning to master OBIEE. Do not hesitate to ask any questions you might have.

Come on, give the him/her some time to react ;-) It's only been a few hours.

These modifications make the report to ignore both BI server and Presentation server cache thus forcing the report to always retrieve new data from the database. To learn more about OBIEE and cache you can read the following documentation: https://docs.oracle.com/middleware/1221/biee/BIESG/querycaching.htm#BIESG226…

You may be hitting cache. To avoid hitting cache you can try the following: In the Advanced tab of your analysis find the 'Bypass Oracle BI Presentation Services Cache' check box and check it Put the following in prefix: SET VARIABLE DISABLE_CACHE_SEED=1,DISABLE_CACHE_HIT=1; Make sure you click Apply SQL and save the report

Robert Angel wrote:Best of all is to have a fully formed data warehouse which is already in this structure, a prepopulated table will always out perform a self-join for obvious reasons. Yes, Especially true when the source datamodel design is poor, which seems the case in the above example

Sure, you can use an alias in the physical layer and create a join between them, just like you do in the query. Them you can put them together in a logical table source. This is very basic OBIEE 101. Make sure you understand the basics of OBIEE modelling. You can start here:…

You can put a piece of code like this in a text section on your dasboard page: <META HTTP-EQUIV = "REFRESH" CONTENT = "600"><p>Last refresh datetime: <span id="datetime"></span></p><script>var dt = new Date();document.getElementById("datetime").innerHTML = (("0"+dt.getDate()).slice(-2)) +"-"+…

Please check the certification matrix to see which browser versions are supported: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=531603553693860&id=1109260.1 Other that that I would advise you to log an SR with oracle.

Yes but I realized 'removed' would have been a better word in my question ;-)