Microstrategy Analytics

MSTR Reports drop records when two tables join on a column with null values CAUSE:   The MicroStrategy SQL Generation Engine does not support null values in attribute ID columns. Using column name as in attribute ID form is incorrect modeling for the MicroStrategy SQL Generation Engine. WORKAROUND:  Modify the ID form of the attribute definition to the following: ApplySimple('NVL(#0, 0)', ) This syntax is Oracle specific and this function replaces null fields with zeros. This function syntax, however, may be altered to replace Zero by any value. Ensure that single quotes are placed around the text. That should take care of NULL values in the joining column.

Enter a valid physical address error in Microstrategy  Web This issue occurs when adding an Email addresses with an apostrophe and trying to add it to the recipients list, the following error occurs in MicroStrategy Web 8.x/9.x/10.x/11.x etc This is a known issue in MicroStrategy Web 9.x/10.x.11.x and has never been fixed in Web. As a workaround MSTR suggests that to add the email from Developer. Work Around.  The email address can be entered from MicroStrategy Developer using the steps below: Login to Developer with admin privileges or access to create contacts. Go to Administration Click on Delivery Managers and then Contacts Right click in empty space in window where Contacts are displayed. Select New -> Contact Give the Name of the contact in the General tab and to to Addresses tab and click New Give the Name to be displayed on the contact and physical address Under Security tab select a user for "Link contact to user" Click on OK. Now go t...