Hi @Controlcard, That's great news. Would you please select the best answer and like those posts that helped you to get the resolution of this issue. It'll be helpful for the fellow community members in future. Thank You! Cheers,

What issues are you getting? If we don't know the error details we'll not be able to debug. If possible attach your catalog here so that we can execute in our instances and see if the issue can be replicated.

Hi @Shweta Vohra, Can you please create an OTBI Report with following columns to see 'Document Type I9' belongs to which category & sub-category? Once you know that please try to see if you can see those category or sub-category for others. If no then there might be some special security has been implemented and you might…

Hi @Kundan Kumar17, Can you please try the following? Create a dashboard prompt with a 2 date columns and define a presentation variable for each of them. Like: pvToDate & pvFmDate. You can use any default value if required as it is optional. Now use those 2 variables in your Data Model Query. i.e.: trunc(HIRE_DATE)…

Hi @Kundan Kumar17, Can you please share some screenshot detailing the issue you are getting or the requirement that you have. It'll help us to understand your specific problem and will enable us to work on any work around / solution etc. Cheers,

Hi @Controlcard, Can you please check the following and see if there's any betterment? Have you done 'Allocated Checklist.Checklist Name' as 'is prompted' in your analysis 'BOTestTableView'? Have you pressed the button 'Apply' after selecting the prompt value from the 'left dropdown'? Hope this help. Cheers,

Much needed feature and will add so much values to the existing products. Upvoted.

Thank you very much @SteveF-Oracle! Much appreciated all your help.

Very helpful information. Thank you very much @Mostafa Morsy-Oracle & @SteveF-Oracle!

Much needed feature and it'll add so much values to the existing product. Upvoted.

Much needed feature. It'll add so much values. Upvoted.

Very informative & very helpful information. Thank you very much @Sushil Dhoot-Oracle! Much appreciated all your kind help. Cheers,

https://community.oracle.com/products/oracleanalytics/discussion/comment/61331#Comment_61331 Hi @Sulakshana Sridharan-Oracle, If possible, please include me too. Thanks for all your help. Cheers,

Wow, it's truly professional & awesome data vizs.

Hi @User_X33RN, Please find below the Best practices that need to be considered while developing a report using more than one subject areas. You should have common dimension in the subject areas used in the report. Add at least one Measure/Fact/Metric from each subject area on the report. Click on the Advance tab of the…

What issues are you getting after following the post that Mandeep has kindly shared @Kundan Kumar17?

Hi @Techie, What is your issue / requirement? Can you please provide the details so that it can be looked accordingly. Cheers,

Merry Christmas & Happy Holidays Everyone. All the Best.

https://community.oracle.com/products/oracleanalytics/discussion/comment/61847#Comment_61847 Can you set the aggregation rule as per the below screenshot for the pivot table? select 'Max' instead of 'Default'. Can you also check your data in 'Table' View with the latest formula that I provided.

Can you please see the data in a table view instead of Pivot Table and send us a screenshot. Actually any measure that you are using in pivot view need to have a specific aggregation. If possible attach your report catalog or xml here. Cheers,