@Stefano_Mazzocca If you are using Oracle Payroll and have the FAIDP (FDI) pipelines configured in the console then you should have a Turnover by Compa Ratio Workbook. This doesn't have gender in it but if you go into the editor then you can quickly add this visualisation so you wouldn't need to use Python. The workbook is…

Hi @Stefano_Mazzocca What are you trying to do with the data? Would you be better using the Semantic Model in the FAIDP to create your calculations for gender pay gap and use those calculations to apply AI models on top in the AIDP Workbench? You already have a lot of payroll comparison capability pre-built in the FDI…

Hi @User_WJ43I As this is looking at Billing and Costs, this will need some work in the SME to either extend an out of the box logical star or create a new one. You should be able to add the Bill To Customer dimension to the standard schema and add a custom calculation to the fact. These can then be exposed through the…

Thank you for the recognition. Always happy to raise and discuss ideas. this is a great way to develop the product. Kudos to Oracle for taking forward user ideas.

Hi @Han Xi Zhao I think you need to have a fact within the subject area as this holds all the dimensions together. Try bringing the fact from your logical star into the subject area to see if this works. If that doesn't work, check the joins in your logical star to make sure that the detail in the fact can be reported at…

Hi @Sarthak Dhingra The users will automatically inherit all the job roles they have in Fusion. As part of the configuration, there is an option for ERP Security Configurations. This brings through all the data access sets for data security. If you use the out of the box job roles in Fusion, they all have FAIDP Application…

Hi @Balasubramanian. I haven't seen any ability to restrict by BU or ledger in the daily refresh. Might be a good one to add to the idea lab.

Hi @User_CAF6Z You could try creating a new column adding a filter for Fiscal Period Trailing number = 1 to get the previous month detail then create the difference from there. If you wanted to be able to select a historical period, you could turn the trailing period column into a Parameter to have a selector in a…

@Rupali V that seems a strange one. If your year end is December it could possibly be something to do with adjustment periods in which case you would need to go to -4 for the first 3 months of the year or exclude them from the analysis somehow.

@Rupali V in either AR Balance or AR Aging there is an Original Amount field. You could try that.

@Rupali V in that case try the periodrolling function above for your rolling 12 month calculation. In fiscal period there is also a trailing fiscal period column you could use for average using a filter statement where trailing period between 0 and 11.

Hi @Rupali V What Subject Area are you using for this? As far as I am aware, all the OOTB subject areas have a relative time function. If you create a custom calculation, there is a PERIODROLLING function that might help.

@User_7AIAG if you chose a User Provided table in the augmentation script then you can enter the name of any PVO. The System Provided PVOs are the ones that are already brought through.

Hi @Raju Punith-60121 Is this from a custom dataset and is this a time based column or an attribute? If you use a time based column then you get a 'Relative' option in the filter where you can select the last (n) periods as below If you are using an attribute column then you could create a parameter based off a Logical SQL…

@Jae.L Strange one. I have just loaded a dataset with a date and single attribute column, created a workbook and added the workforce core dataset and it created the join automatically When the dataset created, the date was a date column type and the column names are the same so that is what I would have expected. Can you…

It looks as though the behaviour is different depending on whether the column is a measure or an attribute. This may be a bug but the property labels are different for the two. I have managed to get around this by creating a custom column using My Calculations converting the value to CHAR so there is no aggregation and so…

Hi @Rupali V Looking at the properties, there are 2 font options for Column Header. One is Header Font and the other is Header Data Font. If you deselect the Bold option from Header Data Font then it should be normal If I change the Header Data Font to Bold then it makes the values in there Bold as well

Hi @Jae.L Have you tried converting the column format? I have had issues in the past with type mismatches and had to do a CAST() to ensure they are aligned before the join would work.

Are the EFFs surfaced in a PVO? If they are, you could use Data Augmentation to bring them into the data warehouse then create the semantic model extensions to surface them in subject areas. If not in a standard PVO, you could create your own.

Hi I had this with a previous customer. The reason for the difference is FAIDP is looking at this from a different lens than OTBI. Where OTBI is enabling a manager to look at the full history of the employees they currently have, FAIDP is looking at the performance of the manager at the time the person reported to them so…