Hi @Sulthan, Welcome to the Oracle Analytics Community! Can you please check the following Oracle Note? Hope this help. Thank you.

Hi @Sumanth V -Oracle, This is very helpful. Thanks for sharing!

Hi @Prabhjeet Kaur, Please check with Oracle support for their expert opinion and if possible please update here; it'll be useful for the knowledge and future reference. Thank you.

Hi @Ivony Ann Paula Salango, Can you please change your prompt 'Subject COMED' to text instead of drop down values and then type 'Customer' to the prompt as a value and execute the report to see if now it is bringing all expected rows? Thank you.

Hi @mc, Thanks for the information. Can you please share your data model so that we can replicate in our instance to see if we are facing the same issue which will help to find potential solution. Thank you.

Hi @mc, Welcome to the Oracle Analytics Community! Quick Question: Are you passing the same date (:pEffectiveDate) for both the query? Also are there any other prompt or dependency while executing the LOV? Thank you.

Hi @Donna Fazio, Welcome to the Oracle Analytics Community! Can you please check if the 'Aggregation Rule' has been set for the column in the Pivot table? Here is an example. Hope this help. Thank you.

Very helpful information. Thanks for sharing @Luis E. Rivas -Oracle!

Hi @User_A_AJ, Can you please try to get the output with RTF / PFD/ CSV using RTF template to see if it is working fine? Just pull all the columns that you have in the query into the RTF and see if it is bringing all expected rows.# Thank you.

Hi @Anna A, If you filter your query for a specific person (who is having duplicates) and try to execute both query & the report. Do both produce same result set? Also are the numbers of columns same for both (Query & the Excel output)? If you give some more examples like screenshots (without sensitive data) etc. it will…

Hi @Kauan_Bohn, Thank you very much for sharing! It'll be very useful. Thank you.

Hi @cvidhya, Welcome to the Oracle Analytics Community! Please look at the following Oracle docs which might be useful for initial understanding and a good starting point. Hope this help. Thank you.

Much needed feature. Upvoted.

This will be very useful feature and will add so much values. Upvoted.

Hi @Elavarasan S, Welcome to the Oracle Analytics Community! Can you please check if the aggregation level has been set-up for the measure in the pivot table like below? Hope this help. Thank you.

Hi @User_FCECH, Please take a look into the following note which might be useful for the initial understanding. Hope this help. Thank you.

Hi @SERGIO BARRETO, It seems there were some issue with column search but it has been fixed in 24 R3 version. Please see details in the following Oracle note. If you are in 24 R3 or above and still facing issue, please raise with Oracle support for their expert opinion. Hope this help. Thank you.

Hi @Ivony Ann Paula Salango, Thanks for the details. I would recommend you to go one step at a time to see if it is working or is it not working when you are adding other reports etc. Sometimes the results comes from cache and makes it difficult to see the changes. I tried the solution with prompt and dashboard and it is…

Hi @User_QI9MI, Welcome to the Oracle Analytics Community! You can use eText template and deliver the file as a text file and the data can be stored as comma delimited inside that text file. You can only choose those columns that you need if you are using eText. Please take a look into the following document for more…

Very helpful information. Thanks for sharing @SteveF-Oracle!