Example: creating a compound attribute - Microstrategy

Report requirement

You need a report that contains sales figures by distribution center. Distribution center IDs are unique within each country, but the same values can exist in different countries.

How can you accomplish this?

Solution

Create distribution center as a compound attribute, with twoattribute forms, ID and Description. When setting up the ID, select the source table columns for Country ID and Distribution Center ID. This creates a unique identifier foreach distribution center, regardless of country.

Next, build a report using the distribution center attribute and a sales metric.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Microstrategy Topics