Hello @Riyaz Ali-Oracle , hope you are doing well. Thanks for your time and effort in providing these suggestions. I have tried most of it. Especially the union but in my case, I am having performance issue with the main subject area that fits for the requirement and I actually cannot do any 'left joins' given the…

Hi @Sumanth V -Oracle, thank you for your assistance we are going to coordinate with our OCI Admin. Regards, Ivony

Hi @Nathan CCC , do you think there is no possible way for this requirement now?

Hello @gclampitt , the IDs are not included in the report layout that's why I can't understand how is it still being extracted with the CSV output.

Hi @MandeepGupta , what is an Etext template? Sorry, I am not familiar with that yet.

Sure! :)

Hi @Bhaskar Konar , yes, thanks a lot!

Hello @Dimple-Nagesh-Support-Oracle , Yup that's what I meant. Thank you so much for your help.

Hello All, Thank you for your help. I managed to solve my issues. I just have 1 more problem, is there any property that can exclude a field to be exported via CSV? The thing is, there are IDs that cannot be unselected because they connect the groups of data model.

Hello @Dimple-Nagesh-Support-Oracle, Could you please expand on this? "Excel takes the column order from the report layout, which was modified." I actually can't find any documentation that explains the behavior of excel output from data model.

Hello @MandeepGupta, this is actually for data model. I tried the suggestion from @Nathan CCC, but I encountered an issue. The scenario is, for this data model, we have 4 groups. Now, the other columns are from the other group of data model, and I am not able to rearrange it based on the preferred output. Is there any…

Hello Nathan, thank you for that suggestion, will try it :)

Hello @MandeepGupta and @Dimple-Nagesh-Support-Oracle, thanks so much for your help. I managed to create the dashboard.

Hello @Nathan CCC , I have identified the issue using the session logs. It is coming from the HZ_PARTIES where we are getting the required field for this report. I am now looking for other workarounds to accomplish the report. Thank you so much for your assistance!

Hello @Nathan CCC thanks for your help, however I wasn't able to generate the logs it says, 'No Logs found'.

Hello @Regie Mercado, I'm only using this one subject area that's why I cannot find the reason of the slowness.

Hello Hitesh, Thank you for the suggestion. Have a good day!