Microstrategy BI Tech Pub

Dynamic Aggregation: When you create a report, MSTR SQL engine writes a SQL in a report level and calculates all the metric values added in the report. After report creation and execution, you have two different options in all objects added in the report. a) Remove from report b) Remove from grid  - Dynamic aggregation Remove From Report: Right Click on any attribute and give "Remove from report" then MSTR SQL engine will rewrite the SQL in the new level and calculate all the values Remove from Grid: Right Click on any attribute and give "Remove from grid" (Still that object present in the report object and only removed from the grid) - In this case, No changes in the SQL. MSTR Analytical engine will calculate all metric aggregation based on the new level in the grid  - This is called DYNAMIC AGGREGATION   In simple terms, MSTR analytical engine dynamically aggregates and calculates all metric values when you remove any attribute from the grid How...

How to get Security filter Mapping details using Metadata Scripts? select OI.Object_name,OI1.Object_name,OI1.project_id from DSSMDOBJINFO OI join  (select I.Object_id A, I1.Object_id B,I.project_id C from DSSMDLNKITEM I join DSSMDLNKITEM I1 on I.Linkitem_id=I1.Linkitem_id where I.Link_id in (select Object_id from DSSMDOBJINFO where object_type=52 and Object_name='MD Security filter Link' and project_id in (select Object_id from DSSMDOBJINFO where Object_name in ('Project name 1','Project name 2') and object_type=32)) and I.project_id in (select Object_id from DSSMDOBJINFO where Object_name in ('Project name 1','Project name 2') and object_type=32) And I1.Object_type= 34 And I.Object_type=58) LI  on OI.Object_id=LI.B join DSSMDOBJINFO OI1 on OI1.Object_id=LI.A and OI1.Project_id=LI.C

How to get Connection Mapping details using metadata Scripts? select I.Object_name,I1.Object_name,I2.Object_name,I3.Object_name,I4.Object_name, from  DSSMDOBJINFO I inner Join (SELECT a1.LINKITEM_ID, a1.OBJECT_ID A, a2.OBJECT_ID B, a3.OBJECT_ID C, a4.OBJECT_ID D, a5.OBJECT_ID E FROM  (((DSSMDLNKITEM a1  INNER JOIN DSSMDLNKITEM a2  ON a1.LINKITEM_ID=a2.LINKITEM_ID)  INNER JOIN DSSMDLNKITEM a3  ON a1.LINKITEM_ID=a3.LINKITEM_ID)  INNER JOIN DSSMDLNKITEM a4  ON a1.LINKITEM_ID=a4.LINKITEM_ID)  INNER JOIN DSSMDLNKITEM a5  ON a1.LINKITEM_ID=a5.LINKITEM_ID  WHERE a1.LINK_ID='Connection Mapping Link ID (Object ID)' AND  a1.PROJECT_ID='0000000000000000000000000000000000000000' AND  a1.OBJECT_TYPE=32 AND  a2.OBJECT_TYPE=34 AND  a3.OBJECT_TYPE=29 AND  a4.OBJECT_TYPE=31 AND  a5.OBJECT_TYPE=30) ID on I.Object_id=ID.A inner join DSSMDOBJINFO I1 on I1.Object_id=ID.B ...

Subscription Setting in Project Duplication: We have Deliver subscription preferences in duplication wizard to handle all subscriptions while doing duplication. 1) Include user delivery subscription 2) Include contacts and contact groups 3) Include contact delivery subscriptions Prerequisite: Before project duplication, we need to make sure all subscriptions are available in source intelligence server. In case if we disabled, "Use Microstrategy scheduler" option in source I server then subscriptions may not available in source I server. In this case you can't find subscriptions option in delivery manager tab. In this case project duplicate will not bring any subscriptions to target project  How do we handle this? 1) Enable "Use Microstrategy Scheduler" Option 2) Restart I server 3) Duplicate the project with respective subscription preferences This will enable and bring all subscriptions to target project

Microstrategy Issues and Enhancement options - My View Internationalization a.  Translation Wizard  - We are getting overflow error in translation wizard b.    In MSTR, We don't have option to Map metadata language in group level  - if we have that option then it will be one time work c.    Report name with translation Whenever user mapped with some language creates any report then the report name applies to its translation automatically as well. In this case, when you login as administrator which points to default language then all report appears with the name of "Blank report" Why report names applies automatically to its translation. Is there any way to avoid this? d.   Language Mapping to user - In project Level                            i.        We don't have option to modify this after our first ...

Multi-Tenancy Project Configurations - Useful for Cloud environments Connection Mapping User Level Security filters Cache Setting - Connection Mapping level Translations -Metadata (Repository Translation Wizard) User Level Language Configuration Shared folder Configuration Customer filters

Useful Verification Scripts for Multi tenancy Project Architecture Verify connection mapping: 1)  LIST ALL CONNECTION MAP FOR PROJECT " Project Name "; From Connection mapping output, get all groups information and give that as input to step 2 - This will give security filter information for all group 2) LIST SECURITY FILTERS GROUP  " group " FOR PROJECT "Project name "; From Connection mapping output, get all Connection information and give that as input to step 3 - This will give Connection and its DSN Information 3) LIST ALL PROPERTIES FOR DBCONNECTION " Connection "; Run Below Script on any one object which is available for all customers - To Make Sure ACL is applied for all customers and using correct group 4) LIST ALL PROPERTIES FOR ACL FROM SHORTCUT " Object " IN FOLDER " Path " FOR PROJECT " Project Name "; Run below Script on any one object which is translated for all c...