Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
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 Month: {$LAST_DAY_OF_MONTH()$} Hope this help. Thank you.
-
It'll be a great feature to have. Upvoted.
-
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 might be helpful to achieve the Report. First Report which will be used as Filter: Define an OTBI Analysis which will contain following fields:…
-
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!
-
Very helpful information. Thanks for sharing!
-
Very helpful information. Thanks for sharing!
-
Incredibly useful & helpful. Thanks for sharing!
-
It'll be a great feature to have. Upvoted.
-
Beautiful! Thanks for sharing.
-
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 that you are facing and will help to find a potential solution. Thank you.
-
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 My Oracle Support (MOS)? Thank you.
-
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…
-
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.
-
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. Thank you.
-
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'. Hope this help. Thank you.
-
Much needed feature. It will add value and save time while executing the report. Upvoted.
-
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 notes which might be useful for general audit & usage tracking. https://blogs.oracle.com/fusionhcmcoe/post/bi-auditing-in-cloud-hcm…