The main issue you would like to change here is data mapping. It would help to understand data better and manage any reports easier.
You can check out our four golden rules for data mapping. Here I made one custom cube data mapping example based on them:
Rule N1. Any mapping should have at least one measure. There could be several measures in one mapping. Any measure will be mapped to one Time dimension (Rule N2) member.
Rule N3 stands for hierarchy structure. In most cases, you would like to set all information of the same object in ONE level and add a difference with advanced options setting what column is Key, what columns is Name (display name in reports). You can set many properties (Rule N4) for the object as well.
You can use any dimension for grouping, filtering data. You can use any property in the tabular report with the dimension expanded to members level. eazyBI automatically sums up any measure.
In many cases, you would need to make changes in mapping until you get the general data import as desired. Remember to delete previous setup before applying changes to it.
Daina / email@example.com