Create a New Dimension Table??

[#1]

Hello Experts,

I was wondering how can I create a New Dimension table using some of the available customer dimensions. I have 2 levels of customers, I want to Pick level 1 and some from Level 2 and then Join them as a New dimension to use in the creation of some complex charts. How can I do that? Please check the attachment for more info and I am ready to provide more details if required.

Thanks Again

ANDY

[deepakk]

hi,

Try this for a soln.

if(wildmatch(Hierarchy 2,'John*') >0, 'John Group', if(wildmatch(Hierarchy 2,'Terry*') >0, 'Terry Group' and so on...

I hope this helps.

[#3]

Hello Deepak,

I am looking for something at the script level like If(Hierarchy1 = 'John' and Hierarchy2= 'John1', 'John2') Load as John Group. This way I am selecting some John 2 Hierarchy customers and not all and forming a different Dimension. Like John I have about 40 customers from Hierarchy1 and 100 from Hierarchy 2. I was looking something like the Valuelist function used in the charts to calculate this, which can replace the huge expressions in the chart with something at the script level as this groups are fixed and dont change at all.

[deepakk]

hi,

I have mention the above code for the script.

One reloaded you will have a new field say X. and it will contain John Group , Terry Group.

When you select Jhon Group from this field you will be see respective Jhon1 , jhon2 from other field .

I didnt get you last comments, I hope what i sugggested helps you out.