I imagine so as the ETL is in ODI ... the caveat is: THIS TAKES A TECHNICAL (OBIEE,ODI, DBA & Data Architect) SKILLSET + AN ANALYTICS SKILLSET + AN ORACLE BI APPS SKILLSET .... all customization must be carefully planned and executed in view of subsequent patching and version upgrades.

If I have to I can create a logical star out of a single physical database table. A logical star is a must-do for OBIEE ...

Do this in the database ...

What version of apps? Independent of that ... you might have to build your own Subject Area using the pre-built logical layer or you might have to customize both logical and physical layers to get what you want if you can't find pre-built. Be prepared!

"Facts are kind of snowflake" ... oh no! "I have filters such as payment date, loan date, etc. in fact tables" ... nope! these go in dimensions ... Given what you've said in your post your fact star model should look like: Dim - Date attributes related to dates: year, month, week, date, fiscal period, same date last year,…

You might be better off searching and/or asking in

Dashboard AND huge number of rows -- is the problem ... the whole point of a dashboard is to give the user the information they need to decide to act ... so what are your users doing with all those rows? Get to the end game and put that on the dashboard! Think of your Tachometer on your dashboard of the car ... imagine…

in the RPD or in the Answers portion of Presentation Server?

To be using Oracle software in production without having access to the Support Code is not a good move. Find out who in your company has that code, get yourself a login and badge it to the code.

have the user switch the output format back to PDF ... run the report As a developer you can set the outputs by template for a report ... view your template(s) as a list, then:

Give this a look ... https://www.rittmanmead.com/blog/2010/08/oracle-bi-ee-11g-reporting-on-clobs-lookups/

Ownership and permission are two different things ... From the document: To create an agent, users must be granted the Create Agent privilege. To enable users with the Publish Agents for Subscription privilege, which provides the ability to change or to delete an agent, you must grant them the Modify permission to the…

I don't see an error ... What do you get when running the physical SQL against the oracle DB ... does that return results?

Wrong tool for the job ... OBIEE isn't great at DB dumps

I'm reminded of the request for big data to ensure performance and not understanding a big data mining query can take days/weeks to process ... wrong tool for the job ... what's the JOB? The REAL requirement? was it accepted and vetted by those who UNDERSTAND the capability of the tool? was performance designed up-front?…

winging it means most likely backing out; backing out means a lot of work ... "don't have time to do it right? when will you have time to do it twice?" ... best to 'wing it' (if you must) with a VM first - then you have an idea of the gotcha's and the quirks of your own environment and set up -- with a VM you can take an…

Add the unique row key from the database to your analysis just to make sure you have it right ... the display is showing correctly given the QUERY GRAIN ... you need to pin that grain at the same level as the TABLE GRAIN to get what you want.

Make it happen in a spreadsheet FIRST applying the rules of EFFECTIVE permissions ... plan before you implement. Also DESIGN FOR PERFORMANCE ... if you have a large set of users and many rows of data to secure performance can kill your whole show. There are many ways to skin this cat -- find the best that works for your…

http://123obi.com/2012/06/obiee-11g-expanding-hierarchy-column/ ^ simple google search = answer in seconds

This seasoned professional says follow the guide and if it's your first go have a seasoned professional partner to guide you; do ONE at a time PS: the version of OBIA has a lot to do with how you configure ... the newer ones use BIACM (to varying degrees) and the older ones are via domain files.