Skip to main content
Post a question

Notifications

Community site session details

Community site session details

Session Id : /jxfUvVUZ3bn31m9evxSqq
Finance | Project Operations, Human Resources, ...
Unanswered

Practice manager Power BI content

Like (0) ShareShare
ReportReport
Posted on 10 Aug 2020 15:42:14 by 1,205

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 

Entity: ProjectAccountingCube_Projects

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.

  • jhowe Profile Picture
    1,205 on 11 Aug 2020 at 12:16:58
    RE: Practice manager Power BI content

    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?

  • Blue Wang Profile Picture
    on 11 Aug 2020 at 01:29:23
    RE: Practice manager Power BI content

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,289 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,068 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans
Loading started