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: