You’re offline. This is a read only version of the page.
Announcements
84
Create a data entity that will contain all sales headers and sales lines. This data entity will be used in Power BI and other third party applications. For every sales line in the header, the header record will be repeated.
I tried creating a data entity with the SalesLine table and joining the SalesTable table on the SalesId. When I try to browse my staging table, I have no data at all. Is there something I am missing with the SalesTable tables and their relations?
You said when you create your own entity , you did not find anything in staging table. Did you first try export option from data management and see if it works properly and you get data you need from that ? I would do that as a first step.
You can use the existing normal (non-composite) entities for sales order headers and sales order lines. Or if you want only one entity, you can either create your own, or extend the lines entity, adding fields that contain data from the order header.
Definetely not a dead end.
I see... I did not yet find another data entity that could suit our needs. Without using or creating a composite data entity, is it even possible to do what we're looking for? I guess what I'm wondering is am I heading down a dead end?
Search by word sales in data entities form or application exploerer and you will find some
The staging table is populated when you export / import data using a data management project. If you use OData (such as with Power BI) the staging table is not used.
I recommend you first check the out of the box entities, especially if you have limited knowledge about them. Maybe your knowledge increases in the process.
My lack of knowledge behind the data entities is why I was creating a custom one to acheive a data entity that contains sales headers and sales lines. Any particular ones to suggest?
Thanks for the reply
Any reason for creating custom entity when standard entities are available . Also you can use those standard entities in your custom entity
#1
André Arnaud de Cal...
294,095
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
