Dimension

[#1]

Hi All,

I have dimension like Mod_1, mod_2, mod_3 and new_1, new_2, new_3.

Now i want to use 'case statement' so that my result wil b mod_1, mod_2, mod_3 = 'Mod' and same as with 'New'.

please suggest how to use case statemnt in dimesion. I need this on urgent basis.

Thanks

[sujeetsingh]

Akrati,

Clik on calculated dimention tab  and write the desired Case Statement for your requirement.

[sujeetsingh]

And if you eloborate your Case functionality than i can help you ..

[#4]

Hi,

In the X-axis, i want MOD and NEW instead of mod_1, mod_2

i want mod_1 and mod_2 comes under MOD by using the case statement.

How its possible?

[sujeetsingh]

Sorry i didnt get u ...Why dont u just give a sample

[Gysbert_Wassenaar · Accepted solution]

try this as a calculated dimension:

if(wildmatch(MyDimension,'mod'),'Mod',if(wildmatch(MyDimension,'new'),'New'))

But perhaps you should fix this in the load script by adding a mapping table and using applymap to create a new field ModNew. The use the new field instead of the original dimension.

MapDim:

mapping load * inline [

Key,Value

mod_1, Mod

mod_2, Mod

mod_3, Mod

new_1, New

new_2, New

... etc

];

load *, applymap('MapDim', FieldWithModAndNew) as ModNew

from ... etc

[#7]

Hi

thanks for the reply.

I will try this and get back to u.

[#8]

I just want to know, how to rename the expression??

In my tooltip the whole expression is visible.. i want to rename this

how to do?

[sujeetsingh]

Just go to label on expression tab and do it

[#10]

Thanks...

Done with that!!!