Concatenate Dimension Values

[sjhussain]

Hello,

Hope everyone is fine.

We are working on a consultancy project in which we want to find out whether a project is worked by multiple companies.

We have the Project#, Count of Project per Company and the Company name as dimension.

For examples

Project Name, No. of Companies worked on Project

Proj002340, 3

Proj003430, 2

Proj001223, 2

Proj003452, 1

Now we have Company Dimension with the following Data

Company1

Company2

Company3

Company4

What we want to display is the following:

Project Name, No. of Companies, Company Name (Concatenated with '-')

Proj002340, 3, Company1-Company2-Company3

Proj00340, 2, Company2-Company3

Proj001223, 2, Company3-Company4

Proj003452, 1, Company2

We want to use Set Analysis if possible.

Will appreciate if someone can assist.

Thanks.

[sunny_talwar · Accepted solution]

Not sure why you want to use set analysis here to concatenate values. For dimension may be this:

Aggr(Concat(DISTINCT [Company Name], '-'), [Project Name])

[tresesco]

If the tables are associated (possibly with a Company key), you can simply take a straight table:

Dim: [Project Name]

Exp: Concat ( Distinct [Conpany Name] , ' - ')

[sjhussain]

Sunny,

Thanks you very much for the prompt response.

Excellent!

[sunny_talwar]

No problem, as long as you got what you were looking for, it is all good