Changing your use of information is free - from a software perspective ... the model 'out of the box' implies a given use (or realm therof). I deal in the real world and have been called back to bill the fix that was rejected at face value -- I understand the struggle. 

Is the content Levels (Contenu) the same for the DWH_STAT_FACT_ADMHOURG?

What's the grain of these facts? What's conformed?

"as the BI developer unfortunately you cannot always tell the DW developers what to do..." ^ USE of information DRIVES physical data DESIGN ... if the BI architect has no control over the physical data design -- it's a setup for failure. You MUST tell them WHAT - leave it to them to come up with HOW ...

OBIEE as a data-pump is not the intended use ... the export to CSV doesn't care what you've got formatted or set in the exclude part of a visualization. It runs the query and dumps all the rows and columns given what's in the Criteria tab.

Your question is far to vague to answer with any intelligence ...

USE of information drives data design ... the above have given you that in various forms. If you plan on summing time, then store it in a 'summable' manner.

+1 to the answers given. Next time have a properly formed date/calendar dimension and you won't ever have to do this formula again.

remove the circular joins ...

Months: 4 weeks running? 30 days running? last calendar month? last fiscal month?

The documentation: https://docs.oracle.com/middleware/12213/biee/BIEUG/GUID-663B5A97-06B1-4486-8C5E-4261B1758581.htm#biee0113

Your issue is Sharepoint and not OBIEE https://stackoverflow.com/questions/27834148/how-to-resolve-this-content-cannot-be-displayed-in-a-frame-error-crm-2013 ^ I make no statement about how secure this is - Your move to Sharepoint should have been vetted properly BEFORE the action was officially taken.

You should be maintaining consistency across the enterprise - else you end up with the issue you have.

if it is always +7 then have the user select a date, and you have a hidden request that has the date + 7, then set your main request to use that hidden request as a filter on any date in it.

You're data doesn't support what you are trying to do ... you need a flag on the row that is there is any -ve in the row to mark it 'Y' then filter for that ...

Since the free VM has the RPD and visuals - learn how to manipulate that stuff (the drawback is that you won't have any of the business domains that pertain to OBIAin there - BUT with an oracle support ID you can get the product guides so you can put together the hands on of using the RPD and visuals with knowledge of what…

SBL-BPR-00162 is coming from your Siebel Ip15 app ... Anything in here that might help? https://docs.oracle.com/cd/E14004_01/books/Reports/troubleshooting8.html

Then you must get on a project with an implementer ... you can't do it all, so have you thought about what part of it to learn? Personally, I know how the data is supposed to flow - but I'm not an ODI developer. I can rework the RPD and visualizations like a master, but I'm even better at the functional lead role. I have…

200k+ rows in an analytical tool - leads me to believe the tool isn't being used for its intent or design.... It's a system configuration item - easily found in the documentation.

No ... OBIA is not included in the sampleApp VM ... I would question what, why, and when for your learning of OBIA. The Analytical Apps are very involved and require a thorough knowledge of the underlying source systems as well (EBS, PSoft, JDEwards, etc) AND a thorough knowledge of the business domain in questions (HR,…