Grouping Dimension Values

[#1]

Hi,

I want to have account type as my dimension. account type has value A, B, C, D, E, F, G

What If I want to have A. B, C as Group 1. B, C, E as Group 2, E, F, G as Group 3?

it does overlap and I know that. but I want to have three dimensions Group 1, Group 2, Group3 and as described above they are combinations of original values.\

Thanks!

David

[sunny_talwar]

I guess try removing all the square brackets in your inline load. They might not be needed

Load * inline [
Group, Building Time Zone
NA, Arizona
NA, Central Time
NA, Eastern Time
NA, Pacific Time
EMEA, "Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna"
EMEA, "Brussels, Copenhagen, Madrid, Paris"
EMEA, "Dublin, Edinburgh, Lisbon, London"
APAC, "Beijing, Chongquing, Hong Kong, Urumqi"
APAC, "Calcutta, Chennai, Mumbai, New Delhi"
APAC, "Kuala Lumpur, Singapore"
];

Also, the Building Time Zone includes all the comma separated list? or does the fact table will only include one of the zones from the list?

[jason_nicholas]

Excellent! It worked!

For some reason, multiple word items do not need to be included in brackets in this use case. To answer your question for anyone digging this up in the future:

The Building Time Zone entries will ONLY include all comma separated entries, not separate. In other words, "Amsterdam, Berlin, Bern,  Rome, Stockholm, Vienna" is one entry, and will not appear separated. It can be thought of as a single term.

Thank you!