News and Announcements icon

Dynamics 365 CommunityForums Supply chain | Supply Chain Management, Commerce Aggregate measurement ...

Supply chain | Supply Chain Management, Commerce

Unanswered

Aggregate measurement is not creating materialized table or view in the sql server.

(0) Share

Report

Report

Posted on by AlokShrestha

1,643

Hello,

We have embedded Power BI reports deployed in both test and staging environment. In the test environment the reports are working fine but in staging environment it is not working. Looking into the sql server database AxDW, I found that in the test environment the "_materialized" tables are created for the aggregate measurement but in the staging environment, those "_materialized" tables are not created. When I refresh the entity store, it refreshes successfully without any issue. We are using InMemoryRealTime option in the aggregate measurement. Thank you.

All responses Img

All responses (2)

Answers Img

Answers (0)

AlokShrestha 1,643 on at

Like (0)

Report

RE: Aggregate measurement is not creating materialized table or view in the sql server.

Hi Judy, this is in tier 2 UAT environment so we don't have access to virtual machine to check the event viewer. Any other place I can look into?
huijij 19,811 on at

Like (0)

Report

RE: Aggregate measurement is not creating materialized table or view in the sql server.

Hi,

Did you check the Event Viewer to see if there is any issues reported?

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans