In the "Direct Reportees" analysis, add "Manager ID" as a prompted filter.

Could there be a developer who continues to modify and upload a local version without downloading from server in between?

Try this as the expression: SUM( <measure name> BY <attribute name> )

Many of the regular aggregation functions (as opposed to the running aggregation functions) can use the BY keyword with a list of columns. Here are examples: COUNT( DISTINCT "Form Type" BY "Emp ID" ) max( COUNT( DISTINCT "Form Type" BY "Emp ID" ) by "Emp ID" ) These examples only have one column after the BY keyword, but…

Have you tried changing the Data Access setting to 'Live'? (Open the dataset, go to table's tab, and click the Edit Definition button. The Data Access option is in the right-hand pane.)

Sorry, LukePa. Since you wrote "dashboard filter," I assumed you were using classic, which includes dashboard prompts. In your case, it has to be a parameter, not a variable. The parameter name (e.g., sales_channel) can be inserted in the calculation like this: FILTER( "Cars Sold" USING ( "Sales Channel" LIKE…

Hi Marcelo, Ensure fiscal year and period are on the row which you are clicking, even if they are hidden.

Instead of applying Sales Channel filter to the whole query, only apply it within the column formula using the FILTER() function. To do this, you'll have to set a presentation variable name in the dashboard prompt; e.g., sales_channel. FILTER( "Cars Sold" USING ( "Sales Channel" LIKE '@{sales_channel}{%}' ) ) / "Cars Sold"

You can change the object ID by opening the object and performing a Save As…* The new object ID will reflect the new name. This will create a new object, leaving the original in existence, too. You can delete the original object afterward. If you have other objects dependent on the original object (e.g., workbook used…

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)…