Question 1. How Many Types The Microstrategy License Can Be Bought?
Two kinds: – named users or cpu license.
Question 2. What Is A Joint Child?
A joint toddler is Microstrategy way of coping with Composite Keys. Composite keys are made from or more columns which collectively act as specific identifier. To deal with this example in Microstrategy we make this set of columns, constituting composite keys, as joint infant.
Informatica Interview Questions
Question 3. What Are Vldb Properties?
VLDB stands for Very Large Data Base Properties. This is Microstartegy manner of dealing with database unique options while producing the report SQL. There are quantity of them. A few commonplace one are for Attribute or Metric join kinds, cross join test, kind of intermediate desk, and many others.
Question 4. What Is The Command Manager?
MicroStrategy Command Manager helps you to perform numerous administrative and application improvement duties via the use of text instructions that may be saved as scripts. Like for example: – server management, user management, safety, database management.
Question five. What Is An Object Prompt?
An item prompt permits you to select which MicroStrategy objects to consist of in a file, along with attributes, metrics, custom groups and so forth. Object activates can both decide the definition of the file template or the document clear out.
IBM Cognos Interview Questions
Question 6. What Are Logical Views Used For?
Logical Views permits application architects to create any desired view the use of MicroStrategy, with out DBA involvement. Once these Logical perspectives are created, they are to be had to the file dressmaker in a manner much like every other desk. This allows builders to model attributes and data whose expressions span multiple tables.
Question 7. How Will Project Sources Be Configured In Mstr Office?
By modifying the projectsources.Xml, new task resources can be brought.
IBM Cognos Tutorial Teradata Interview Questions
Question eight. Difference Between Standard, Absolute And Ignore Condition In Metrics?
Standard filtering allows the file filter to have an effect on the metric. Absolute filtering raises the document clear out to the extent of the goal, so all subcategories inside the classes covered on the record are delivered collectively. Ignore filtering disregards filtering standards based on the attribute within the target and its related attributes (both parents and kids).
Question 9. Comparison Between Consolidations And Custom Groups?
A custom institution is a fixed of unique filters that may be located on a template. It is made of an ordered series of elements called custom organization elements. Consolidations are used to specify the records you want to view to your file. They let you organization characteristic factors in new methods without changing the metadata and warehouse definitions.
Adv Java Interview Questions
Question 10. How The Reports Are Optimized?
VLDB properties let you customize the SQL that MicroStrategy generates, and determine how statistics is processed by using the Analytical Engine.
Question 11. What Is The Order Of Precedence Of Vldb Properties?
Cloud Computing Interview Questions
Question 12. Difference Between Report Limit And Report Filter?
A file limit specifies a fixed of standards used to limit the records returned within the report statistics set after the file metrics are calculated. Report Filter applies the where condition to the query sent to warehouse to extract the results.
Informatica Interview Questions
Question thirteen. What Is Metric Formula Join Type? How It Is Different With Metric Join Type?
This is largely used for Compound Metrics and determines how the exclusive tables utilized in metric system are joined. Whereas the Metric Join Type determines how the metrics are joined to other metrics.
Adv Java Tutorial
Question 14. What Are Attribute Roles?
A user defines two attributes that have the equal definition but play distinctive roles within the business model. In this situation, characteristic Origin Airport and Destination Airport are described the use of the identical Lookup Table and Column (Airport_ID). Both attributes share the same forms, or facts approximately them (Description, Location, and so forth.). In the truth table, but, a separate column exists for every of their roles (Origin_Airport_ID and Destination_Airport_ID).
Question 15. How Do We Resolve Attribute Roles?
By developing explicit table alias for the equal or enabling the Automatic Attribute Role popularity.
SQL Database Interview Questions
Question sixteen. What Are Statistics Tables And How Do You Configure The Project Statistics?
Statistics tables incorporate records at the MicroStrategy gadget’s usage and performance, and are populated by way of all projects that are configured to log records.
1. Set up the Enterprise Manager.
2. Define the data and agency warehouse database.
Three. Create the information database example
4. Go the project configuration wizard of the mission
five. Select facts and define the what you want to log
Cloud Computing Tutorial
Question 17. Difference Between Project Merge And Object Manager?
1. Object Manager can move only a few objects or just the gadgets in a few folders. Project Merge movements all of the objects in a assignment.
2. Object Manager need to discover the dependents of the copied gadgets after which decide their variations before performing the reproduction operation. Project Merge does not do a dependency search, considering that all of the gadgets within the mission are to be copied.
Three. Project Merge can be run from the command activate in Microsoft Windows.
OBIEE Interview Questions
Question 18. How Conflicts Occur And What The Ways To Resolve Them?
When copying gadgets throughout projects with Object Manager, if an item with the equal ID because the supply object exists anywhere in the destination undertaking, a conflict takes place.There are numerous methods to remedy depending upon the conditions like use current, replace, hold both, use more moderen, use older, update in identical course, replace in new direction and merge privileges.
IBM Cognos Interview Questions
Question 19. What Are Report Caches And How Many Types Are There?
A record cache is a end result set from an accomplished document this is stored on MicroStrategy Intelligence Server. 4 kinds: matching caches, records caches, matching-records caches and xml caches.
SQL Database Tutorial
Question 20. While Establishing Relationship Between Attributes How Do You Decide Which Attribute Qualifies As Child And Which One As Parent?
While organising the relationship between attributes it is easy to either appearance from commercial enterprise hierarchy point of view and the characteristic better within the hierarchy becomes discern of the characteristic lower within the hierarchy. Parent and Child follow a one-to-many relationship. Example Time hierarchy Year > Month > Date. Here Year might be discern of Month and Date and Month discern of Date. We also can identify Parent-Child relationship from database layout factor of view. Here in a desk the Primary Key uniquely identifies the alternative columns in the table and for this reason qualifies as toddler of all of the other attributes from the desk, inside the equal methods as a infant in real international identifies his father (at least the biological one).
Qlik View Interview Questions
Question 21. What Is A Logical Size Of A Table And What Does It Depend On?
Logical size is Microstrategy manner of generating the satisfactory appropriate/optimized SQL to fetch the required data. Microstrategy follows an algorithm to calculate the logical length of a desk, which relies upon at the no of attributes and information primarily based at the desk and additionally the position of those attributes within the gadget hierarchy. The logical size does now not depend on the real facts (no of rows) within the database. If the candidate answers this than his idea is inaccurate
Question 22. What Are Level Metrics? And Why Are They Required?
Level metrics are advanced metrics that are set to be evaluated at a distinct characteristic level. These are required whilst in the equal document you need to roll up a metric at specific degrees side by using side. Example is assessment of “Revenue from a Region” to “Revenue from a Country”. Here Region and Country are the two exceptional tiers.
Question 23. What Is The Difference In The Way Microstrategy Handles Custom Group And Consolidations? Any Advantage Of Using One Over The Other?
Custom Groups are dealt with on the database cease where as Consolidations are treated at the Analytical Engine cease. As a end result the Consolidations are not an overhead for the database as there is a single bypass within the query. On the opposite hand Custom Groups are an overhead at the database as they hearth a separate SQL pass for every Custom organization detail.
Tableau Interview Questions
Question 24. At Which Levels You Can Set The Vldb Properties? Which Level Has The Highest Pecedence?
VLDB Properties may be set at numerous degrees like Report, Template, Metric, Project, Database Instance and DBMS degree. Out of this Report stage has the very best precedence. It overrides all different ranges.
Teradata Interview Questions
Question 25. What Are The Various Ways Of Incorporating Security In Microstrategy?
In Microstrategy protection may be incorporated the use of a mixture of any of the following approaches:
1. Putting person unique regulations on the database quit and the usage of user specific connection mapping. This is for column degree safety.
2. Applying folder and object stage security to restrict access to positive set of stories/gadgets
three. Applying Security filters to the consumer. This presents row level security.
Qlik View Tutorial
Question 26. What Are Pass-thru Functions And Why They Are So Called? Give Some Examples.
Pass-via functions are Microstrategy manner of generating database unique SQL construct which in any other case aren't viable. These are referred to as skip-thru capabilities because Microstrategy does now not take a look at the actual SQL construct and dumps it as is on the database. Example encompass ApplySimple, ApplyComparison, and many others.
Talend Interview Questions
Question 27. Please Write A Query To Get All The Departments, And The Count Of Employee In Those Department, Which Have More Than 50 Employees And Are Based Out Of State New York. Following Are The Table Structures:
Department desk: Department_ID, Department_Name, State (Note: Department ID is Unique here and more than one branch can belong to one State) Employee Table: Employee_ID, Employee_Name, Department_ID (Note: Employee ID is specific right here and a couple of Employee can belong to one department, however one worker does no longer belong to multiple branch)
Following ought to be the query
FROM branch dept JOIN worker emp
ON dept.Department_id = emp.Department_id
WHERE dept.Country = “ny”
GROUP BY dept.Department_id
HAVING Count(emp.Employee_id) > 50
Adv Java Interview Questions
Question 28. What Is The Difference Between Absolute Filtering And Standard Filtering?
When we use absolutely the filtering in definition of stage metric anything facts we obtain from the clear out is goingto be reported as such and the the document clear out might be overridden through the absolute filter settings. The popular filtering the record filter out interacts with the metric filter in the normal way and what we achieve might be formatted in step with the record clear out settings
Question 29. What Types Of Testing Can Be Carried Out Over The Microstrategy Reports?
There are many elements of the report that may be placed into checking out depending upon the kind of report.
Naming convention tests.
Total calculations test.
SQL query validations.
Attribute and metric positions in record.
Drilling options Tests.
Prompts associated verifications.
Security filter out tests.
Formatting/export capability tests.
Threshold trying out
IBM Cognos TM1 Interview Questions
Question 30. What Do You Mean By Trimming Of The Sql Queries?
Trimming of the SQL refers to the easy up and optimizations which can be carried out to the question at the MSTR stage using VLDB settings. The fundamental issue this is finished via the trimming is the elimination of the unwanted cross joins and the other complicated operations
Question 31. How Does The Reporting Varies In The Cognos And The Microstrategy?
The Cognos has the two metadata repository based database, while the microstrategy is based totally on single metadata repository. The Cognos has only a web based reporting device, while the microstrategy can be operated as a webbased and a laptop device. Cognos has a dice dataset which needs to be refreshed to get modern repository values before reporting. The microstrategy has no dice dataset and we get the today's statistics from the information warehouse automatically to be had. The Cognos reporting may be notably slow in overall performance than the microstrategy reporting.
Question 32. What Is Compound And Smart Metrics?
Compound metrics are those which can be derived by a few specific expression related to the specific simple metrics. Eg, Total( earnings/gadgets Sold). Smart metrics is when the compound metric is calculated with the help of subtotal calculations for each element inside the compound metric. For the above example the clever metric computation can be Total(earnings)/Total(Sold).
Data modeling Interview Questions
Question 33. What Are Logical Views? How Are They Useful?
The logical perspectives assist in establishing a specific view primarily based at the combination of facts, attributes and expressions which might be based on values from a couple of tables. This may be done with out the real amendment to the real physical database or the DBA involvement. This way the reporting can be altered at the very best level of application and can be very brief way to changes for reporting.
Cloud Computing Interview Questions
Question 34. How Can You Make The Sql Query To Be Based On A Specific Table Of Your Choice?
The MSTR operates in one of these manner that the incoming queries and information retrievals are completed from the desk which has the least logical size. Thus if we opt for a selected desk to be the center of activity then we should try and lessen the logical length of that precise desk so that it will become drastically lesser than the alternative tables.
Question 35. What Are Report Filters And View Filters?
Report filters: report filters are the conditions that accompany the file producing SQL statements. The document definitions have the filters as a part of their definition.
View Filters: View Filters are the situations that come into play earlier than a specific result is provided to the user. Thus the view filters aren't part of the SQL statements like report definitions, rather they may be the filters applied after the execution of the SQL statements, after the statistics is retrieved from the statistics warehouse.
Question 36. Why Is It Required To Maintain A Parent-baby Relationship Among The Various Attributes? What Are The Various Types Of Relationships Depending On The Number Of Participants?
The figure-infant dating allows in organising the hierarchical structure to the complete good judgment and commercial enterprise version. For instance, you could have the sector to be a baby of a selected 12 months characteristic. This will assist us in having a modularized method inside the layout and will help in setting up common utilization semantics. The numerous varieties of relationships can be one to at least one, many to at least one, many to many, one to many relationships.
SQL Database Interview Questions
Question 37. How Is The Number Of Passes In A Sql Query Significant In Performance Evaluation?
The range of passes represents the quantity of times the SQL question has to be parsed and distinct parts of the query is dealt with for each skip. The fewer passes we've the more efficient the query executes and faster the reports are generated.
Question 38. What Are Consolidations And Custom Groups?
The custom agencies are the made from what are known as as custom organization elements and collectively they act as a special clear out that can be carried out over a specific template. Consolidations consult with the way in which you organization or order the facts for your file. The different attributes may be amassed together without converting the underlying metadata and ware housing shape
Question 39. How Can You Specify The Report Template And A Report Filter? How Are Reports Optimized?
The gadgets maps are those which are used to pick the organization of microstrategy objects which might be used to generate the document. This can serve as the template or filter. Then optimizations to the diverse reviews may be completed by using evaluation of the VLDB properties and the customizations may be monitored by the processing direction taken up with the aid of the Anlytical engine
Question forty. What Are Attribute Roles? How Can You Resolve The Attribute Roles?
The attributes that are single in definition but the times of the attribute can behave otherwise in keeping with the function they take. Example for this may be a database of airports round the world. The attribute of airport call is continually based on the identical database desk however may be visible as a destination airport or source airport. Such roles are resolved via having aliases for the identical desk, one alias for destination and one for supply airports. We also can allow the automated attribute function reputation by means of configuring it nicely.
OBIEE Interview Questions
Question 41. What Is The Command Manager Used For?
The command manger is the only thru which you could manage the packages, consumer accesses, security and databases of the microstrategy. The command supervisor lets in us to shop the text commands that may be executed as scripts. Thus it could assist in automation of the whole control manner.
Question forty two. How Is Object Manager Oriented Copy Operation Different From The Project Merge?
The object supervisor is the only that copies companies of objects with all the attributes which might be associated with it. The mission merge is used for copying the whole mission along with all the items. This is why it does no longer have to check for the attribute constraints earlier than copying. The Object supervisor but has to ensure of the object characteristic suits earlier than copying the items. The item manager can't be run from the command activate directly at the same time as the project merge may be run immediately
Qlik View Interview Questions
Question 43. What Are Level Metrics? Why Are They Needed?
The stage metrics are the metric calculation which might be executed over the precise attribute however on the one of a kind stages or dimensions. For example, the number of gadgets offered is an characteristic that we keep a assume. That metric may be calculated across time and area. Say quantity of devices sold in final month and the number of devices sold in particular place of the u . S . A .. Here the vicinity and time are one-of-a-kind degrees. Such level primarily based metric deliver analytical inference as to the overall performance of the organisation etc.
Question 44. Explain The Use Of Pass-through Functions.
The skip-through capabilities are the particular database oriented SQL statements and constructs which are performed via the microstrategy with out checking semantics of the actual construct. They are called bypass-via as they're now not checked for correctness through the microstrategy as such. ApplySimple, Applycomparison are two bypass thru features that microstrategy typically applies.
Question forty five. How Can You Impose Security Measures Into The Microstrategy.
Column degree safety set up by the enforcing consumer particular get right of entry to permissions in the database and having consumer precise connections.
Entire set of gadgets may be secured by way of enforcing folder and item stage protection.
Row stage safety is imposed by means of having consumer unique protection filters for numerous records.
Question 46. What Are The Vldb Properties? Which Level Of Vldb Configurations Have The Highest Precedence?
The Very Large Data Base residences is the configuration set that manages the general way wherein the database behaves and generates reviews. There are many such settings like take a look at for cross joins, intermediate desk creation and kind and so forth. The VLDB houses can be set at many exceptional level like metric level, attribute level, Database Instance stage, challenge level or the DBMS stage. The maximum precedence is given to the report degree of configurations.
Question 47. What Is Microstrategy Desktop?
Microstrategy Desktop™ is a Windows purchaser-server software program utility that offers incorporated tracking, reporting, and analysis capabilities.
Question 48. What Does Microstrategy Desktop Allow Users To Do?
Using Microstrategy Desktop, customers can without difficulty get right of entry to and proportion important corporate records they want to make value-reducing selections and improve enterprise strategies. The statistics determined in databases also can be used to help boom sales and boost profits. Users can access this database and SAP facts without having to research technical database question (SQL) or multi-dimensional expression (MDX) syntax.
Question 49. What Can Users Do With The Information They Access Using Microstrategy Desktop?
Users can analyze the statistics the use of popular aggregations and extra sophisticated features including common, summation, percentage contribution, standard deviation and internet gift value. Investigative reporting, using pivoting, sorting, slicing, and drilling to greater detail, may be achieved with simple mouse clicks. Users also can layout reports to their specifications and consider the data as intuitive charts and graphs to discover trends and anomalies quick
Question 50. What Are The Benefits Of Using Microstrategy Desktop?
Users can acquire important statistics right away without waiting for IT departments to create reports. The software is simple to use and presents context touchy help, hence getting rid of the need for considerable help and maintenance staff
Question fifty one. Are The Reports Created Using Microstrategy Desktop Available To Other Products Such As Microstrategy Web?
Yes. Reports created using Microstrategy Desktop are right now available to different Microstrategy merchandise due to our centralized metadata structure
Question 52. Can Microstrategy Desktop Access Sap Data?
Yes. With the discharge of Microstrategy eight, Microstrategy Desktop contains a new dynamic facts get admission to engine designed to get right of entry to multi-dimensional databases (MDDBs or OLAP Cube Databases) which include those from SAP Business Information Warehouse (BW) databases
Question fifty three. Can Microstrategy Desktop Access Operational Data Systems?
Yes. Microstrategy Desktop customers can use a brand new Operational SQL Engine to encompass records from any operational system using completely loose-form SQL, which includes saved processes and views
Question fifty four. How Fast Is The Performance On Microstrategy Desktop?
Microstrategy Desktop affords instant get admission to and evaluation of records. This excessive performance is enabled thru Intelligence Cubes™, caches, incremental fetches and advanced analytic capabilities.
Question fifty five. How Long Does It Take To Learn Microstrategy Desktop?
Microstrategy Desktop preserves the appearance and experience of popular computer software together with Microsoft® Windows® Explorer and Microsoft Office. As such, customers are without delay comfy with Microstrategy Desktop. A custom designed interface the usage of HTML can be created, simplifying navigation and report execution.
Question 56. Can I Make My Data And Graphs Look Professional?
Yes. Users can layout their records into attractive reviews using numerous formatting styles and graphs for optimum visual effect. Users can select from more than 30 distinct charting alternatives to present facts inside the quality layout feasible.
Question 57. Is It Possible To Display Multiple Reports, Images And Information On The Same Page?
Yes, users can effortlessly combine tables, pics, graphs and other statistics onto the identical page in a file. Visually mind-blowing and compelling files may be printed out and shared with corporate executives. Business customers can now rearrange the enterprise of any record with simple drag and drop moves or via clicking on the brand new toolbar icons to get completely new views of the facts, all from the identical report and without requiring assistance from IT.
Question fifty eight. What Printing Capabilities Are Available In Microstrategy Desktop?
Microstrategy Desktop offers superior printing competencies. Features encompass repeating row/column headers, customizable headers and footers, and a complete page setup menu. Users can preview reports earlier than sending it to the printer
Question 59. What Subtotaling Features Does Microstrategy Desktop Contain?
Microstrategy Desktop has more than 10 unique subtotaling features that resource analysis of the records. Subtotals can be supplied at any stage inside the rows, columns and pages on the report.
Question 60. What Are The Minimum Requirements For Microstrategy Desktop?
Minimum requirements are a pc with at least a 450MHZ Pentium- compatible CPU, 256MB of RAM and 500MB of hard disk
Question sixty one. Is Microstrategy Desktop Available In Other Languages?
Microstrategy Desktop is available in English, French, German, Spanish, Korean, Italian, Swedish, Japanese and Portuguese.
Question sixty two. How Long Does It Take To Get Microstrategy Desktop Up And Running?
Microstrategy Desktop installs in mins and mechanically affords a listing of available Microstrategy Intelligence Servers. Within an hour, the installation and setup are finished
Question sixty three. How Does Microstrategy Desktop Integrate With The Rest Of The Microstrategy Platform?
Microstrategy Desktop is the intuitive client-server interface utilized by business analysts and alertness builders. Microstrategy Desktop interacts with the Intelligence Server to build metrics, create and layout reports, and retrieve timely, correct facts to the laptop to beautify the selection-making method
Question 64. What Security Is Provided With Microstrategy Desktop?
Microstrategy Desktop gives a bunch of protection options to ensure that statistics is saved exclusive and private. To facilitate clean deployment and minimal protection, Microstrategy Desktop integrates with Windows NT and 2000 security and with Novell listing. As a result, users who have logged into those systems will not need to go online once more.
Question sixty five. To What Extend Can Microstrategy Desktop Be Personalized?
Each Microstrategy Desktop consumer has a security profile defined through their administrator. This profile controls get admission to to software functionality, specific reports or precise statistics for man or woman users or organizations of users. The Desktop interface will adapt and display handiest what this consumer is allowed to peer.
Question sixty six. Is The Microstrategy Mdx Engine Certified By Sap?
Yes. This new Dynamic MDX Engine generates optimized MDX syntax that is fully licensed with SAP BW using SAP's excessive performance BAPI interfaces.
Question 67. Can Users Join Data Across Sap Bw Info Cubes And Query Cubes?
Yes. Users can use Microstrategy Desktop to create reviews that get admission to SAP records and be part of facts across SAP BW Info Cubes and Query Cubes as well as get admission to multiple instances of SAP BW right now.
Question sixty eight. Can Microstrategy Desktop Join Data Across Heterogeneous Data Sources?
Yes. Microstrategy eight extends the Microstrategy statistics modeling flexibility to consist of incorporated perspectives of facts throughout heterogeneous information stores. By mapping conforming dimensions from special sources, Microstrategy Desktop can routinely join data from multiple special assets in the identical document document. Data can come from any source handy by way of Microstrategy 8, such as the statistics warehouse, information marts, SAP BW, and any quantity of operational gadget databases
Question 69. Does Microstrategy Provide Predictive Modeling Capabilities Commonly Available In Data Mining Tools?
Yes. Microstrategy eight can calculate 4 of the primary facts mining functions consisting of neural network algorithms, clustering algorithms, regression algorithms, and tree algorithms
Question 70. Can Microstrategy Incorporate Best-of-breed Data Mining Insight Into Mainstream Business Reports And Analysis?
Yes. Microstrategy eight has extended its analytic engine with "Data Mining Services" functionality that allows reports and evaluation to encompass predictive capabilities in each Microstrategy report or analysis. Microstrategy 8 consists of the new ability to import information mining models immediately from quality-of-breed statistics mining products from providers like IBM, Teradata, SAS, and SPSS the usage of the new PMML or predictive modeling mark-up language general
Question seventy one. Can Microstrategy Desktop Export Data To Other Software Applications?
You can export facts from Microstrategy Desktop to textual content files, Microsoft Word, Microsoft Excel, Microsoft Access and HTML files. The formatting of the tables and information are preserved while you export to those file formats
Question 72. What Data Sources Does Microstrategy Desktop Support?
You can get right of entry to records in all of the foremost databases consisting of Oracle, IBM DB2, Informix, NCR Teradata, Microsoft Access, Microsoft SQL Server, Red Brick, Sybase and Non-Stop SQL
Question 73. To Save Time, Can Many Reports Be Run At The Same Time?
Microstrategy Desktop can execute multiple reviews concurrently. Report outcomes are saved in a personal History folder while geared up
Question 74. Can Reports Be Executed In Off-height Periods?
Reports may be connected to time-primarily based or event-based totally schedules which might be defined with the aid of the administrator. These schedules mechanically cause the report execution and place a notification message inside the History folder on of completion.
Question 75. What Is Microstrategy Olap Services?
Microstrategy OLAP Services is an extension to Microstrategy Intelligence Server that permits Microstrategy Web and Desktop users to control Intelligent Cubes™. With OLAP Services quit customers can add or remove report items, upload derived metrics and adjust the filter -- all with velocity-of-thought response time against Intelligent Cubes. OLAP Services enables full multi-dimensional OLAP analysis inside Intelligent Cubes, even as keeping customers' ability to seamlessly drill thru to the entire breadth and intensity of the statistics warehouse
Question 76. What Are The Intelligent Cubes Used By Olap Services?
Intelligent Cubes are user or administrator created multi-dimensional cubes that perform inside Microstrategy Intelligence Server™. On Microstrategy's BI platform, growing an Intelligent Cube is as clean as developing a record. Intelligent Cubes allow Microstrategy to combine the velocity and interactivity of multi-dimensional OLAP evaluation and the analytical energy and depth of relational OLAP.
Question seventy seven. What Specific Features And Functionality Do I Get With Olap Services?
With OLAP Services Microstrategy Web, Desktop and Office users can:
Create unique record views based totally off an Intelligent Cube. With OLAP Services, customers can create precise report perspectives via including or putting off attributes and metrics contained in the Intelligent Cube. This permits speed-of-notion document introduction and amendment with out a want to extract information from the statistics warehouse.
Create new on-the-fly metric calculations from present metrics in an Intelligent Cube. The new calculation is achieved without submitting a new request to the records warehouse.
Filter their view of the facts within an Intelligent Cube. The filtering will be carried out on Microstrategy Intelligence Server inside the Intelligent Cube.
Question seventy eight. How Are Intelligent Cubes Different From Ordinary Cubes?
Intelligent Cubes are created automatically whilst a brand new record is administered against the facts warehouse. Subsequent requests by way of different users can seamlessly hit this new Intelligent Cube. The logic to healthy person requests with the suitable Intelligent Cube is automatically treated within the Microstrategy platform. Users don't ought to specify the cube to which they want to attach. Benefits of Intelligent Cubes include:
Greater Efficiency - Intelligent Cubes are automatically generated and shared among all customers each time a document is achieved through a person or pre-cached via the administrator or a person.
Easy to Use - Intelligent Cubes may be designed through mainstream BI users, using the identical interface and the identical operations as are used with simple OLAP evaluation.
More Scalable Cubes - Intelligent Cubes do now not need big pre-calculations or pre-aggregations. The mid-tier Intelligence Server can do these calculations on-the-fly as the cubes are getting used.
Increased Manageability and Reliability - Intelligent Cubes can be configured to run out or refresh mechanically whenever underlying information or definitions alternate.
Increased Power for End-Users - Users can seamlessly drill via to the whole intensity of the data warehouse, or slice and cube with speed-of-idea reaction time within the Intelligent Cube.
Question seventy nine. What End User Products Leverage Olap Services?
Microstrategy Web (Analyst and Professional versions), Microstrategy Desktop (Analyst and Designer versions) and Microstrategy Office all leverage the functionality enabled via OLAP Services
Question eighty. What Does An End-consumer Need To Do To Take Advantage Of This?
The usage of OLAP Services is transparent to quit-customers. Users do no longer need to realize the name and place of an Intelligent Cube, or maybe if it exists. OLAP Services works with Microstrategy Intelligence Server to mechanically use the precise Intelligent Cube or create a new one to satisfy the quit user request
Question eighty one. How Is Security Handled?
Intelligent Cubes used by OLAP Services routinely inherit all of the protection provisions of each document object used inside the Intelligent Cube, and those provisions are dynamically carried out to each user's safety profile while the cube is accessed. If a user simplest has privileges to use four of the five metrics contained in an Intelligent Cube, that restriction will routinely and seamlessly practice when the user accesses the Intelligent Cube. The person will nonetheless have get entry to to the Intelligent Cube for the four metrics he or she has privileges to use
Question 82. Can I Access Intelligent Cubes Without Olap Services?
Yes, with the proper model of Microstrategy Web or Desktop, sure capabilities leverage the Intelligent Cubes. These features encompass: file formatting down to mobile stage, column aliasing, drilling, pivoting, web page-by using, including metric thresholds, adding subtotals, ranking and sorting. Please see the Web and Desktop version comparisons to decide precisely which Web or Desktop model consists of the desired functionality.
Question eighty three. Is Olap Services Sold As A Separate Product?
Yes, OLAP Services is sold as a separate product that is hooked up with Microstrategy Intelligence Server. It is certified either on a in step with-person or in step with-CPU foundation.
Question eighty four. What Is Microstrategy Narrowcast Server?
Microstrategy Narrowcast Server is a software product that video display units and gives you individualized facts to customers through e-mail, web portals, and wireless gadgets consisting of PDAs, pagers, and telephones. Through a clean-to-use internet web page, users specify what data they want, when and how they want to obtain it.
Question eighty five. What Are The Business Benefits Of Microstrategy Narrowcast Server?
Microstrategy Narrowcast Server affords an clean and inexpensive manner to ship corporate records to untrained personnel, partners, and clients. As a result, decision-makers have the records they need to maximise sales technology and streamline business procedures that reduce working costs
Question 86. What Kinds Of Applications Can Microstrategy Narrowcast Server Support?
Microstrategy Narrowcast Server helps: company reporting packages, govt facts portals, corporate records dissemination, sale pressure automation, working capital control, deliver chain management, extranet portals, comfy commercial enterprise to commercial enterprise portals, customer service programs, and intelligent alerting applications
Question 87. Why Do Businesses Need To Send Information Out To Users Proactively?
People do now not have time to search thru statistics to discover information that requires on the spot movement. An clever alerting device is familiar with and continuously video display units the facts customers want, and grants information best whilst customers need it. Users store time and take movement whilst required
Question 88. How Do Current Microstrategy Narrowcast Server Customers Use Intelligent Alerting?
Customers use Microstrategy Narrowcast Server to supply stock indicators, commercial enterprise performance alerts, deliver chain alerts, purchaser activity alerts, stock and personal finance signals, final minute tour alerts, statistics load signals, client account activity signals, and fraud signals. New makes use of are constantly being evolved for sensible alerting
Question 89. How Do Users Receive Only Information That They Want?
Through an clean-to-use subscription net page, users specify what facts they need. Some personalization alternatives encompass the language selections and particular statistics criteria inclusive of sure products. Using this person profile, Microstrategy Narrowcast Server sends handiest the data that the consumer has asked.
Question ninety. Can Users Turn Off The Information Delivery?
Yes, users can switch on and rancid their personal information transport. Administrators also can set up some ‘non-non-compulsory’ facts transport so that everyone gets the information. As a end result, customers can obtain statistics without having to watch for IT to develop the reports.
Question 91. What Kinds Of Information Can Users Receive?
Users can acquire both tables and charts from the Microstrategy platform, and content material from modern-day records resources together with transaction processing structures, Enterprise Resource Planning structures, databases, XML files, and internet servers
Question ninety two. What Formatting Can Be Applied To The Information That Is Sent Out By Microstrategy Narrowcast Server?
Information may be formatted into HTML, plain textual content, Microsoft® Excel, or PDF documents. The length and show of those files are adjusted to fit the email kind or the wireless device for special users.
Question 93. To Which Devices Can Microstrategy Narrowcast Server Deliver Information?
Narrowcast Server can supply data to e-mail, cell phones, pagers, faxes, PDAs, intranet and extranet web portals. Businesses can also build and plug of their very own Information Transmission Module to support their own devices.
Question ninety four. How Does The Microstrategy Narrowcast Server Support Enterprise Wide Mission Critical Applications?
Microstrategy Narrowcast Server's world-class clustering and fail-over ensures help for venture-essential 24x7 systems. Rigorous in-residence trying out has tested that Narrowcast Server can personalize and deliver millions of messages an afternoon. The device tracks fail-over right down to each message.
Question 95. Are There Any Special Requirements Needed To Move Objects Across Projects?
Yes. In order to carry out go-mission operations, the tasks worried need to originate from the same supply venture. In different phrases, the projects can most effective be related by using the duplication of a unmarried assignment. This ensures that the projects have a comparable set of schema and alertness objects, and that the item ID's inside the two tasks are the equal. MicroStrategy Object Manager makes use of the item and model ID's throughout the tasks to carry out comparisons.MicroStrategy Object Manager prevents the user from attempting operations throughout unrelated projects.
Question ninety six. How Does Microstrategy Object Manager Determine If Two Projects Are Related?
MicroStrategy Object Manager compares the Schema ID's of the 2 projects. Duplicated tasks have unique Project ID's, however their Schema ID's are the identical.
Question 97. What Is The Conflict Resolution Window?
The Conflict Resolution window affords the person with a means to determine how to cope with object conflicts among the supply project and the destination task. In addition, the Conflict Resolution window shows the item call in the original venture, the object call in the destination project and the type of warfare. Users might also specify a brand new call for the object relying on the movement chosen
Question 98. How Does Microstrategy Object Manager Determine If Two Objects In Different Projects Are The Same?
To determine if two objects are the same, MicroStrategy Object Manager compares their Object ID's. If those ID's are the identical, MicroStrategy Object Manager then compares the Version ID's. If the Version ID's are the identical, the Conflict Resolution grid lists the warfare as 'Exists Identically.' If the Version ID's are special, the Conflict Resolution grid lists the battle as 'Exists Differently.
Question 99. How Can The User Determine The Object Id Of An Object?
To view the Object ID of an object, proper-mouse click on the object and pick 'Properties.' The Object ID and Version ID are listed on the 'General' tab.
Question a hundred. Why Does Microstrategy Object Manager Search For Object Dependencies?
MicroStrategy Object Manager makes a list of all object dependencies before copying an object to prevent metadata inconsistency. The time required for dependency checking varies primarily based on a customer's metadata size and schema complexity. For huge metadata and complicated schemas, amassing all the dependencies may additionally take a long time.
Question a hundred and one. Can Schema Objects Be Copied Across Projects With Microstrategy Object Manager?
Yes, schema objects may be copied across initiatives the use of MicroStrategy Object Manager. MicroStrategy Object Manager moves objects seamlessly among similar projects such as from a development undertaking version to a production assignment version in which the warehouses are the equal in terms of perspectives, prefixes, and warehouse shape. However, subtle modifications within the warehouse that relate to prefixes, perspectives, or table shape can't be tracked by means of MicroStrategy Object Manager. For conditions where the tasks' warehouse structures or setups are dissimilar, customers may be required to make similarly edits of the gadgets to make certain complete integration into the vacation spot assignment. These edits may additionally encompass hierarchical relationship changes or adjustments to the prefixes.
Question 102. How Does Microstrategy Object Manager Integrate With The Microstrategy Product Suite Security Model?
Security in MicroStrategy Object Manager is based on the MicroStrategy 7.X Product Suite protection version. All activities that can be performed in MicroStrategy Object Manager are governed by way of privileges and get right of entry to control lists. For instance, if a person is not allowed to get right of entry to a positive folder in MicroStrategy Agent, they will no longer be capable of access the folder in MicroStrategy Object Manager.
Question 103. Is It Possible To Use Microstrategy Object Manager While Other Users Are Making Changes In Microstrategy Agent?
Using MicroStrategy Object Manager to duplicate/move objects round is not encouraged while different person sessions are making changes the use of MicroStrategy Agent, as it can result in metadata inconsistency. Project and schema locking save you multiple customers classes from manipulating the schema at the same time. This prevents metadata inconsistency from taking place.
Question 104. What Are The Tracing Options Available In Microstrategy Object Manager?
Tracing is to be had under the Tools/Diagnostics menu. These tracing alternatives practice to every MicroStrategy product established at the machine.To see the SQL that has been executed in opposition to the metadata, go to the Advanced tab and activate 'SQL Tracing' beneath the DSS MDServer key.Function level tracing can be achieved by way of going to the Advanced tab and turning on 'Function Level Tracing' underneath the DSS ObjectManager key.
Question a hundred and five. Where Are Dependent Objects Copied If They Do Not Already Exist In The Destination Project?
If the vicinity exists in the vacation spot venture, the structured item is copied to that place. If the area does no longer exist in the vacation spot venture, a new folder entitled 'Dependencies' is created and the object is copied to that folder
Question 106. What Happens If The Owner Of An Object Does Not Exist In The Destination Project?
If the proprietor of the supply object does no longer exist in the vacation spot project, the consumer login for the vacation spot venture takes ownership of the object while it's far copied or replaced.
Question 107. Where Can Users Find More Information On Microstrategy Object Manager?
Further statistics can be determined in the launch notes, in addition to in MicroStrategy Object Manager's on line assist
Question 108. Does Microstrategy Web Support Clustering Via Cisco Local Router Or Any Other Third-celebration Clustering Software?
MicroStrategy Web relies on 0.33-birthday celebration net-clustering software to provide clustering functionality. MicroStrategy Web is designed to be stateless so that every individual MicroStrategy Web node can feature without the expertise of the life of other nodes. Therefore, any 0.33-birthday party software used to cluster web servers can be used.
Question 109. What Information Is Shared By The Application Across Microstrategy Web Nodes?
MicroStrategy Web is designed to be as stateless as feasible. Therefore, no facts is shared by using the MicroStrategy Web utility across cluster nodes. All nation data for running jobs is pushed to the purchaser browser.When a report is submitted through a MicroStrategy Web consumer, the consumer will receive a wait page in the patron browser. This wait web page will poll the MicroStrategy Web Server periodically for the reputation of the record. This polling is executed as new http requests. This http request will incorporate all kingdom facts, along with encrypted login data and MicroStrategy Intelligence Server connection statistics.
Question a hundred and ten. Is Microstrategy Web "cluster-aware"?
The MicroStrategy Web software is designed so that each MicroStrategy Web cluster node does no longer need to understand that it's miles a member of a cluster. MicroStrategy Web is designed to be stateless, in order that every client http request may be processed in my opinion while not having to persist facts in the MicroStrategy Web software. Therefore, third-celebration Web-server clustering software can be used to cluster together a couple of net servers running MicroStrategy Web.
Question 111. Should Microstrategy Web Be Specifically Configured To Access A Microstrategy Intelligence Server Cluster?
No. When the administrator configures MicroStrategy Web to get entry to a selected MicroStrategy Intelligence Server, the MicroStrategy Web utility will mechanically discover that the MicroStrategy Intelligence Server is a member of a cluster. Once this detection is made, MicroStrategy Web will automatically add all the other individuals of the same cluster into the pool of to be had MicroStrategy Intelligence Servers.
Question 112. What Information Is Shared By The Application Across Microstrategy Intelligence Server Nodes?
Report caches are shared in a cluster and Object caches on every MicroStrategy Intelligence Server node are synchronized
Question 113. Is A Copy Of Each Report Cache Retained In Each Microstrategy Intelligence Server Node?
No. Each MicroStrategy Intelligence Server keeps a research desk with data about the lifestyles and location of document caches. When a cluster node creates a report cache, information approximately the location of the brand new cache is shared with the opposite cluster nodes. Each cluster node then updates its personal lookup table with the region of the brand new cache.
Question 114. If A Microstrategy Intelligence Server Node Crashes, Will Report Caches Be Lost?
Although report caches will no longer be misplaced, get entry to to document caches can be affected, relying on the manner wherein the file cache is configured.If a separate document server is used as a common document cache repository for all MicroStrategy Intelligence Server cluster nodes, then the lack of a cluster node will not have an effect on get admission to to the file cache through other nodes.If the cluster is configured such that every node locally hosts the record cache created by using that node, then those file caches residing within the lost node will certainly be inaccessible. If any report cached in that lost node is requested, then some other node inside the cluster will re-run and re-cache the file. When the cluster node is recovered and rejoined into the cluster, all report caches in that cluster node can be made to be had again to the relaxation of the cluster.
Question 115. If A Microstrategy Intelligence Server Node Is Removed From A Cluster Manually, Will Report Caches Be Lost?
If an administrator gets rid of a cluster node from a cluster, then all record caches that were created by using that cluster node can be inaccessible via the relaxation of the cluster, whether or not or no longer a separate report server is used as a