Hi @Bhaskar Konar I created a presentation variable to match the formats. Thank you so much for the idea and solution. Appreciate your help.

Hi @Riyaz Ali-Oracle , The extra spaces turn out to be extra rows in the excel file. I tried to check any possible option in the properties, but they are not working.

Hello @Bhaskar Konar , Yes, I tried it, but it only returns values with same case. Records should be extracted if it matches with 1 subject COMED.

Hello @Hassan El Bouihi-Oracle, this resolved my issue. Thank you! @MandeepGupta , the usage of column properties worked for now, if ever we encountered more issues like this we will try to use the REPLACE. Thank you for looking into this. Appreciate all your time. Regards, Ivony

Hi @Bhaskar Konar , thanks for the suggestion, yes, I've tried it. The thing is, when I am already using the dashboard and added some prompts, when the results are shown, the activity description is expanding. I can't find the reason why is it expanding after adding the prompt.

Hello @Riyaz Ali-Oracle , Good day! Given the limitation of left join in subject area, we have come up to a workaround to use the data model instead in creating the report. But your suggestions really help us understand the structure of our data and how subject areas work. I really appreciate your dedicated time on this…

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!