How to add attribute at the customer level which will generate a dimension in Analysis cubes?

(1) Share

Report

Posted on by bitshift

860

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?

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Suggested answer

Almas Mahfooz 11,003 User Group Leader on at

Like (0)

Report

RE: How to add attribute at the customer level which will generate a dimension in Analysis cubes?

You can use 'user defined' fields to track the additional attribute. From back end these fields can easily be updated and you can use it in reports and analysis cube easily.

There are two user defined fields available in customer card.