Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Modify existing out of box Collection status power BI report in D365 F&O

(0) ShareShare
ReportReport
Posted on by 742
 
I want to add one custom field into existing Collection status report.

Below are my observation,

1. When I edit report query, I got to know about the main data source used in the query is present in AxDW database named as CustCollectionsBIMeasurements_CustCollectionsBICollectionStatus_MATERIALIZED
 
 
2. The entity name in F&O is CustCollectionsBICollectionStatus and Aggregate measurement name is CustCollectionsBIMeasurements
 
Questions:
 
1. What is the Attributes & Measure? Is it like it will group by fields mentioned in Attributes & will do math aggregates like Sum, Count, Max, Min etc. on fields defined in Measure?
 
2. If I add new custom field into CustCollectionsBICollectionStatus entity, then I have to add same in Attribute as well. So that I can use it in my Report. Is my understanding correct? or do I need any additional steps here?
 
3. Also, I don't see any extension option available here for Aggregate measurements. How should I modify it? Should I create a new Measurement for it and then use the same for Power BI report?
 
 
 

Edit query in Power BI desktop:
 
 
 
 
 
 

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans