Saturday 30 April 2016

Throwing error(Object BaseAttributeForm has already been deleted or is in an invalid state) while unchecking a table from attribute editor

This is a very common issue in Microstrategy 10. When we try to modify the source table list of an attribute form the following error message is shown "Object BaseAttributeForm has already been deleted or is in an invalid state".

Image source: Microstrategy technical support

Reason : This is a bug in the Microstrategy 10.

What do I do : This issue occurs only if the the table you want to remove comes before any other selected tables of sorted alphabetically.

For example, you had three tables selected A, B, C. Now you want to remove table A from the list. All you have do is

1. Rename A as D(anything that begins with D onwards),
2. Update schema then open the attribute editor again.
3. Now remove table D and Save and close. Update schema.
4. Rename D as C again.

You are good to go :)

Thank you so much for reading!


Why another Microstrategy blog?

Hi everyone, it's been pretty long period that I am working with Microstrategy. Microstrategy is a very powerful BI tool which is used in large number of projects worldwide. But to be honest it's not that developer friendly like some newer reporting tools. After working with it for years now I still feel that I don't even know fifty percent of what MSTR can do. There are lot of things that I come to know everyday. There are lot of things which seems impossible at the first glance but after spending a couple of hours or two we find a way most of the time. There are a hell lot of customization that we can do in MSTR which you might not be able to do in other tool.

I am not Microstrategy guru but I thought of sharing my day-to-day learnings with everyone who is working with Microstrategy and would love to learn from them.

I don't want to post the basic tutorials over and again in this blog as there are lot of materials available on the internet. I will try to cover all kind of tips and tricks that we might need and will try to address the issues that we face everyday.

Please feel free to write your ideas, suggestions and answers.

Thank you