There is at least one attribute not tracked in GP that the business uses to categorize various clients/customers, lets call it "Branch". Currently, there are some "custom" reports that we have built that run various stored procedures to extract the data, then through some custom logic, associate orders with a given "branch". What would be better, would be to make this association with a customer in GP, thereby making the assignment and cusom logic no longer needed. What kind of effort is involved in adding this attribute to a customer, then (manually) going back to assign this attribute to say 3-400 customers?
From there, once the Analysis cubes are added, I think this attribute should show as a dimension in the cubes?