Hello, You can try using RSUM calculattion to get the cumulative by month. Sample calculation as below. Also attching the report XML which I built. report_xml.txt RSUM("- Current Forecast"."Current EAC Cost" by "Task"."Project Number")

@JITHU JOSE . Understood. There might few ways to handle this. You can try the below approach. 1) First create a filter report that contains requisitions with at least one line which is not processed. 2) Now create a main report, and filter out the Requisitions that are in the above report. You can apply the filter as…

Hello, You can try to build the report something like below

You can try this workaround. It might help with your requirement. 1) Navigate to Advanced Extract Configuration option for an individual PVO. 2) Setup the Initial Extract Date .. to the desired Last Extract date 3) Reset the individual PVO to Full Extact

I suppose you can use manager flag or Worker category fields to get this information. However if you are still trying to compare Person numbers to Manager person numbers, you can try something like below. First you can create a separate report that contains all the "Manager Person Numbers". Then on the Person report you…

Hi Laxmish, Using the catalog manager you can generate a report ( csv/excel) of all the objects in the catalog. https://docs.oracle.com/middleware/12211/biee/BIESG/GUID-E804B1AF-B792-4929-BE47-33CA0F668715.htm#BIESG340 You can count the objects(reports or dashboards) from the excel file. Thanks, Bharath

Hi Venkat, One approach I can think of, 1) Setup a separate subject area for this activity ( Copy of existing subject area) 2) Setup data level security on this new subject area. All the prompts on the reports has to be setup as a data level security filters. 4000+ combinations can be setup in a table. 3) OACS Classic…

Hi @Jahnavi-Oracle You can export and import a project/workbook built using this data set. It will migrate the underlying data set as well. Thanks, Bharath

Hi Indra, One possibility is In the Physical layer check the column datatype length. It might be defined as varchar(7) as we are seeing only the first 7 characters. Thanks, Bharath

Hi Indra, For some reason if you are unable to use repository variables. You can consider below solution as well. * Create a union report in OAC Classic * First union report you can setup the dynamic values what you are expecting for Headers. * Second union block can be actual data to be shown in the report * Disable Table…

Hi Indra, I can think of few scenarios when this can happen 1) Please check if you have used any report based filters or added drill downs and the detailed reports are not migrated to the new instance 2) Check if there are any custom images are used in these analysis and these images may not have been migrated to new…

Thanks @Joshua C. Stewart for your help. I ended up using EVALUATE_AGGR functions as we have over 100k products.

@ALOK SH-Oracle - Thanks for this solution, Yes it works fine in OACS classic. Is there anyway we can do this in DV workbook ?

Hi @Jahnavi-Oracle In the below example, I have added five columns to the "Dashboard Filter" and have enabled the Apply button. Now it wont fire off unwanted queries while we are still setting up the filter columns. Thanks, Bharath

@Jahnavi-Oracle this functionality can be achieved using Dashboard Filter. Thanks, Bharath

This is a very useful enhancement as we cannot hide the column as well in DV.

To update this thread, "Reset the Data Warehouse" completed after running for approx 24 hours. Thanks, Bharath

Thanks @Nupur Joshi-Oracle .

If the User is granted only "Service Viewer" group then "Explore" option wont be visible. Thanks, Bharath

Hello, By default EFF PVOs wont be enabled in BICC for extraction. You can create a customer offer and add the EFF PVOs to that offering. For ego_item_eff_b table PVO is : FscmTopModelAM.EgpItemsPublicModelAM.ItemEFFBIFlattenedVO. Thanks, Bharath