Create Table in AXDW Dynamics ax 7

(0) Share

Report

Posted on by Community Member

Hi ,

I want to create a table in AXDW through Store Entity . means when i deploy my code it will create my own table(which will not be referring to any AXDB table or view base on AXDB table).

thank you!

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Israel Gonzalez 746 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Can you give more details about not referring to any AXDB table?

Was this reply helpful? Yes No
Martin Dráb 240,171 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The entity store is populated by deploying aggregate measurements (form System administration > Setup > Entity store). If you want something else, you shouldn't use the entity store.

If what you want isn't based on any table in Dynamics AX, how is it related to Dynamics AX at all?

What are you trying to achieve?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

thank you martin for reply.

lets say i want import website traffic data in that table . there is no third party tool . its in excel sheets.

i have aggregated dimensions and measures based on AX Tables and view . butt the website traffic data is in excel sheets and i have to use this data in analytics . how i can import this data in my model ? how i can migrate these data to table so when i deploy me code there should b a table the this data have to migrate to that table so i can use in my analytics.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Israel.

lets say i want import website traffic data in that table . there is no third party tool . its in excel sheets.

i have aggregated dimensions and measures based on AX Tables and view . butt the website traffic data is in excel sheets and i have to use this data in analytics . how i can import this data in my model ? how i can migrate these data to table so when i deploy me code there should b a table the this data have to migrate to that table so i can use in my analytics.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 240,171 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The entity store is used for Power BI and Cotrana integration with Dynamics AX. If you have some unrelated Excel sheet, why would you put it into the entity store? If your intention is to analyze the data in PowerBI and don't want to put that to AX, simply upload your Excel sheet directly to PowerBI. If you want your data in AX, use Data Management to import it.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

The data is related with RetailChannel Dimension i have to import this data to AX by creating my own table . then i have to build measures on it then have to use in entity and then in power bi.

Was this reply helpful? Yes No