Okay...I have the same fallout as the guide. But why is it happening?
Looks like a data issue. If we click on the underallocation from Hypervisor to Servers, we can see that it's two line items that account for that underallocation:
First you can see that we used Memory Capacity as a weighting factor. If you go to the destination data and search on HV100289 and HV100288 you'll see that each of them has a memory capacity field that's blank... so that means there are dollars in those line items for the source data
But when you do the same search on the destination data you can see that those line items don't have values for Memory Capacity.
This means that even though there were $ to allocate, apptio used a weighting factor of 0 and didn't pass along any of those dollars. Wow! Sounds like I need to write another blogpost or create a video. ;-)
That was my initial conclusion too. But I checked and there are other hypervisors with no memory capacity data (e.g. HV100205, HV100206) which still received cost allocations. Why is that?
For some reason I can't see the image that you attached. I clicked on it but nothing came up. I'd clicked a handful of them when I was writing up my explanation and they either didn't have cost to allocate or didn't have memory capacity. I'll take a look at the two you mentioned above and see if I can identify why and come back with an additional explanation.
So I looked at 100205 and HV100206 and here is what I found.
First I searched for HV100205 in the source data and I can see that there is a cost of $875 and that all $875 got allocated.
then I searched on the same one HV100205 in the destination data.
Notice that there are 4 line items in the destination data for HV100205 and the $875 is split evenly between the two line items that have memory capacity. None is allocated to the ones that don't have memory capacity.
I got similar results for the ones I tested before posting my initial response, but wanted to try it against the ones you mentioned. HV100206 has the same type of results. I just wanted to test it across your examples to make sure my conclusion held up and it does.
Thanks for the challenge on this question. I'm definitely going to turn it into a blogpost or a video. I think it's a great lesson on troubleshooting and understanding exactly which values are going where.
Thanks again Debbie! Appreciate the explanation. Very helpful.
No worries @nicholas you’re keeping me on my toes.
Retrieving data ...