nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Allow datasets created like Excel sheet.

Rajakumar Burra

Currently we don't have option to create a dataset with manual entry like Excel.

User has to import the CSV or Excel.

Instead , if we allow add rows and columns and update dynamically, it will useful.

Use case:

Currently we need some user inputs and map with existing data.

For this we are asking people to update in excel and upload manually.

Instead, if we have provision to update the values directly in Dataset, it will reflect in workbook immediately.

Find more posts tagged with

Needs Votes

Status: Needs Votes

Comments

Luis E. Rivas -Oracle

Thanks for submitting the idea. I'll set this to Needs Votes. I do have some clarification questions on your submission - is the idea to allow users with Dataset Authoring role to 1. Dynamically create a table in the Dataset editor such as by Insert Table into the diagram and the user selects number of columns and rows 2. Allow users with Dataset Authoring role to add additional rows to the dynamic table and when saved have that immediately reflected in the consuming applications such as Workbooks. If you could provide just a bit more info on the flow you currently have 1. create dataset with Excel > 2. Users create workbooks 3. users edit Excel and update dataset and save 4. Workbook reflects changes (or maybe they do a replace in workbooks) - Thank you.

Rajakumar Burra

@Luis E. Rivas -Oracle Here is the more details explanation which you have already explained.

Author t should have option to create table manually with option to select number of rows and columns in Dataset.
Edit capability to update /add/remove rows to whoever having Edit permission.
Save the Dataset should reflect the updated value wherever it is used.

Currently we need for couple of Workbooks which needs subjective feedback from users. It will help in streamlining out process.

Luis E. Rivas -Oracle

@Rajakumar Burra - Thanks for clarifying and confirming the use case.

Branden Pavol

While I would be interested in this, the data is still only stored in the "cloud" storage and can't be used by writing SQL or anything else. So what we have done for these scenarios is used APEX to create the table. That gives the users the ability to add rows and change values on the fly, hit save, then it's saved to the database. Then you can use that table for OAC reporting or any other types of data modeling.

So, to piggyback off of this, if there could be an easier way to embed the APEX interactive grid/table to allow users to create a table, that would be even better.

Let's blend more APEX and OAC functionality together to get the best of both!

Luis E. Rivas -Oracle

@Branden Pavol Thanks for sharing this—interesting idea. We’ll take a closer look to better understand what might be possible.

Branden Pavol

@Luis E. Rivas -Oracle let me know if you would like to set up a meeting to show you how we are doing it today.