Microsoft Cloud for Sustainability

I would like to see the screen for MSM's main influencer function add the ability to remove information that is not useful and to view additional analysis results that are not displayed on the screen.

This feature will improve customer convenience.

Issue:

====

We see there are few filters are not working while searching based on Lookup Fields. But those filters are working fine in Text Fields. Please find the below screenshot for reference.

Repro:

======

-Login to affected environment

-Go to Sustainability manager app

-Go to All emissions view 

-We see there are few filters are not working while searching based on Lookup Fields. But those filters are working fine in Text Fields. Please find the below screenshot for reference.

1.      Search Data in Text Field :

Search Result : Working as expected.

2.      Search Data Lookup Fields:

Search Result : Not Working as expected

Lookup Fields

 We faced the below,

Working Filters -> Equals, Does not Equal.

Not Working Filters 

-> Contains, Does not contains, Begins With, Ends With, Does not Begin With, Does not End With.

As per PG team this is the product limitation however users wants to have these filters on Elastic table.

Please create a graph that displays the target reduction per year as a declining graph against the actual progress per year's performance. For instance, the graph should illustrate a 10% yearly reduction until zero. 

However, The current version only displays a plain, no-slope line.

Or, if possible, now, I'd like to know if there's a way to set up parameters to show what I've described. 

Let me know if you have any suggestions.

Import jobs are accessible (for editing or even examination) only to the creator of that import. That job can be transferred by that user to someone else. The documentation says that it's possible for an admin to transfer import jobs.

However, users with an admin security role in MSM are not able to do this. It may be a global admin who can do this outside MSM. But we don't know. This gives us risk because our imports are complex, and if someone were to leave the company without transferring, we'd have to rebuild these jobs. And they aren't easy to document, so we wouldn't have much to go on.

I'd suggest that either the system is modified so that those in the admin security role are able to transfer import jobs or eliminate this ownership restriction. No other parts of the tool (like calculations or All Emissions) are restricted to the creator. Imports (from our perspective) aren't in more need of this "protection" than other functions.

This was raised via MS ticket Tracking ID#2409270030002995

In UAT, Users reported issues when exporting from the All Emissions tab - Error Message when exporting all Emissions.

This will become an issue when more metrics are added to MSM.

Advised by MS, there is a limitation to export only 5000 records.  

Here's the correspondence:  

There are multiple reasons why we would see slow view load performance or SQL timeout.

Here are few:

• Excessive number of columns in the view

• Missing index for the columns in the view

• Calculated Fields in the view column

• A lookup field set to sort in a view causing slower performance

• SQL timeout due to TotalRecordCount (TRC query)

Mitigation:

 1. Excessive number of columns in the view :

  - 1. When you load a view the number of columns selected will affected the performance.

  - 2. You can go to Advanced find and select the entity from the list and select the view.

  - 3. Then click on "Edit Columns" and select the column and click on "Remove"

  - 4. Now test the performance and see if that improve.

 2. Calculated Fields in the view column:

We can't index calculated field so it will affect the performance. In Unify you'll find a page of unindexable columns. Remove the calculate field from the view and see if that improves the performance.

Suggested to narrow down the filter and then export.

This is just not good enough with increasing volumes of data over numerous years, expected increase number of business units and increase number of metrics, data sources, data categories, etc.

Currently, the weight measurement unit is set to mtCO2e as default, which comes up in both the emission and the waste dashboards available in Microsoft Sustainability Manager.

It would be helpful if there is an option to choose the default unit for reporting on each of the dashboards. Organizations would be using tonnage (tonnes, kilotonnes, megatonnes) for waste reporting, and similarly varied units for their emission metrics.

Currently, editing a calculation model requires us to delete all the steps and nodes and build the model from scratch depending on where we would want to make an edit.

Would be helpful if users and developers were given an option to add and modify intermediary nodes without having to remove/reconfigure the existing steps that might come after that.

Please bring in the SSRS based reporting and Basic dashboard capabilities on the Sustainability manager. While there are out of box reports and dashboards, will be good to have basic capabilities enabling end users create their own versions, similar to what we have on Sales and Services apps.

Calculation job records are not fetching in the sub grid level.

However, we can see Calculation job records from advanced find.

Please suggest.

It was observed that some emission factor values do not populate the respective areas in the final emissions. This was the case where the emission factors have Other GHGs and its respective units filled in, but the value fails to come through post emission calculations.