Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by 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:
  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    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.

    1325.customer.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans