Hi @Rajakumar Burra , I recommend you create calculations for Vendor and Quarter using the IFNULL() function, like this: Then you can use this calculated Vendor and Quarter in your pivot table.

Hi Rajakmar, I tried it, and there is a problem. The join between the two tables — when joined on common columns Vendor, Quarter, and Segment — gives multiplied Planned values due to the Actuals break-down by Sub ID. It would be best to join Planned with an aggregated Actuals table, grouped by Vendor, Quarter, and Segment…

Hi GauravSignh, Presuming your BMM has one logical table for DB1.TAB1 columns ("factTAB1") and a second logical table for DB2.TB2 columns ("dimTB2"), with a left outer join between the two logical tables (with factTAB1 on the left) . . . Check the logical table source for dimTB2. Does this table source include DB1.TAB1,…

You can join the two datasets by Vendor and Quarter. Or you can create a dataset that includes both tables—the manual table and the one fetched from Oracle Fusion — joined by Vendor and Quarter. This pre-joined dataset would, in a workbook, display two tables.

The SR was never picked up. Eventually the reporting team decided to close the issue without resolution. The application that is the source of this subject area will be migrated to a cloud application sometime next year, so the reporting solution will have to be redesigned anyway.

Vismay, Check the setting, "Repeat Rows on Excel Exports for Tables and Pivots," in the "Other" section of System Settings.

Hi @Lokesh Obhilineni-Oracle , If you do not intend to use this column as a measure, yes, you should change it in the dataset — change it from a measure to an attribute.

Thank you, @Gianni Ceresa. I will compare the two logs.

Example: DAYOFMONTH( TIMESTAMPADD( SQL_TSI_MONTH, -5, TIMESTAMPADD( SQL_TSI_DAY, -DAYOFMONTH(CURRENT_DATE), CURRENT_DATE ) ) ) The inner TIMESTAMPADD() is subtracting the DayOfMonth result from the current date, getting the final date of last month. So the outer TIMESTAMPADD() is subtracting 5 months from the last date of…

May I suggest: FILTER( WorkDayAccumulated USING( CRTD = SysDate )) or FILTER( WorkDayAccumulated USING( Date = SysDate )) Since CRTD and Date are joined, either one should work OK. I assume your SysDate calculation result is in the correct time zone. Also consider using Current_Date instead of SysDate.

Hi Kirk Li, I think the measure will work well in your filter if you perform the WorkDayAccumulated (i.e., Rsum) calculation within the dataset, but not if you perform the calculation within the DV workbook. I have two questions regarding the USING() part of your FILTER() function: Why are you filtering against DATE(DAY)…

This doesn't answer your question, but I'm not sure a running sum will work properly in a filter function because — I believe — running sum calculates using filtered rows.

When you click on a measure (to open the details page), the measure is picking a column and row intersection — e.g., Line Status = 'AWAITING_SHIPPING' and ??? = 'Ground'. You must take the column formulas for these two columns (i.e., Line Status and ???) and ensure there is a Prompted filter for them both in the detail…

Hi. You might try placing a "Folder" dashboard object on a dashboard page. Perhaps this is all you need.

Here is one method of providing a column, in analysis results, that provides a link with column value embedded in the link. I like this method because the downloaded analysis will not give the URL as the column value, but will only give the intended column value. NOTE: This method may not be possible if html option is…

TO_DATE( SUBSTR( your_column , 1, 10 ), 'YYYY-MM-DD')

The "Activity Type" column comes from the "- Activity" presentation folder. When you added this calculated column, was it the first time any column from "- Activity" folder was added? Here is my guess: "- Activity" has more than 1 row per campaign. When you add the folder to the analysis, you get "# of Leads" multiplied by…

Hi @Harriet Huang-Oracle , No, there is no error; the correct column is successfully included in the analysis view. I have raised an SR. Thank you.

Hi @Harriet Huang-Oracle , Although the version number is not shown there, it does show the date: November 2023. >In the screenshot you uploaded, what happen when you click one of the listing column under Include column? I tried to answer this question in my original post, but maybe it was not clear. The column is added…

I don't know what name to call the product, since OAC includes both DV and a "classic" interface, which used to be called OBIEE. It is the Oracle Analytics "classic" interface. I do not have visibility to the version number. "Direct database analysis" is the type of analysis created by selecting menu path, Create ->…