ADD A NEW IDEA

Data Management

Showing 13

Training on the data model and how the tables relate to BC tables

It would be very helpful to have a training module / video / lesson that explains how the data model is structured. For example, what the purchase transactions table includes as well as some use cases. It would also be helpful to have a document t...
Kim Selle 18 days ago in Data Model 0 Future consideration

Ability to create measures

I would love to be able to create global aggregates that are available across all reports, much like measures in the Jet Analytics cubes. This would not only save my clients and myself a lot of time from having to re-create complex aggregates in e...
Marian Frueh 24 days ago in Data Model 0 Future consideration

Ability to write our own SQL code

I would love to be able to write SQL code to create custom fields and views. It would save me quite a bit of time and allow me to better meet client needs. Thank you for your consideration.
Marian Frueh 24 days ago in Transformations 0 Future consideration

Add Support for BLOB fields

Specifically the Note field of the Record Link Table. We have a number of reports where it would be beneficial to pull in a few of the most recent notes added to each document to get an overview of their status and determine if further action is n...
Adam 10 months ago in Staging 0 Future consideration

Queue Estimated Time

It would be great to be able to see an estimated time we could expect when we run our pipeline. If it takes a long time, it is reassuring to know that the time it is taking is expected and not that there is something wrong.
Kim Selle about 1 month ago in Data Model 0 Future consideration

Training idea

It would be helpful to have a training video specific to adding fields to one of the value entries table. I recently had to reach out for help with this because I'd missed a step or two. I wanted to add a field to the purchase transactions table i...
Kim Selle 3 months ago in Data Model 0 Future consideration

Preview data in reporting tables

It would be nice to be able to click a preview button and be able to see what the data in a reporting table looks like.
Brian Petersen over 1 year ago in Data Model 0 Future consideration

Use Company Display Name in all data model tables

It is not possible to rename companies in Business Central SaaS and instead a display name is used. It would be useful to have a switch option in Cosmos where all the data model tables are populated with the Company Display Name rather than the ac...
Rob Jackson 3 months ago in Data Management 0 Future consideration

View actual table name when hovering

It would be great when we are in the data model to be able to see the actual BC table name if we hover over a table. Since most of them are renamed, it's not intuitive for users to tell exactly where the data is coming from.
Kim Selle 3 months ago in Data Model 0 Future consideration

Hold key data and over write.

I would like the ability to hold certain data such as dates and have the ability to overwrite. I run multiple redundant reports for vendors, and I have to enter them one at a time using a new report. So I have to start fresh, enter a new vendor an...
Tim Keenum 4 months ago in Data Management 0 Future consideration