-
Conditional Formatting in a chart based on another column
Description OBIEE 12c : Does OBIEE Have An Option Of Conditional Formatting Graph Based On Another Column Of The Same Graph Views. (Doc ID 2263081.1) I found this on MOS and this seems to be the latest version of this oft-requested feature. This should be prioritized. Use Case and Business Need Need a simplistic way of…
-
Ability to have conditional format in the specific cell in pivot or table
Description In excel, we can set certain cells to be highlighted in yellow or red or any color depending on the condition even though we have multiple columns. For example, anything is more than 5, the cell highlights in red in column A. Anything is more than 5, it is in yellow in column B. However, in OA, it seems not to…
-
Conditional Formatting - Specific cell
Organization Name Arcadis Description The is constantly the requirement of applying conditional formatting on independent cells to have easier color-coding use for the end-user. Depending on ranges predefined during design the cells would change the format. Use Case and Business Need The business ( Project Managers,…
-
Alternative Sort Column
Description Need ability to provide alternative sort column or hide the sort column like OAC classic so data can be rendered correctly. Can only sort Alphabetically on Visualizer. Use Case and Business Need Refer bar chart where the months cannot be sorted correctly Putting month number to sort correctly but then label has…
-
Tuning parameter to limit OBIEE SQL text
Organization Name Sage Intacct Description We are currently using OBIEE 12.2.1.4 and planning to upgrade to OAS soon. We allow users to have ability to create their own reports, however sometimes, users makes silly mistakes, and may accidentally generate a huge OBIEE SQL. The request is to have a tuning parameter to limit…
-
Data Flow to load/save to Snowflake database
Organization Name Elkay Manufacturing Description Data Flow to load/save to Snowflake databaseTopic posted June 9, 2020 by Ajith Ponnamaneni, tagged Analysis, Developers, Prepare and Model Data, Reporting 12 Views, 2 CommentsSummary:Data Flow to load/save to database currently works for only few, can have load/save to…
-
Allow DV author to set a line pattern for line graph in DV
Organization Name San Francisco Bay Area Rapid Transit District Description There is no easy way to define the line pattern (dotted, dashed, solid) or line width in a line graph. It is a very simple thing done in OBIEE classic, excel graph or any visualization tool, but not in DV. Use Case and Business Need Our users want…
-
change system wide default font, font size and other OAC analysis/ report properties
Description When OAC analysis is exported to excel with default font size, exported excel shows data in 25% smaller font. This is because OAC reports use font size in pixels vs excel uses font size in points. eg: Default font size in OAC report is 12, when exported to excel, data shows in font size 8. It would be great if…
-
Change Owner of Data Sets
Organization Name interRel Consulting Description Need to be able to change owner for data sets. Use Case and Business Need Catalog objects in Classic Home can have owner changed. Same needs to be done for DV Data Sets. we have had people leave and those data sets are essentially locked. we can download and re-upload then…
-
Metadata Web Interface
Description We need to be able to do the following in Analytics Cloud: Ability to copy and paste existing rollup to another alternate rollup with shared members and be able to edit the rollup. Ability to copy and paste rollups from one cube to another cube. Ability to search with Alias in the outline editor. Ability to…
-
Keep "treat as" (attribute or measure) consistent between data sets, dataflows, data base tables and
Description Right now, when you load file data into ADW and then fetch that for a multi-table model (I wanted to test the new features), you have to set "is this an attribute or a measure" three times because apparently that information isn't kept: * when you upload the file * when you use a data flow to load the data into…
-
Ability to close data and grammar panel by default when opening DV project
Organization Name Worthington Industries Description When a DV project is first opened, the Data and Grammar panels are automatically toggled on. This takes up a majority of the screen real estate and distracts from question the report is supposed to be answering. I would like to be able to toggle them closed to get the…
-
DV waterfall chart revision
Organization Name Assicurazioni Generali S.p.a. Description New logic for the waterfall chart in order to let it become a “waterfall build up” (horizontal and vertical). - by default, the chart should set on one of the axes all the values of a dimensional attribute (either sorted by alphabetic /ascending/descending /…
-
Sending and retrieving analyses data using ftp
Organization Name Megafon Description 1. Sending data using ftp Users can send reports through mail, pager, etc. FTP transfer is possible only using specially designed script e.g https://wapcobiee.wordpress.com/2015/08/27/obiee-send-content-to-ftp-server-network-folder/ It would be great if we can us it as a part of a…
-
Export Functionality should be avalaible in OAC Agents Scheduler.
Organization Name Suncorp Corporate Services Pty Ltd. Description Currently we are only able to view results while scheduling OAC Analysis using agents and unable to take an export. It would be great to have export functionality avalaible on Agent Page itself to take exports in formatted/unformatted versions. This will…
-
Hierarchy View Option
Description Would like the ability to choose between opening a hierarchy Top-Down (default) and Bottom-Up. Bottom Up is ideal for financial reporting hierarchies. This option exists in OAC Classic - however, I haven't found a way to do this in DV. Use Case and Business Need Best view for financial reporting hierarchies…
-
Desperate requirement to have a Custom Tile/Card Chart Plugin for OAC and GBUA (OAS DV), similar to
Description Top Life sciences customers globally are looking to have OAC used on top of HSGBU products for analytics and data sciences analysis for their trials. One of the requirements w.r.t dashboards in OAC is to have good number of KPIs and KRI's and then to have capability for drill down for detailed clinical trial…
-
View list of active OAC users in dataset
Description Currently there is no way to monitor active users other than scrolling through console a page at a time. We would like a way to view active OAC user accounts and their roles so we can compare in a project against HR data to hightlight leavers who have active OAC accounts or inappropriate access. Use Case and…
-
Detailed log message on snapshot restoration
Organization Name CIMB BANK BERHAD Description To have a log message in details or with description on the OAC Snapshot Restoration. It should show all the elements within Snapshot restored. Any failure should throw an exceptional report and perhaps can have suggestion / steps on how to troubleshoot it since the program…
-
OAS : Administrator should have control on "Create Connections" in DV
Organization Name Capgemini Description Team, We need a mechanism in OAS to control DV Content Authors creating new External Connections in DV. By default, all DV Content Authors are authorized to create all the available External Connections in DV( Create->Connection). It will be really helpful, if we have below mechanism…
-
OAC Gen2 Instance server performance monitoring
Organization Name Description Service Monitoring is an essential piece of information for mission-critical systems. This will help to size the systems and to leverage the elasticity. Currently, we cannot monitor OAC Analytics Instance service, Apart from status monitoring, we should have the ability to monitor the server…
-
Adding Excel binary type(xlsb) export in agents in OBIEE
Description We are using OBIEE 12 c Version , the agent associated with the OBIEE reports do not have export option as Excel binary type(xlsb) MS Outlook has 20mb size limit due to which large file with xlsx file type cannot be emailed to the user ,xlsb file size is less in comparison to xlsx file size , for 360K records…
-
DV Audit Capability
Organization Name Home Office Description Admin users aren't able to see artefacts belonging to other users in DV which is a blocker for the organisation to use DV tool. Use Case and Business Need Audit capability to know which users loaded what dataset and what projects have they built is an essential feature without it…
-
report on iBot logging
Description in OAC (Classic) provide reporting for Admins on iBots: last 30 days (preferably more), per iBot, per instance, per user/recipient, status and any error messages Use Case and Business Need We use iBots a lot (thousands are sent each day), and then it's important to keep track of it, to detect and fix errors.…
-
Add functionality to pass data action filter though to target reports with pinned divisions
Organization Name Broadridge Description The current functionality is limited to "pinned" (report-scope filters) applying to all canvases in the report but the data action only targets a single canvas. Users want to be able to use a data action on the pinned filter to apply to all canvases (source and target). Request: Add…
-
Hide DV data sets from Subject Area
Organization Name Lower Colorado River Authority Description Hide DV data sets from the Subject Area to give this area a clean look, but still let user to open the reports based the DV data set's access security? Use Case and Business Need Please see attached doc. Original Idea Number: e8fd6453ae
-
BI Publisher ability to Add Printer with Username and Password (v2/DeliveryServerConfigService)
Organization Name Ferguson Enterprises Description The SOAP API for BI Publisher does not allow for the creation of printers with a username and password. The WSDL is v2/DeliveryServerConfigService and the method is createPrinterDeliveryServer. Other create methods work with the same input property types…
-
oCPU´s consumption of the OAC.
Description We want to know the consumption of oCPU´s of the OAC in order to increase the user quantity. We want to know the consumption of oCPU´s of the OAC, during the last 30 days, the last 07 days, the last 24 hours. As well as the highest peak during these periods. Is it possible for us to obtain this information…
-
Calculate the Login of a User
Organization Name Calculate the Login of a User Description Dear Team, The Oracle Support Team had provided me a tool named Postman from where I would be able to get the login details of users for only a week. I would like to raise the ER for the following: 1) How can I get the User login for more than a week i.e. say for…
-
Add the Limit Values By option to visualization filters
Organization Name GSO Description Right now only the Canvas Filters have the Limit Values By option. This option should be available for the visualization filters as well. Use Case and Business Need When using multiple filters inside a visualization you may have the need to limit their results by one another or not limit…
