data entity for inventtrans

(0) Share

Report

Posted on by Dogcomputer

I require to run a report for all inventory activity and I focusing on inventtrans file is the table I need to focus on. I cannot create a data entity for this since there is no natural key. How can I have this table viewable in OData and be able to publish it to our Azure database.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Martin Dráb 237,679 Most Valuable Professional on at

Like (0)

Report

RE: data entity for inventtrans

You can design an entity even without a natural key if you duplicate an entity and remove all data sources and start from scratch. But you'll still need some entity key.

Was this reply helpful? Yes No
Suggested answer

duocprogrammer@gmai... 35 on at

Like (0)

Report

RE: data entity for inventtrans

May be my answer is so late. But i hope someone can see.

www.youtube.com/watch

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

RE: data entity for inventtrans

i followed your video to create the entity, which is great, and I got no errors, but when I tried to export the entity on excel to make sure it is working, I only got one column on the excel export, which is: REFERENCECATEGORY, do I need to add every column by hand? to map it to the entity?

Was this reply helpful? Yes No
duocprogrammer@gmai... 35 on at

Like (1)

Report

RE: data entity for inventtrans

Dear AstridMalanka

Yes, you have to drag the fields that you want to export from data source of entity and drop into fields node of data entity.

After that, you have to right-click on data entity and click "update staging table". After "update staging table", you open the staging table of data entity, you will see new column is added.

Was this reply helpful? Yes No