Use of sold products - purchased Electricity

(4) Share

Report

Posted on by Joke Laukens

142

I'm trying to set op some demo data on use of sold products - purchased Electricity.

The OOTB calculation model 'Use of Sold Products - Purchased Electricity: Location-Based' uses following logic referencing the activity.msdyn_lifespaninyears.

When importing some activity data, I cannot map with a 'lifespaninyears' field.

The field is not available in the Excel template either.

When checking out the documentation referenced in the excel template (https://learn.microsoft.com/en-us/common-data-model/schema/core/industrycommon/sustainability/purchasedenergy), there is mention of the lifespaninyears field.

So there should be a field.. however, there seems to be no possibility to fill it with de OOTB import possibilities??

FYI: I'm not considering manual entry as I want to prove the automation options.

What am I missing, or what is MSM missing?

Thanks.

Follow up question:

I wasn't able to import data into that field, but somehow (bug??/magic??) some data was automatically entered into the lifespan (in years) field..

How did that happen?

Categories:

Sustainability Manager

All responses (6)

Answers (1)

Sort by

Verified answer

Ivan (Vanya) Kashperuk Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

So Lifespan is as you can see on the form is a calculated field, you cannot manually specify it.

The way it is calculated is quite simple - total number of days between consumption start and end dates, divided by 365 (so it's total number of years, essentially)

Your screenshot seems to have the From/To dates the same, which should result in 0, and that's what happens in a test environment I tried.
Joke Laukens 142 on at

Like (0)

Report
Copy link

Link copied!

Hi @Ivan (Vanya) Kashperuk

Thank you for your reply. This helps a lot.

Follow up question:

You mention that it is a calculated field, as I can see in the form, but I'm not quite sure how I should see that..

There is a lock icon - but so has the correlation ID and the correlation ID was provided by me in the source Excel.

I cannot find that information in the documentation either, see screenshots below.

Can you please point out where I could find this information? Maybe I'm missing a crucial part of documentation.

Thank you.
Joke Laukens 142 on at

Like (0)

Report
Copy link

Link copied!

Hi @Ivan (Vanya) Kashperuk,

Can you please answer my follow-up questions?

Thank you!
Ivan (Vanya) Kashperuk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

All you can see is the lock icon, meaning this field is not editable.

OCID, on the other hand, would be editable on record creation, I guess.

But yeah, I will create a request to make it more explicit in the documentation
CU29081818-2 4 on at

Like (0)

Report
Copy link

Link copied!

That clears it up. If lifespan is calculated automatically from the consumption start and end dates, it makes sense that the field isn’t available for manual import.
CU29081818-2 4 on at

Like (0)

Report
Copy link

Link copied!

Good explanation of how the consumption dates determine the calculated value. When reviewing electricity data, comparing it with an online LESCO bill can also help verify the billing and consumption period.