Dynamics Community Forum Thread Details

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

Hi,

This is an extended question to my previous query
https://community.dynamics.com/forums/thread/details/?threadid=77a9d74a-f77e-ee11-8179-6045bda7c23b

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?