create new dimension category

[Anonymous]

Hi,

I have 14 categories from Database column(dimension) and showing values for the expressions in a stright table . Now, I want to include one more category which is category14-category13- category12 which is not present in datasource showing all values of expression. How can I include this?

[#2]

In the script:

[TableName]:

LOAD

Category1,

Category2,

Category3,

.

.

.

Category1 & Category1 & Category1 as [Name]

;

sql

select * from table;

[aveeeeeee7en]

Hi Praveena

I think you're talking about Composite Key. You have to create this key in your Backend Script.

Your_Table_Name:

Load

category1,

category2,

category3,

category4,

category5,

category6,

category7,

category8,

category9,

category10,

category11,

category12,

category13,

category14,

category14&'/'&category13&'/'&category12    // Composite Key formation

From  ......./Tablename.qvd(qvd);

After adding category14&'/'&category13&'/'&category12     in your Backend Script, Reload the Application and see this Key Result.

Regards

Aviral Nag

[Anonymous]

sorry, I think I did not explain well,Composite key is not my desired result, I want  sum(category14, -category13, -Category12) for all expressions

[#5]

[TableName]:

LOAD

Category1,

Category2,

Category3,

.

.

.

(Category14 + Category13 + Category12 )as [Name]

;

sql

select * from table;

[aveeeeeee7en]

Could you please Attach your sample Application.

[crusader_]

Hi,

In this case better to use Rangesum() function to avoid possible mistakes.

[tblNm]:

LOAD

     Cat1,

     Cat2,

...

     Rangesum(Cat12,Cat13,Cat14) as SumCat

;

sql ...;

Andrei

[#8]

sent me your document, i help with that

my email is fredy7@gmail.com