Currently split option in dataset have limited options.
We should have more options like
Yes . Columns will duplicate.
Use case, we have different teams uses different software & instances. When we download our usage data , products list in one column with comma separated like below. We want to get the details of cost allocation by Dept ,Product, common users and unique users
Please see attached.
Yes. Rest of the columns should be duplicated.
We have enterprise licenses for software.
When we take dump, output will be like below with more attributes. We want to find common find out unique users, common users to different products, dept allocation costs, product allocation costs etc. If Columns are converted to rows, calculations become easy.
Example source data.
Name
Product 1
Product 2
A
p1,p2,p3
p3
B
p1,p3,p4
p1,p2,p3,p4
C
D
p3,p4
E
p1,p3
F
After split into rows.
p1
p2
p4
Use case, we have different teams uses different software & instances. When we download our usage data , products list in one column with comma separated like below . We want to get the details of cost allocation by Dept ,Product, common users and unique users etc.
C3
C1,C2,C3,C4
C1,C3,C4
C3,C4
C1,C3
C1,C2,C3
After split it looks like below.
C1
C2
C4
Any updates?
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.
