Dimensions

[#1]

Within my current product I have Localities which can drill into teams, for example, North, South, West Localities that can drill into team 1, team 2, team 3 for each locality.  What i'm after is creating a top level TRUST dimension. Is this possible?

Thanks

[Miguel_Angel_Baeyens · Accepted solution]

Hi Kevin,

Do you mean a "TRUST" value in a new field for all possible localities? If so, yes, just add a new line to your LOAD script:

LOAD Locality,
     Team,
     "Top Level" AS Trust
...
FROM ...

Hope that helps.

Miguel