Cummins Inc
End User should be able to change column display name in Subject Area without changing RPD in OACS.
Minimum dependency for business on IT.
Original Idea Number: 7225e204d8
This is a good point and would add value. It is also available in Answers so no reason for not being in DV, right?
This is a frustrating usability issue - a workaround that has been used to deal with this issue is to create new calculations every time a user needs to have a custom headers. Very tedious and time-consuming.
We used for this purpose (for on-premise OBIEE, but I guess, it should work) concept of externalization of names/decriptions of objects in presentation layer (see: https://docs.oracle.com/en/middleware/bi/analytics-server/metadata-oas/use-administration-tool-utilities.html#GUID-3F2BD5A3-2C8A-4F28-9379-7FCF32A748BE). Primarily it is intended for "localizing" presentation layer objects to different langauges, but can be used for your purpose as well. You just need to "expose" to end users (via some UI - for example in APEX) a table, which contains those "custom" presentation layer object names.
Hi Wilian,
Can you expand how it is possible in Answers? I though it is not available in Answers.
Regards,
Nikunj
Thanks Michal for this workaround idea. I think we could use it if we want to implement for small set of columns.
If my subject area has 1000+ columns. I will end up creating 1000 init blocks. And assume that if a report has 20 columns, it will fire 20 different SQLs to display column names.
Did you had large scale or small scale columns using localization? And did you had any performance issue?
Hi Nikunj,
you only need one Init Block (one SQL query) to retrieve all "strings" for presentation layer object names for display.
I dont think that retrieval of 1000 + column names would be a problem...
Rgds
Michal
I agree this will be a value addition.
However, you may try to create a local subject area with the subject area columns that you need and apply all preparation steps that are available for datasets. Not sure if this will serve your purpose but it could be a solution to some of the use-cases.
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.
