Similar Dimensions in a table

[M_Jay]

Hi,

I have 11 Dimensions named Track1, Track2,....Track11. And it may increase based on the projects which is dynamic.        How do I use these dimensions in set expressions? Any suggesion?

[rubenmarin]

Hi, How would you use that dimensions in set expression?

Maybe you have to load with crosstable so you have a TrackNumber field and another field with the value of the track, so you can filter all tracks with the same value.

[M_Jay]

Hi Rubenmarin,

Thanks for your response. I have lot of other columns along with NPITrack columns and other tables joined with the table.