Can i combine two dimension together?

[#1]

Is there any way that i can combine two dimension and caluculate together in dimension?

[#2]

Try this...

Example::::::::::

RawData:LOAD * INLINE [
Doc ID, Name, Marks
112, a, 21
112, b, 22
134, c, 34
135, d, 33
135, a, 44

];

Data:LOAD [Doc ID],
Name,
[Doc ID]&'-'& Name As Doc_Key,
  Marks
 
  Resident RawData;
  DROP Table RawData;

Take a chart..Dimension : Doc_Key

Exp : Sum(Marks)

Regards-Bika

[narender123]

Hi,

Simply by making that dimention composite key.

like.

your 1st dimention that you want to combine is    a

your 2nd dimention  that you want to combine is  b

then in  load statement

Load

a &'-'& b as Key,

....

....

from tableabc;

Thanks.

Narender

[#4]

can i do without editing the script?

[narender123]

Yes,

Yes for  this you can do in script under load statement.

Thanks.

[#6]

Hmm..i think you misunderstand what i meant. I meant can i combine two dimension WITHOUT editing the script. Is there any way?

[#7]

Take Dimension Like...

Dimension1 & Dimension2

[nizamsha]

if u want to use two dimension mean and also u want to see the data in each dimension wise mean use

cyclic or drill down group or else combine the 2 field using and like this a '&' b as key  in script

[narender123]

Sorry dear by mistake i didnt get you.

You can do it only with script.

if you used cylic grioup or drill down yet you see the dimention seperately.

Alternative is that like

load

a,

b,

c,

a &'-'& b as key

from rableabc;

By this your both a and b will combine as kay also a and b are seperately like past.

Thanks.

[#10]

if((Group_Discharge <=40)<=(Group_Load<=40), Group_Load & ' <-> ' & Group_Discharge )

This is the code i'm using.

I need to combine two dimension and sum the data together to become only one column. Hope you all got what i mean.