SSAS adding columns

[mazhar555]

Hi,

I am using SSAS, want to concatenate values in two different column. E.g. I have Project ID, Project Name columns in 1 table.

I have Supplier Invoices with details in another table which are linked with Project ID.

I want to show my project id and name in one row. like "12345 - Test Project" and then i will display invoice detials associated with each project.

Regards,

Mazhar