queries on cards & decks.
Hi Abhishek
Query on Deck (OAX):
1. All below cards have separate grouping options (not a common ones) however when I thought of adding more filters on Deck level – I only see three fixed options. Please see Headcount (Test) deck I created and filters at top which are the only one we can add.
How do we add more filter options on a Deck level?Response) Related Grouping Categories that are part of your KPIs (added to deck) show up as Filter options at Deck level. For example, see below: On this KPI, I have added Name (from Age Band) and Gender (from Diversity) to Related Grouping Categories. Go to Decks -> Create a new card and add this KPI. Now, you should see Gender and Age Band (along with Time) as filter options:
Query on Card: 1. How do we replace a KPI in a card? Example: I created ‘Headcount’ card (first card in above snap) but later I had to change it for ‘Employee’ headcount only. However, there was no option to change the existing KPI in first card. Is it do-able yet? Please advise.Response) Unfortunately, not. You cannot replace a KPI on a card, you can customize it though.
2. Can we customize ‘Axis Name’’ in cards? Highlighted in below snap for reference. In this case, Grade Name does not appropriately fits in here. On Card Settings -> General -> More Options -> Subtitle
Response) Yes. On your card, click on Customize from Actions menu. On Card Settings -> General -> More Options -> Subtitle
3. Can we change the number representation format in cards? Shared below reference. Instead of ‘K’ , can we use standard number format to represent figures.Response) Yes. Edit the corresponding KPI (used on your card), set the measure properties to Number. And disable Abbreviate. See below.
4. Can we include two different aspects in one card? Example: in below, I wanted to include Band as well to represent terms by Band & country together.
Response) Yes, add Band to Related Grouping Categories on KPI page. Then on Card Settings – add the other group, in the below example – I have both Age Band and Gender. 5. Can we add ‘Data Labels’ in bars? In below case, it would have been a great option if we can showcase labels over bars to give users more clarity on numbers represented in graph. Is it possible?Response) Yes. Again, on customize card settings. Set Plot Area Values, see below:
Thanks Ravi
Thank you Ravi, quite helpful!
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
HI, I am trying to get data from the Enterprise Contracts - Contracts subject area in FDI. However, it is not returning any records when I use this subject area. Are there additional configurations or setup tasks needed to pull enterprise contracts data in FDI? I have checked the following: In Oracle fusion, I have access…
How to Inject external data (Business central data) into Oracle Autonomous lakehouse via SFTP connector in FDI?
OOTB subject area fields are not available in DEV and PROD. Existing workbooks display "Error Loading Data" and report that standard fields are cannot be found. Local Subject Areas also display "Schema listing not available". The issue appears to affect the FDI semantic layer/metadata across environments. Can anyone facing…
I’m currently facing an issue with the Absence data in FDI. For example, in the screenshot, the Approved Absence measure is showing 1, while the correct value in Fusion 1,560. A few points: This is the standard/prebuilt dashboard; no customizations were made. There is no date filter applied. The FDI refresh runs daily, so…
Report 1 :We do have FRS report with 7 to 8 columns.HTML veiw of the report showing extra space .how to fit the output to the report .There should not be space in the html report.Attaching the report output. Report 1 output : Report2 : We do have an FRS Report where one connection has all ledgers except CSG IND STAT…