Just compared the LSQL. When we exclude the values, it is automatically adding with OR OR (XSA('xyz@ptc.com'.'PMO Reports')."Columns"."Segment Portfolio" IS NULL))) . Seems it is causing problem. Also if we explicitly uncheck the Nulls button it is adding AND (XSA('xyz@ptc.com'.'PMO Reports')."Columns"."Segment Portfolio"…

@Gianni Ceresa Thanks for quick reply. Logical SQL showing same filters both. Problem is coming with Exclude option only. If we uncheck exclude, it works fine. This is not new Workbook. It is old. It was working fine. Seems something is broken in May 2024 updates.

Images below:

I have two Pie charts in same canvas. Both are giving different results. It was working fine before May 2024 updates. Their SQL is as below. Fetching 2321 which is wrong. SELECT 0 s_0, CAST(NULL AS DOUBLE) s_1, XSA('xyz@ptc.com'.'PMO Reports')."Columns"."Work Type" s_2, SUM(XSA('xyz@ptc.com'.'PMO…

Thanks @SteveF-Oracle for confirming. But workaround is only for authors. What about consumers?

I am always thinking why Oracle not trying & not serious in implement own product OBIEE best capabilities. Why customer need to point the OBIEE capabilities needs to implement. Even after 3-4 years, OBIEE capabilities not coming into the OAC product.

@Mostafa Morsy-Oracle Thanks for confirming.

@Sumanth V -Oracle Please do below steps and let me know. Create workbook that contains 3 canvases. Navigated to Present mode. → Save Close the workbook. Now open the workbook in View Mode. Add filter to any canvas in View mode Then Pin to All canvases. Check it is populating to all or not.

I think you can use filter option "Slider".

@Bret Grinslade - Oracle Analytics-Oracle When Consumer switch viz type from map to table, measure field is not populate. Because Map doesn't have Value/Measure. It has only Color.

@Bret Grinslade - Oracle Analytics-Oracle Extension is very basic and some temporary kind of workaround. Requirement is similar to this with all capabilities of Visualizations.

@GayathriAnand-Oracle It is not working. Also there is no way to do in workbook. I have created a Dataflow to achieve my results.

@KhaderBelgoud-Oracle I have already used "Sum" so ,it can't be re-used .

I too experienced it. Will post example if I am able reproducible now.

Issue resolved.

Thanks @Federico Venturin . Exact meaning of Overlay. 😀 For now, live with two separate charts. Waiting for Oracle to identify the value and implement it. Created an Idea, You can vote for it.

@Subha_Tripathy-Oracle Sorry it is not as per expectation. My expectation is that by end of the week, I should be able to see actual open and closed. A2 was closed on 04/07/2024 and again opened on 04/08/2024. It is summing twice in open and closed. So it is giving wrong data.

@Gianni Ceresa We are handled in database using SQL with recursive. Thanks for sharing info.

@Lalitha Venkataraman-Oracle Thanks for providing info. Downloaded plugin. It is working fine. Issue is with download file Button. Since number of rows are more, I can't navigate to down to end to click on "Download File". If the button is on top, it will be good.Still I am finding ways to download file. Export is not…

@Benjamin Arnulf-Oracle Hope we will get it soon. Apart of it , I would request you to enhance Pivot tables and existing charts with option. Display value as "Running Sum" like OBIEE. Please don't point me to use "RSUM" function. Display value as "Running Sum" like OBIEE overcome some incorrect calculations of "RSUM".