@Yogesh Yadav Flattening and Publish Hierarchies in Oracle ERP Cloud will not adversely impact OTBI or ERP functionality. Flattening and Publishing hierarchies is required for OTBI as well, without which the hierarchies will not appear in OTBI SA's as well.

Hi Baskar, Which steps are you looking for? Regards, Amrita.

@Nupur Joshi-Oracle , Is this slated for any future release? If yes, would you be able to share some timeline? Regards, Amrita

Hi @Richard Victor, We were facing the same issue. After some trial and error, the below set of roles worked for us. Hope this helps.

Hi @Samantha Aguilar C , In such scenarios, in custom DW solutions, we create BIP reports which queries the Fusion tables. The BIP report is triggered using ETL tools like ODI. The content is downloaded in the form of a CSV report, and, then loaded into a table in the data warehouse. If you have an ETL tool in addition to…

Hi @Samantha Aguilar C , In such scenarios, in custom DW solutions, we create BIP reports which queries the Fusion tables. The BIP report is triggered using ETL tools like ODI. The content is downloaded in the form of a CSV report, and, then loaded into a table in the data warehouse. If you have an ETL tool in addition to…

Hi @Samantha Aguilar C , In such scenarios, in custom DW solutions, we create BIP reports which queries the Fusion tables. The BIP report is triggered using ETL tools like ODI. The content is downloaded in the form of a CSV report, and, then loaded into a table in the data warehouse. If you have an ETL tool in addition to…

Hi @Samantha Aguilar C , In such scenarios, in custom DW solutions, we create BIP reports which queries the Fusion tables. The BIP report is triggered using ETL tools like ODI. The content is downloaded in the form of a CSV report, and, then loaded into a table in the data warehouse. If you have an ETL tool in addition to…

Hi All, A related query. I understand Public Holidays can be setup by adding an event on the Holiday Calendar page. Is this information available in any PVO? Regards Amrita.

Thanks @Rajesh L-Oracle. Exactly what i was looking for.

There is an option using a feature called External Application Merge which gives access to the rpd. However it is not GA. Hence my query.

It seems Product development does not plan to bring all features from Classic into DV. I had recently enquired about the possibility of making set operations available in DV. But it does not seem to be on the road map. And it proves to be a challenge to explain this to the customers.

Hi Ajay, If you want to export the data, and, then use it for further analysis, it is always better to export the raw data, i.e. un-formatted data. If you download formatted data, it will usually be formatted the way it is in the report. And it would suppress repeating data. This would be more suited for presentation…

Hi @Stefan pettersson, I used the below formulae, and, the have included screenshot of the results as well. Please check if this works for you - Positives ---- SUM(CASE WHEN <"Fact"."Col"> > 0 THEN 1 ELSE 0 END) Total ------ COUNT("Fact"."Col")

Hi Nicolas, Project Name is one of the GL segments for one of my implementations. So i had combined the Payables Invoices - Installments Real Time Subject Area, with the Payables Invoices - Transactions Real Time SA to create a report combining project name(from the Project subfolder, in the Accounting folder) and the ap…

You should be able to get this information from the Payables Invoices - Installments Real Time Subject Area

Hi @Bharath Raghupathi-Oracle, However, in this case the comparison would happen with respect to the Creation date of the record, instead of the Last Update Date. Am i right in my understanding? @Yogesh Sureshkumar You can create a job, and, club together the PVO's for which you require a common extract date(or even a…

Could you try below - Include the Accrual Plan column in the Criteria. Do not hide the column. Just exclude the column from the Pivot table. Then check if you get correct values.

Is the value of the accrual plan different? If yes, that is why it is being split into 2 rows.

Hi @Mirza_Adeel , Is there any additional column in the criteria, which is part of the pivot table, but, is hidden? Also, has the aggregation rule been set to sum for the metrics "absences"?