Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

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

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 10,996 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans