Concat Text

[BIsrik]

Hi, I have built a cube with 3 dimensions namely location,First Name and the Designation. All the dimensions are of one level. In one of my reports from the cube i want to concat or join these three dimension values ie.locationFirstNameDesignation. How should i do this.

Srik

[Draoued]

It depends ....

What do you want to have in the report ??

Isn't it enough to nest First name and designation with the location in rows and to put the measure in colum ?

[BIsrik]

yes it is enough to nest these three dimensions. For an eg:

suppose:

location     FirstName      Designation      LocationFirstNameDesignation
    XYZ             ABC                  CMD                      XYZABCCMD

I wanted to nest these values of the dimension in the powerplay client and not at the transformer level.

Srik

[sys2674]

Hi BIsrik ,

I had the same requirement to concat to columns for Bill details-

Here is how to do,
1.In data source list create manually one column by rightclick insert column.Name it according
   to ur convience.
2.Select calculated ,then select calculation and from this you can calculate
    "Location" +  "FirstName"+"Designation"
3.Click ok.
4.You  can drag this column as dimension level.And in ur report u can have it all three   
   together

Hope this what your are loking for
Regards
Sys2674

[BIsrik]

U r telling me this on the transformer side or during the modelling part. My reqd is not this...

I want to join all the fields when i view the cube in the powerplay client.So, In transformer or during the modelling part the three are independent dimensions. When i see the cube there i have to create a column which is the combination of all the three dimensions.

I am not adding one more dimension( that is calcuated column) in the model design because out of the 200 reports to be developed using the cube only 4 reports needs this kind of concatination. So, by adding it as one dimension it unnecessary increases the cube size. That is why i want this concatination to be done when viewing the cube.

Srik 

[sys2674]

HI BIsrik,

I was telling in modelling part.Sorry i donot have any clue regarding this in reporting part.
I will try to figure it out.But in my case i added as dimension.
If u figured out pls let us know about it.

Good luck
SYS2674

[GJParker]

The answer to this is quite simply that it can't be done as you wish

[Draoued]

could you give an example of the wanted report , including the measure

Because if nesting is good enough , you can get such report when hidding sub-totals

			Quantity
Paris	Myself	IT designer	50
London	Yourself	IT Manager	100

[BIsrik]

Yes draoued, i need the same kind of report u have mentioned. Here paris and london are the categories in location dimension, Myself and yourself from first name dimension and IT designer and mgmr from the design.

All are 3 independent dimensions. I want to concat these categories as u have shown. Please tell me how should i do this...

Srik

[Draoued]

But this is very basic thing.

You drag the Location in Rows, and use Next level as many times as needed.
Then you drag the First Name dimension on the right side of the Location, and use Next level again.
You drag Design and next level as many time as needed.

You select the measure you want to see in Column.


In order to hide the sub-total, you highlight the sub-total and right-click the Hide Selection.

[BIsrik]

okay accept that this is basic thing...

but my report layout is like this...

   ParisMyselfITdesigner

Paris : 50

   LondonYourselfITManager

London : 100


Now for this i need to concat the three fields. Or is there any other way around for this...

Srik