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?
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.
