I have this dashboard that filters by month:
Is it possible to have inside it a calculation of Employees hired in that year, no matter if the month is January or October?
Hi @Stefano_Mazzocca
You could look to create a parameter for the month and Year and use the year to filter the report. I did something similar for financials using the available values as logical sql using
SELECT "Financials - GL Budgets"."Time"."Fiscal Year" FROM "Financials - GL Budgets" WHERE "Financials - GL Budgets"."Time"."Fiscal Period"
= (@parameter("Select Fiscal Period")(''))
Hope this helps
It is a strategy, sure. In the meanwhile I thought it was better for me to use the month date and apply the Year function to it, in order to get always the year despite the month
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…
Hello, I need to grant users access to FDI without giving them the module security groups, such as ERP, HCM, etc. In FDI, I have other external connections, and I don't want them to see any other modules, so my question is: Is there any other FAW security group that grants access to FDI without allowing users to see the…
With the release of Fusion Operational Analytics, I understand that OTBI Subject Areas will be made available within FDI, but I'd like to know the following: 1) Can I migrate OTBI reports and/or dashboards over to FDI for use by FDI consumers? Are they brought through the OAC Classic layer of the FDI/OAC platform? If not,…
Hello Team, In the fusion source, we have the records maintained in multiple language say in english as well as in arabic.. ex: dept name is stored in both english and arabic in oracle fusion source with 2 records with different language code like EN and AR. But the same data in FDI is getting extracted only with the…
Hi Team, can oracle provide a standard decks to have a demo and presentation with new customer? Please share any links or attachments if available. Thanks, Manoj
All, I don't see there is a pre built data lieneage which gives more spectrum of solutions or answers for the BI leadership. 1.How many reports each users are owner and what is its path 2.Is these insights are sourced by Subject areas , data sets , Local Subject areas etc 3.Which content duty roles are associated to each…