https://community.oracle.com/products/oracleanalytics/discussion/comment/70678#Comment_70678 Hi @Gavi, You can achieve last day of previous month by using the following function in the default value: Last day of the previous month: {$FIRST_DAY_OF_MONTH()-1$} The First Day of Previous Month functions are not supported in…

https://community.oracle.com/products/oracleanalytics/discussion/26989/what-is-the-difference-between-archiving-and-downloading-bi-objects Hi @Peter Toth, Welcome to the Oracle Analytics Community! Please take a look into the following post which might be useful. What is the difference between Uploading a BIP report vs.…

https://community.oracle.com/products/oracleanalytics/discussion/26986/how-to-set-first-day-and-last-day-of-previous-month-as-default-value-for-parameters Hi @Gavi, Welcome to the Oracle Analytics Community! Please use the following as default values, it should work. First Day of Month: {$FIRST_DAY_OF_MONTH()$} Last Day of…

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

https://community.oracle.com/products/oracleanalytics/discussion/26971/retrieve-only-managers-with-at-least-one-report-having-a-specific-legal-entity Hi @Oriana L. This might be possible using OTBI but needed multiple reports. Final Report will be calling another report as a filter. Please find below high level steps which…

These sessions will be very helpful. Thanks for sharing & organizing @Aimee Williams-Oracle!

Helpful information. Thanks for sharing!

Very helpful information & the contents. Thanks for sharing!

https://community.oracle.com/products/oracleanalytics/discussion/comment/70521#Comment_70521 Very helpful information. Thanks for sharing!

https://community.oracle.com/products/oracleanalytics/discussion/comment/70525#Comment_70525 Very helpful information. Thanks for sharing!

Incredibly useful & helpful. Thanks for sharing!

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

https://community.oracle.com/products/oracleanalytics/discussion/comment/70563#Comment_70563 Beautiful! Thanks for sharing.

https://community.oracle.com/products/oracleanalytics/discussion/26964/item-description-error-from-dashboard-prompt Hi @skhan, Would it be possible for you to attach your report catalog with some screenshots (without sensitive data) describing the issue that you are facing? It'll be helpful for the understanding the issue…

https://community.oracle.com/products/oracleanalytics/discussion/comment/70585#Comment_70585 Hi @Rajesh Kushwaha. You have to login to Oracle customer connect (Welcome to Cloud Customer Connect) and probably you need to have account which is associated with Oracle CSI (Customer Support Identifier). Are you able to access…

Hi @Regie Mercado, Please find below a screenshot as Jerry suggested highlighted in yellow. Can you please check if you have 'Measure Labels' in the column section as highlighted below? Hope this help. Thank you.

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'.…