Hi @A Vidhan You can enable event notifications to burst the pipeline run details to users. I believe it is possible for these to be sent to users other than administrators. Please see the blog on this at Oracle Fusion Data Intelligence – Get notified when your data refresh completes using event notifications | analytics…

Hi @Dhaval Parikh Stantec , great idea. I have posted something similar at https://community.oracle.com/products/oracleanalytics/discussion/28538/roadmap-accelerator-conversational-notes Grateful if you could give that an upvote. Thanks

Hi @User_A63N1 I don't think it is currently possible to do this in DV. I have tried looking at options for conditional formatting for this in case it is definable by a rule however I can only see a way to do this for the main data columns not totals. @Brendan T there is no selection steps pane for DV that I am aware of.…

@Dorothy Joseph-Oracle i know there have been issues with shared themes with things like custom colour schemes causing issues across environments. Might be that it is fixed in the March release.

If you take the semantic model into AIDP then you should be able to achieve that but I am not a Python expert so can't help with that side sorry.

@Dave Brandon have you tried adding an ifnull formula? Statistically, breaking the time series is correct as technically null is different to zero so if you created a different column and idi ifnull(column,0) then this may work. You could then hide the original column and only expose the new one.

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