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
OAS Classic Report Results display the first 5000 rows and the OAS user needs to click the next button for the next 5000 rows and so on. The 5000 row limit is the maximum allowed to be setup in the OAS Console. OBIEE Report Results support display of the entire report results data set. Our users would like this feature in…
Background We recently identified an issue through an inconsistency in the number of records returned in an API response. This allowed us to notice, after the fact, that a fix had been applied that changed the behavior of an existing API. Problem We understand that information about resolved bugs is eventually made…
We need a way for non-admin users to view the backend/physical SQL queries executed by reports (via Session and Query Logs) without granting them full administrator access. OAC's custom Application Role model (Console > Roles and Permissions) allows selecting fine-grained permissions instead of assigning predefined roles.…
Customer would like to request that IBM DB2 12.x be added as a supported data source for Oracle Analytics Server. They hope that it will be included as a certified and supported data source in the next(Year 2027 ) OAS release. Background: The customer is currently operating a reporting and analysis platform using Oracle…
We would like to restrict the MCP to certain OAC application roles instead of all the users. Please help us to achieve this functionality.
