My sincere request is to ask Oracle to introduce indentation as a feature in OAC DV pivot view. Since the traditional users are excel based , they would love this feature. As of now it is not available, how do i achieve it. I am using only OAC DV.
Hi and thank you for your suggestion. The forum is for questions. Your request is about a feature so I moved your post to the idea lab.
Hi,
Can you share a example of indendation in pivot? For hierarchy columns we already do that. For non-hierarchy columns, i would like to see a example.
Thanks
Here is illustration from excel that we are trying to create. Please note that vs LY , vs Plan , vs Fcst are not hierarchy columns.
Another example: we wanted DPC, Total Material Loss%, and other columns to be indented. Since we do not have any other option, we have used ‘___’ as a prefix to show it
Hi @User_4RQY1, adding to @Avinash Krishnaram-Oracle answer for alternatives until this is fully supported OOB (assuming you have different columns to represent each 'level') :
hope that helps for your use case, let us know if you need more details
In my use case and example that I have shared, ‘vs LY’, ‘vs Plan’, and ‘vs Fcst’ do not roll up to Net Sales and Gross Profit. They are separate columns and flat members, not part of any hierarchy. This is how the business prefers to view it, similar to how we use indentations in Excel for visual clarity. I hope this makes sense. This change is primarily for aesthetic purposes.
@Ajinkya Vyawahare thank you for the clarity
Right now, OAC offers pre-built pages and watchlists related to NSAW. At our University, we do not need these pages, and we want to delete them entirely. We've been told in response to our SR that all we can do is keep "Access" limited to only the default admin and sysAdmin roles. This prevents regular users from seeing…
It would be nice to have a way to right click on an object (subject Area, Column, Calculation, etc.) in the Data Panel and show where that object is referenced in a workbook = canvas, visualization, filter, calculation, data action, etc.) In Workbooks with multiple canvases and multiple subject areas, we are left to hover…
We want to automate the workbook export to .dva file and import this into another OAC instance using REST API, The goal is an OCI DevOps pipeline that can promote (a) a whole folder, (b) a single workbook, or (c) several workbooks in one run to another OAC instance, and print a status result at the end. Blocker: Export and…
When Oracle Analytics AI features find an anomaly, trend or key driver, let authors save those results as a dataset or subject area. Each run would add rows with the metric, the date found, the expected versus actual value, the severity, the main drivers and the filters applied. Authors could then build workbooks, schedule…
We use the snapshot to update AppRoles members. But we would like to disable catalog content to have smaller snapshots and create snapshots faster.
