Dimension Table

Hey danielrabinovit ,

It depends on where you are within Sisense. If you are building a dashboard/widget, using the pivot-table and selecting fields that are duplicates of eachother, then you can use the pivot-table widgettype to accomplish this. It is not the most beautifull option , but it is an option.

Best way for this to do would be in the elasticube. You can create a custom-table and write SQL to create a dimension-table with unique records. You could do something like;

select distinct * from table_A

This works under the assumption that every field has the same values for duplicate records. If this is not the case , for example 1 column makes the rows unique, then you can select only the columns that are unique. Something like;

select distinct column_a, column_b, column_e from table_a

Besides distinct you can also use group by column_a, column_b, column_e to get the same result. 

Hamza