+ to @Robert Angel If you can't immediately act CONSISTENTLY, ACCURATELY and QUICKLY from what is on the screen, then what's on the screen is of no or little value.

Large IT project ... no ... a viable business initiative looking for value out of it's data assets, yes.

Seems to me you need the dimensional hierarchy in the subject area that has the factual data ... use of information drives your design of both logical and physical data models. Are you the BI developer or a business analyst? If the former, learn the modeling techniques needed ... if the latter, make the formal request to…

Use of information drives data design ... you either have to store a summary (physical) like that and/or your model (logical) has to support such use ...

Unclear for sure ... "Classic Insight" is Eloqua ... so the assumption is that the OP asker is trying to a tool-for-tool migration or comparison ... THE ANSWER: yes ... modeled correctly -- the OPster can have this.

Please address all licensing questions to your Oracle Account Rep ...

I've seen some clients with the scheduling data model with a host of triggers for various reasons; I've also seen the schedule trigger built in the report by report models ... I'd go former if you are doing a lot of scheduled/bursted reports. Manage it as simply as you can.

You create the schedule trigger in the data model of the BIP report you want to burst... or you have a separate model that has the trigger in it. No triggers in the drop down means your selected model doesn't have one built.

Database ... pga_aggregate_limit Tips

You should have a basic set of logical metrics for each measure you have ... use of information drives data design. When a client says they need 'Sales' ... my response is "by what over what?" From there if I have a simple "by Employee over Month (monthly)" then I automatically build: Sales Sales Year-to-Date Sales Month…

Give the whole error message ... you are missing the crucial parts ...

Use of information drives data design ... you should be storing the vetted and approved short forms in the the Data Warehouse if the source system doesn't have capability for it. Make an honest attempt to get it implemented there - then you'll have consistency across any/all systems sourcing from the DW. If not there then…

Well played!

let's meet in the middle ...

You mean I can't use it as my ERP front end?

If it was working ... what changed before it stopped working? Deleting records doesn't seem to be the proper way to go about debugging. You might have to start over - if you've truly got a broken setup.

did you complete the first step: https://docs.oracle.com/applications/biapps102/install/GUID-63781877-40B2-49D4-ABF3-DF51E9A31910.htm#BIAIN-GUID-63781877-40B2-49D4-ABF3-DF51E9A31910

I've been away ... @Robert Angel has hit most of the points ... basically it comes down to not having a BI Professional vetting requirements. If there is a true need for a dump - then do it straight from the database; run the subsequent analysis and tinkering AS A DISCOVERY PROJECT. At the end make the decision to either…

"...replicate my current Cognos reports ..." very shaky foundation. Approaching in this way will bring failure. What information is critical to the business, when is it needed and to whom should it go? If you are just going to recreate Cognos reports - then all you've done is spend money and time. Why excel output?…

If you want the result to be additive (and) re-usable - then yes, implement in the data warehouse. Restate the snapshot fact nightly (as days is the smallest date granularity you are going to) and forget this front end logic. Now you can easily do MAX, MIN, AVG, etc and if you store it over time (by dating the snapshot)…