EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  3. Topics

Useful Administrative Tips and Command Lines for MicroStrategy on AWS

Henri-Francois Chadeisson

Director, Sales Engineering • MicroStrategy

Description


Strategy on AWS now supports Amazon Linux, which is more cost efficient than Red Hat. The downside of using Amazon Linux is that it does not support a GUI such as VNC. Here is a quick guide to help everyone manage your Amazon Linux environment in the command line.
 
This knowledge base will cover the following topics:
 

  1. Actions and tools that are available to you as a Developer and/or Administrator
  2. Useful generic Linux commands

Actions and tools


Before we start, please take the time to view the given list of administrative actions, related tools, and the machines where the action needs to be performed. View the following table for more information:
 


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


 

Must-Do Configuration

Although the system is mostly preconfigured by default, some manual actions are still required to get a fully operational administration setup. We recommend doing those before starting your work on your AWS Linux platform. Each incremental configuration is documented in the following detailed action sections.
 

Connect to Strategy Web

  1. Once your environment is provisioned, you should receive the following email:

 

ka02R000000g2hkQAA_0EM44000000QD8g.png

 

  1. Configure your Usher badge as described, or note your password.
  2. Click on Access Strategy Platform to open Strategy Web.
  3. Login using Usher or the login/password provided in the email.


 

Connect to the Developer Instance

  1. From Strategy Platform home page, scroll down to the Essentials Connections section.
  2. Click on the Developer Machine Name to copy it.


 

ka02R000000g2hkQAA_0EM44000000QD8l.png

 

  1. Open your remote desktop connection tool.
  2. Configure the connection with the Machine Name link, user, and password.
  • From PC: go to Start Menu and type “mstsc” or “Remote Desktop Connection”
  • From Mac: install Microsoft Remote Desktop from the App Store: https://itunes.apple.com/ch/app/microsoft-remote-desktop-8-0/id715768417?l=fr&mt=12


 

  1. Before logging into the Developer Instance, you should configure a folder redirection in order to copy a file from your Machine to the Developer Instance.


 


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8Browse:Allows seeing an object in the Folder List and Object Viewer.Use/Execute:Allows the usage of an object needed for execution, for example, a filter that must be used in a report execution.Read:Allows viewing the object's definition and Access Control list.Write:Allows the modification of the object definition, but not the object's Access Control list.Delete:Allows deletion of the object.Control:Allows modification of the Access Control list of an object and takes ownership of an object.ActionToolMachineConnect to Strategy WebYour browserYour machineConnect to the Developer InstanceRemote Desktop toolYour machineConnect to the Server InstancePutty / WinSCPDeveloper InstanceCreate a new MySQL DatabaseMySQL WorkbenchDeveloper InstanceCreate an ODBC connectionCommand Line / PuttyServer InstanceGet Strategy Server statusCommand line / PuttyServer InstanceStart and/or Stop StrategyCommand Line / PuttyServer InstanceConnect to DeveloperDeveloperDeveloper InstanceTransfer Files to Server and/or Tomcat (images, plugins)WinSCPDeveloper InstanceStart and/or Stop TomcatCommand LineServer InstanceFrom Mac : “Redirection” TabFrom PC : “Local Resources” Tab > “More” > “Drives”


 
 

Connect to the Server Instance


From the Developer Instance, there are 2 ways you can connect to your Server Instance:
 

  1. Putty: for executing administrative commands on your Server
  2. WinSCP: for browsing and transferring folders and files


 
Before configuring both, you need to get the Intelligence Server Address from Strategy Platform home page.
 

Configure Putty

ka02R000000g2hkQAA_0EM44000000QD95.png

 

  1. Find and open Putty from the Developer Instance’s Desktop. 
  2. Paste the Server Address in the Host Name, as well as in Saved Sessions field.

    Make sure to Save the Server Address.
  3. Double click on the newly created entry in Saved Sessions to log in.
  4. Use mstr username and password from the Welcome email.
  5. When prompted on a Security Alert, choose the option Yes.


 

ka02R000000g2hkQAA_0EM44000000QD9F.png

 

Configure WinSCP

ka02R000000g2hkQAA_0EM44000000QD9A.png

 

  1. Find and open WinSCP from the Developer Instance’s Desktop.
  2. You should be prompted to add a New Site, which is your Server Instance connection.
    • Paste the Server Address in Host Name.
    • Choose this option: Port: 22.
    • User Name: mstr.
    • Password: the one you got from the Welcome email.
  3. Save your connection and click the Login button.
     


 

ka02R000000g2hkQAA_0EM44000000QD9K.png
ka02R000000g2hkQAA_0EM44000000QD9P.png

 

Configure Notepad++ for Win SCP


WinSCP can open files that are remotely stored on the server and let you edit and save these files directly on the server. Notepad++ is very convenient for this, and can be configured by default:
 

  1. Right click on a file in Win SCP remote folder.
  2. Browse to Edit > Configure.
     
ka02R000000g2hkQAA_0EM44000000QD9Z.png

 

  1. Click the Add button on the pop-up that shows up in the window.
  2. Select External Editor and then click the Browse button.
  3. In the popup that shows up, click on This PC > Windows (C:) > Program Files (x86) > Notepad++ > notepad++.
     


 

ka02R000000g2hkQAA_0EM44000000QD9e.png

 

  1. Confirm by clicking OK on all opened dialog box.
  2. Finally, right-click on a file in Win SCP > Edit > Notepad++.
  3. Make your changes and save. Notepad++ should always be available by default from now on.
     


 

ka02R000000g2hkQAA_0EM44000000QD9j.png

 

Create a new MySQL Database


MySQL is installed by default on the Server Instance; you can use this database engine to store your data. MySQL Workbench is installed on the Developer Instance and let you do most of MySQL operations.

ka02R000000g2hkQAA_0EM44000000QD9o.png

 

  1. Find and open MySQL Workbench from the Developer Instance Desktop.
  2. Create a new connection with the + button.
    • Set a connection name.
    • Hostname: same as for Putty and WinSCP.
    • Choose the option Port: 3306.
    • Username: mstr.
  • Password: use the usual one. 

 

  1. Use the Test Connection feature to make sure it works.
  2. Click OK to continue on. 

 
You should now be able to connect to MySQL server, browse Schemas (databases), execute queries and import data.
 

  1. To create your own database, right click on any Schema > Create Schema.

In order to connect Strategy to this database, you need to create a new ODBC Connection in the Server using Putty.
 

ka02R000000g2hkQAA_0EM44000000QD9t.png

 
 

Create an ODBC connection


 

  1. Connect to the Server with Putty.
  2. Go to Strategy bin folder: cd /opt/mstr/MicroStrategy/bin
  3. Create the ODBC connection using the connectivity wizard : ./mstrconnectwiz MYSQL_CONNECTOR NAME_YOUR_CONNECTION SERVER_ADDRESS 3306 MYSQL_SCHEMA_NAME /usr/lib64/libmyodbc5w.so -u:mstr -p:USUAL_PASSWORD


 
If you need additional resources, check out this KB article.
 

Get Strategy server status

This can be done in command line from Putty:

  • cd /opt/mstr/MicroStrategy/bin
  • ./mstrctl -s IntelligenceServer gs


 

Start / Stop Strategy


If the user is still using Putty, they can use the following:

  • Stop Strategy: ./mstrctl -s IntelligenceServer stop
  • Start Strategy: ./mstrctl -s IntelligenceServer start


Note: An error will show up If the service is not stopped. Retry starting it until the error disappears
 

Connect to Developer 

ka02R000000g2hkQAA_0EM44000000QD9y.png

Strategy Developer is not configured to connect on the Server by default.

  1. Find and open Developer from the Developer Instance Desktop.


 

Transfer Files to Server and/or Tomcat (images, plugins)

The easiest way to transfer to the Server file is by using WinSCP. This requires transferring files from your Computer to the Developer Instance first. In order to do this, make sure the Folder / Drives redirection is properly set-up in the Connect to Developer Instance configuration steps.
 

  • Best practices for images

Strategy relies on different folders for images depending on the use case:

  • Web Display: /opt/apache/tomcat/apache-tomcat-8.0.43/webapps/MicroStrategy/images
  • Mobile Display: /opt/apache/tomcat/apache-tomcat-8.0.43/webapps/MicroStrategyMobile/images
  • Library: /opt/apache/tomcat/apache-tomcat-8.0.43/webapps/MicroStrategyLibrary/images
  • Exports: /opt/mstr/MicroStrategy/IntelligenceServer/images

 
We recommend all images to be copied at least to the 4 folders above.
 

  • Best practices for plugins

Most D3 and ESRI plugins should be available in all Strategy tomcat folders:

  • Web: /opt/apache/tomcat/apache-tomcat-8.0.43/webapps/MicroStrategy/plugins
  • Mobile: /opt/apache/tomcat/apache-tomcat-8.0.43/webapps/MicroStrategyMobile/plugins
  • Library: /opt/apache/tomcat/apache-tomcat-8.0.43/webapps/MicroStrategyLibrary/plugins

 
Other plugins are handled on a case by case basis depending on the target interface.
 

Copying files

  1. To copy a file from the Developer Instance to the Server Instance, browse to the target folder in WinSCP.
  2. Drag and drop the target file there. 

Note that new plugins require to restart tomcat in order to work; images don’t.
 

ka02R000000g2hkQAA_0EM44000000QDA3.png

 
 

Start / Stop Tomcat


 

  1. Open Putty.
  2. Go to tomcat binary folder: cd /opt/apache/tomcat/apache-tomcat-8.0.43/bin
  3. Stop tomcat: ./shutdown.sh
  4. Start tomcat: ./startup.sh


 
Upon re-starting Tomcat, it can take around 30 seconds for MSTR to restore connectivity.  Note you may receive a 503 Bad Gateway error on the webpage if it hasn’t fully restored yet. 

 

Other useful generic Linux commands

Navigate to a folder


Command name : “cd” - stands for “Change Directory”
How to use it: cd <folder name>

  • cd /home/mstr
  • cd /opt/mstr/MicroStrategy/bin
  • cd /opt/apache/tomcat/apache-tomcat-8.0.43/bin


 
Show files for current folder
Command name: “ls” - stands for “List Segments.”
How to use it: ls -l
 

Which folder am I in?


Command name: “pwd” - stands for “Print Working Directory.”
How to use it: pwd
 

Get help on a Linux command


Command name: “man” - stands for “Manual.”
How to use it: man <command name>

  • man cd
  • man pwd

Create a folder


Command name: “mkdir” - stands for “Make Directory.”
How to use it: mkdir <new folder name>
This will create a folder inside the current folder you are in (use pwd to check where you are)
 

Delete a folder or a file


Command name : “rm” - stands for “Remove”
How to use it: rm <file_name> / rm -r <folder_name>
 
This supports wildcards.
 

Unzip a file


Command name: “unzip.”
How to use it: unzip <zip_file_name.zip>

Kill a process


Sometimes, a process won't stop by its usual mean (shutdown script, stop option of a binary). A brute alternative to stop it anyway without restarting your whole machine is to kill the associated process.

  1. Find the process ID (pid) : ps aux | grep <process name>
  2. Kill the process based on it's ID : kill -9 <pid>

Example: Kill Strategy Server
Type: ps aux | grep MSTRSvr
Which returns:
[mstr@env-80517laiouse1]$ ps aux | grep MSTRSvr
mstr      1016  0.0  0.0 110468  2204 pts/0    S+   17:29   0:00 grep --color=auto MSTRSvr
mstr      8638  0.9  8.5 3408236 1344720 ?     Sl   09:37   4:27 /opt/mstr/MicroStrategy/install/IntelligenceServer/bin/MSTRSvr -w /opt/mstr/MicroStrategy/IntelligenceServer -t status-iserver.xml /opt/mstr/MicroStrategy/install/lib/libMSTRSvr2.so -n CastorServer
 
Type: kill -9  8638
The process should now be killed.

Get resources utilization by Process

Command name: "top" - stands for "Table Of Process."

Copy paste commands and information

On Linux Command Line / Putty, copy-pastes works like this:

  • Copy: just select with the Mouse the portion of text you want to copy from the command prompt
  • Paste: click on the Right button of the Mouse

Example: 
 
The example here, copy and paste of a previously executed “ls -l” command.

  1. Make the selection puts “ ls -l” into the clipboard.
ka02R000000g2hkQAA_0EM44000000QDA8.png

 

  1. Click on the mouse right button to paste.
ka02R000000g2hkQAA_0EM44000000QDAD.png

 

Comment

0 comments

Details

Knowledge Article

Published:

December 28, 2017

Last Updated:

September 16, 2019