Hello everyone. My company has a query that is run on a very large fact table. The table has Approximately 900 columns of distinct data, of which about 700 is attribute data. (It is loan data with borrower information). The issue is some common fields within the database need to be represented differently for Each client in reporting that needs to be done. For example, one client might want FHA loans to display as FHA, another as FHA Loans, a third as "FHA Processed" etc.. (this is just an example). Generally I would do this in a dimention table with one column per client, and then dynamically select the appropriate column per client. However this needs to be done on almost every attribute within the fact table (~700), and 700 dimention tables just doesn't seem efficient. The other issue is a 700 column case when statement where each statement is multiple lines long takes a very long time to update and is prone to user error. Has anyone run into a problem similar to this before and what methods have they used to solve it? Thanks!