Synthetic Keys and Column as rows

[#1]

Hi All

I have three basic questions:

1. If i have multiple synthetic tables created , will it affect the performance of the dashboard??
2. If i am getting the data in rowwise manner instead of columns, ie instead having ITEM , ITEM CATEGORY and ITEM VALUE as two seperate columns, i have them as rows.(ITEM1 then next row is ITEM CATEGORY and have corresponding values in ITEM valueas column). Can i use Set expression to handle this? will use of multiple SEt affect the performance.
3. Can i use Set expression when using a calculated dimension??

Thanks in advance!!!!

Regards

Ganesh

[Gysbert_Wassenaar · Accepted solution]

1. Very likely

2. Maybe you can use set analysis. But unless you explain what exactly you wish to 'handle' there's no telling. Every expression affects performance.

3. Yes.

[avinashelite]

1.synthetic keys will surely affect the performance and even in the calculation .

2. It completely depends on the requirement , in few cases the columns representation works fine and in few the row wise works good .

3.if you talking about set analysis in the calculated dimension, then we cannot do but we can achieve it using conditional and aggr functions