@Saroj Kumar Behera The query in the initialization block is not in the right format. Please refer

@Amit Garg-Oracle Yes, it is possible. Please use workbook personalization. Please refer https://blogs.oracle.com/analytics/post/enabling-end-user-personalization-in-oac-workbooks

@User_2BNF3 Please use the query below for your row-wise initialization block where PTD_Var is the variable name. select 'PTD_Var', PTD from ( select 'Jan_PTD' PTD from dual union select 'Feb_PTD' PTD from dual union select 'Mar_PTD' PTD from dual union select 'Apr_PTD' PTD from dual union select 'May_PTD' PTD from dual…

@fledicu The error message is generic. This needs log file analysis, specifically, bi_server1 logs and obis1 logs. So, the SR is the right approach of investigating this issue further.

@fledicu Can you please post the error message / screenshot showing the error? Does the issue occur for a dataset based on CSV / Excel as well?

@Sreekar_B Please use the command below along with the required parameter to report on the catalog objects. Please refer the document for more information. runcat.sh -cmd report

@deniz Please check if the Oracle Data gateway(RDG) is up and running. Please restart RDG once and verify. If the issue still persists, we will have to check the RDG log. Please review the documents below for information on restarting RDG and checking the logs and troubleshooting scenarios:…

@Tilen Can you please check bi_server1 log, bi_server1-diagnostic log and obis1-diagnostic log? If it needs deeper analysis of logs, I would suggest you to log a SR?

@user6091159 I would suggest you to log a SR for this issue.

@PeteSiekierski Can you please make sure that the aggregation level based on a dimension is set as mentioned in the document

Hi @User_C95ZI You need to configure Remote agent connector, build data augmentation to extract transaction data from EBS into FDI's ADW and build custom semantic model and content on top of it. Please refer to the documents below.

@ashraf817 Can you set the date format in DV as MM/dd/yyyy hh:mm:ss and check?

@satya_nvs It is not possible as the user 'weblogic' has BI Administrator application role.

@Dhaval Parikh Stantec As an administrator, please inspect one of such datasets and grant full access to another administrator and verify if the dataset appears under console> content management page.

@Dhaval Parikh Stantec My understanding is, the administrator is not able to see these datasets under DV Console > Data > Datasets tab as well? Please confirm.

@Eugene_A_O This needs bi_server1 logs analysis to troubleshoot and identify the cause. I would suggest you to create a SR.

@ashraf817 Can you please let me know if you are building your dataset using Oracle Analytics Desktop directly based on the database table?

@ashraf817 You can create level-based measures in the RPD / semantic model at quarter and year level and use them to create these calculations.

@Lauriane Massin Whitaker I do not see worker category and contract duration column in the report. Can you please include them in the DV workbook to replicate the issue and upload the execution log?

@ashraf817 The keyword END is missing at the end of the CASE WHEN formula. Please check.