Sounds like you have missed something on the logical hierarchies and content levels of your LTS ... BI server is going to your detail table because it "doesn't know there's another aggregate" ... based on your modeling you are telling BI server what is the most efficient route -- else it's going to go to detail and…

OBIA is just the pre-built content, connectors, datamodel, rpd, web cat, etc. .... It still runs on the BI Foundation of OBIEE. 

You'll need to create a physical/logical dimension ... Dim_AgeBins Key Description 1 24h 2 48h 3 72h 4 Em atraso Create a logical hierarchy for this dimension and set the LTS levels to the detail level then in your fact table, create a logical column that evaluates the hours between (CurrentDatetime - DeliveryDatetime) and…

The circled bit in his mock-up is not part of his dimension table ... he was wondering how to add it to the chart ("make a change"). ^ if I understand correctly!

Arrears data is usually stored as Accumulating Snapshot where all of your 'bins' are keyed to your age bin dimension. As a snapshot then you can on regular intervals see the changes in a delinquent account over time. Can make practical decisions as: Do I spend the time and $$ to collect this account (first time in arrears)…

Totally not the intent of an analytics tool ... people cannot make decisions if the screen keeps changing -on-the-fly ... if you want to put changing charts on a screen build a portal that refreshed and implement the OBIEE analysis into the portal.

how do you expect to classify a fact when you don't have a dimensional key for it? how does you fact table account for a row that doesn't fit into 24,48 or 72? OBIEE doesn't make up data.

This requirement makes no sense ... but if you just want to show a chart changing by day use a slider and the user can press 'Play'.

Read the documentation on Master-Detail interactions or the ActionFramework ... Here's a blog on the subject: https://www.rittmanmead.com/blog/2015/11/action-links-in-obiee-12c-part-1/ or http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1113/actionframework/actionframework.htm

BEST: do it in ETL and store two keyed columns to join to DATE and TIME dimensions BETTER: do it in the physical column mapping of a logical column in RPD

What are you asking? given the image of the chart I assume you have a dimension that has the aging buckets (24,48,72,Late) ... so I'm not sure what you are asking.

Had you checked certification matrix I gave you for 11.1.1.9.2 you'd see 12.2.4 IS supported as a source EBS version.

Absolutely, the cube provides the best case -- if available. Most of the clients I have been at they didn't have ESSBASE as part of the mix. Currently working on a Microsoft BI stack project (shhhh!) for a new EDW and have made great use of cubes for these types of cases!

YTD is SELECT SUM(measure) FROM table WHERE date between trunc(sysdate,'YEAR') and trunc(sysdate)-1 SELECT trunc('06-JUN-2017','YEAR') FROM DUAL; <-- returns '01-JAN-2017' MTD would be: SELECT SUM(measure) FROM table WHERE date between trunc(sysdate,'MM') and trunc(sysdate)-1 SELECT trunc('06-JUN-2017','MM') FROM DUAL; <--…

If you are moving ODI repositories ... I'd ask about that in the ODI forum -- that's one you don't want to mess up! I would suggest you get a set of VMs where you can run through these moves - reset easily if it doesn't work - before you attempt this on any of your systems. There is a lot of detail and moving parts to the…

Successful BI teams have a dedicated and knowledgable DBA ... there's no 'easy button'. I don't believe you need a re-install ... you will need to run the appropriate RCU modules to get the structures into the new database - unless you have someone (the DBA) that can move structures and data to the new server.

what's changing? Sources / Targets / Environment / some combination of the three ... https://blogs.oracle.com/biapps/registering-bi-applications-data-sources

Having implemented OBIA over and over and been given these kinds of requirements ... my default way of getting performance is via the physical structure - yes, it's inflexible (a change in requirements is a restart); but it performs. Ask your client what is more important performance or flexibility; outline the trade off.…

Your answers are in the Certification matrix ... http://www.oracle.com/technetwork/middleware/bi/biapps-11-1-1-9-2-2527682.xls http://www.oracle.com/technetwork/middleware/bi/documentation/biapps-11-1-1-10-1-2706781.xlsx http://www.oracle.com/technetwork/middleware/bi/documentation/biapps-11-1-1-10-2-3093800.xlsx ^ I gave…

If you want to increase performance reduce flexibility ... your best performing approach to this is to built a physical database object that has the data pre-aggregated and pre-calculated. ^ especially if you have large row-sets;