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

Hi It sounds as though you are using dedicated connections for Dev1 and Dev2. If you just had a single OTBI connection, you could update the connection details when you migrate and then reload the data at the dataset level rather than having to create a new dataset and change it in the workbook. I don't think there is a…

Have you considered creating a new hierarchy that concatenates the child org and task at the detail level? There is a blog from Rohan Lobo that shows how to do this for cost centres. Maybe something similar could work in this area? Create a Custom Alternate Presentation Hierarchy in Oracle Fusion Data Intelligence |…