Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
@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 |…