Please review:
fb_bi_cust_ord_lines = Currently used by SQL server to retrieve data for use in Cognos
Other views and tables subsidary.
For further information and background please use link below
Linked to http://dba.stackexchange.com/questions/44831/creating-and-tuning-a-materialized-view-in-oracle-for-use-by-cognos-bi question
for use by dba.stackexchange users