Announcements
Hi as referenced in https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/practice-manager-power-bi#reports-that-are-included-in-the-power-bi-content where is
in the AOT? I can find
[ProjectAccountingCube_Projects as a view
definition :
ALTER VIEW [dbo].[ProjectAccountingCube_Projects] AS SELECT NAME AS PROJECTNAME,DATAAREAID AS DATAAREAID,CUSTACCOUNT AS CUSTOMERACCOUNT,PROJINVOICEPROJID AS PROJECTCONTRACTID,PARENTID AS PARENTPROJECT,SORTINGID AS SORTFIELD1,SORTINGID2_ AS SORTFIELD2,SORTINGID3_ AS SORTFIELD3,STATUS AS STAGE_VALUE,TYPE AS PROJECTTYPE_VALUE,DEFAULTDIMENSION AS DIMENSION_,WORKERRESPONSIBLEFINANCIALNAME AS PROJECTCONTROLLER,WORKERRESPONSIBLEFINANCIAL AS WORKERRESPONSIBLEFINANCIAL,WORKERRESPONSIBLENAME AS PROJECTMANAGER,WORKERRESPONSIBLE AS WORKERRESPONSIBLE,WORKERRESPONSIBLESALESNAME AS SALESMANAGER,WORKERRESPONSIBLESALES AS WORKERRESPONSIBLESALES,PROJID AS PROJECTS,PARTITION AS PARTITION,RECID AS RECID, ProjTableCube_Projects_SFK AS ProjectAccountingCube_Projects_FK, STATUS_LABEL AS STAGE, TYPE_LABEL AS PROJECTTYPE FROM ProjectAccountingCube_ProjTableCube_MATERIALIZED GO
in AxDW but I am unable to find how it is referenced in AOT... thanks.
Hi, yes I understand how the entity store works, my question was why can I not find VIEW [dbo].[ProjectAccountingCube_Projects] anywhere in the AOT?
HI Jhowe,
ProjectAccountingCube is an aggregate measurement.
It is the Entity store that is transferred to the data warehouse database (AxDW) that Power BI reports access through a DirectQuery. This database is filled with data on demand only, either one-time or in a scheduled batch job.
You can read this Doc: docs.microsoft.com/.../power-bi-integration-entity-store
André Arnaud de Cal...
293,289
Super User 2025 Season 1
Martin Dráb
232,068
Most Valuable Professional
nmaenpaa
101,156
Moderator