Hi @Rajesh Kushwaha, It seems it might be the issue of data download limit for OTBI report. If you filter the report the data is witing that limit and you are getting all rows but when you are executing without the filter the data volume is exceeding the limit and it is not bringing all rows. If you use this analysis and…

https://community.oracle.com/products/oracleanalytics/discussion/comment/70487#Comment_70487 Hi @Regie Mercado, Can you please attach the Report XML / catalog here so that issue can be replicated and will be helpful to find the resolution? Thank you.

https://community.oracle.com/products/oracleanalytics/discussion/comment/70456#Comment_70456 Hi @Regie Mercado, Can you please remove 'Work Order' & 'Report Date' columns from the Report? So your report should have only 3 columns: Item Name, Required Quantity, Primary UOM. Please try to see how the data gets aggregated.…

https://community.oracle.com/products/oracleanalytics/discussion/26921/otbi-show-only-subtotal Hi @Regie Mercado, Can you please try the following? Duplicate your existing view and take out (put into the excluded column list) 'Work Order' column, the analysis should show the total based on 'Report Date' & 'Item Number'.…

Much needed feature. It will add value and save time while executing the report. Upvoted.

https://community.oracle.com/products/oracleanalytics/discussion/26915/is-there-a-way-to-find-all-data-models-using-a-specific-field Hi @Scott Paulin, Welcome to the Oracle Analytics Community! Not sure if it is possible (Assuming you are using Oracle Fusion Application [SaaS]). But please take a look into the following…

It’s incredibly useful and helpful information. Thank you very much for sharing @Rakesh Chhoria-Oracle!

https://community.oracle.com/products/oracleanalytics/discussion/26911/some-ap-invoices-are-missing-in-the-otbi-payables-report Hi @Rajesh Kushwaha, Welcome to the Oracle Analytics Community! Can you share the report xml / catalog / screenshots of the filters that you are using? It will helpful to understand the issue…

This is an excellent enhancement and will prove to be highly valuable. Additionally, Sample reports will be equally valuable. Thank you very much @Raghavendra Raghunath-Oracle!

https://community.oracle.com/products/oracleanalytics/discussion/comment/70348#Comment_70348 Thanks for sharing the workaround. Appreciate your help.

It'll be a great feature to have. Upvoted.

Very helpful information. Thanks for sharing guys!

Very helpful & useful information. Thanks for sharing @Sumanth V -Oracle!

Much needed feature; will add so much values. Upvoted.

It’s incredibly helpful. Thank you very much for sharing @AnishaPatra-Oracle!

https://community.oracle.com/products/oracleanalytics/discussion/comment/70179#Comment_70179 Hi @Hylton, Can you please check the following discussion which might be useful. List of Deep links for Redwood Pages — Cloud Customer Connect Hope this help. Thank you.

Thanks, everyone, for providing the details. This information is really useful.

https://community.oracle.com/products/oracleanalytics/discussion/26822/help-otbi-redwood-links-for-work-orders Hi @Hylton, Please take a look into the following docs which might be useful for the understanding and initial starting point.…

https://community.oracle.com/products/oracleanalytics/discussion/26811/first-day-of-previous-month-and-last-day-previous-month-schedule-report-job-in-oracle-fusion Hi @Ramesh A, Welcome to the Oracle Analytics Community! Please take a look into the following Oracle Note which might be useful for the initial starting point…

Great idea! This feature would be extremely helpful. Upvoted.