Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Can you try the following:- 1.) Create a DataSet (Excel/table based) which has Month Number and Month Name you need 1 June 2 July . . . . 2.) Join it with this data set and add the Month Name to the Report
-
@Caroline Blanchard Below is an alternative solution that you can review. 1.) Create a Dataset with Period Number and Period Name columns using excel or table based datasets. 2.) Join with the Period number in out of the box with the column your custom dataset and use the period name from your Custom dataset in your data…
-
Caroline, In FDI we have the following options:- 1.) Period Number - This shows the numerical value of the Period 2.) Period Name - This shows the Month name and appended with the Year Name. Are you looking to see only Month Name ?
-
Syed, Can you elaborate a little bit more on the Use case ?
-
@Juan Hurtado Data Augmentation should be used to bring the data into the FDI. Sematic Model extensions should be used to Extension and join the data.
-
Do you want to sort based on Person ID ?
-
We do not support editing permissions for the out of the box Folders. We support customer using Custom Duty roles to achieve similar functionality.
-
You can use Custom Duty roles to secure to do Object Level Security and add them to custom / out of the box Job roles as needed.
-
We should secure Custom Reports using Custom Duty Roles. We can define a new custom duty role and use that to secure the custom Reports. We can remove the out of the box Duty roles from Job roles.
-
Caroline. We do have the ability to hide the out of the box Reports. You can modify the Job roles and remove the Duty roles which secure the Folders. This way you can hide the Out of the box Reports.
-
You can hide the folders by excluding the Duty Roles from you Custom Job Roles. You can modify your Out of the box/Custom Job roles and exclude the Job roles which are securing the out of the box Folders. This way you can revoke the access to Folders.
-
Ashwik, You can use Data Augmentation to bring the additional fields from Suppliers and use Semantic Model Extensions to add them in FDI. Let me know if you are facing any issues with the same.
-
Can we look at drilling from GL Balances to GL Journal and then to Configurable account analysis ? We can use action links to drill from a Balance amount to the underlying Journal and from Journals to Configurable account analysis.
-
The Column properties are present for all the columns when you edit the pivot. if you cannot find it, then can you log a SR for the same.
-
Please go to criteria. Column properties and data format.
-
Kindly check the number format options that will allow to display in % Symbol in DV Projects. Attaching screenshot
-
Thank you for the update. We are looking into the possibility of adding support for comma-separated values. Thanks
-
Are you using FAW Connector and can you let me know can share a screenshot just showing the issue ?
-
Thank you for the clarification.
-
The drill is configured on the Segment Code. For example, I am attaching a screenshot where we can drill on Natural account Level 30 Code.