Hi @Ashish-Oracle , The change I am trying to publish is a very miniscule one. It is just to add a column to logical and presentation layer. But the Apply Changes is running since 4hours for this process. I know we don't have a way to Kill this even. I have created a SR 4-0000625869. Can you help? Thanks, Deepthi

Thanks Mark. I have raised an SR with oracle. Will update if they provide any solution.

Hi Sherry, where model in (:P_MODEL) or '*)nqgtac(*' IN (:P_MODEL || '*)nqgtac(*') I have put the following condition, but still doesn't work. I am getting the same error.

It's varchar

Hi Sherry, The following where clause worked for me. (:P_MODEL) or '*)nqgtac(*' IN (:P_MODEL || '*)nqgtac(*')

I think I spoke to soon. It's erroring out with the same error.

Hi Sherry, Thanks for the reply. The data model is a sql query. I have the following error

Hi Jasmine, Thanks for the reply. I am able to pass multiple values to the report and it works fine. The problem comes only with 'All Column Values'. The doc ID suggests addition of below tag <AdvancedReporting> <ReportingToolbarMode>6</ReportingToolbarMode> </AdvancedReporting> But that is for displaying the parameters…

Hi All, I was able to get a combination chart with line - area and bar graph. But I am unable to get the stacked bar - area - line option. Is this possible in BI Publisher?

Hi Arijit, There are no prompts on the Dashboard. A report with filters works fine. But when I place it on a dashboard page it does not. Thanks

Hi Christian, Yes, I did pull the logs and the queries are running pretty fast on the database. The weird part is in manage sessions, the session shows as completed and gives me the whole statics about the query on database and logical query time etc. But it never stops spinning on the dashboard page. The second thing is…

Yes this works in 11.1.1.9 Thanks

To further explain as if all the oppty's in status new should fall under same line but if i put the oppty column in the row section, it wouldn't. Hence this wont work.

Hi Gianni, If I am putting the Oppty column in the rows the report is not displaying as required. But I am getting multiple records. But if I don't put the Oppty column in rows, the aggregation rule is coming into play and only displaying a single value. Any other suggestions to achieve this? Regards, Deep

Yup. It worked. I made the Oppty column as metric with aggregation rule and also added the same on the rows section and then hid the column added on the rows section. Thanks for all the help! Regards, Deep

Hi gianni, I understand that for numeric fields it does merge values. But in this case how do I setup a non numeric field as a measure? Thanks

Hi Gianni, Yes, I think that makes sense having them separated as you suggested would work. But how can I achieve this? Is there a way I can do this in pivot table? Regards, Deep

Hi Gianni, Thanks for the quick suggestion. But if I do that, I no longer can have a drill down or navigate to detail report to see more details about the OP1 right ? Also if there are any color coding on OP1 and OP2 separately I won't be able to apply on this report as now OP1,OP2 is considered as single value. Please…