Monday 30 October 2017

Unchecking a table from attribute editor throws error

It's a very common bug that has been seen across almost all the recent versions of Microstrategy. It's a very silly thing but often causes difficulty in modifying the attribute

Problem:
Let's say you have an attribute which has been linked to multiple tables a,b,c,d. Now you just want to remove table b from the definition. When you do that it doesn't allow you to do that and throws and error.

Solution:
Though it's an irritating bug, it has a very simple fix for this. You just need to rename the table you want to remove so that it comes last if you sort the table names. So let's say we rename the table b to table z. Now if you remove z from attribute definition then it will not throw error again. Now after doing this do not forget to rename the table name back to the original.

Thank you