Question Which of the following issues can result from many-to-many relationships? A. Exclusion of some attribute elements when drilling B. Multiple join paths to fact tables C. Missing values on reports including all attributes from the hierarchy D. Multiple counting when aggregating data from base fact tables E. Lost analytical capability Answer Both D. Multiple counting […]

Introduction Starting with MicroStrategy Analytics Enterprise 9.4.1, Report Services documents can contain grids with objects coming from more than one dataset. Multiple Datasets in a Single Grid/Graph/Widget Object in MicroStrategy Web 9.4 [2] Users now have the ability to add attributes and/or metrics from multiple datasets to a single grid, graph, or widget. For example, if Dataset #1 […]

Very Large DataBase VLDB is an acronym for Very Large DataBase. VLDB properties enable MicroStrategy products to take advantage of the unique optimizations that different databases offer. There are over 100 settings that affect how the MicroStrategy Engine handles functions such as: Join options (star join, full outer join, and so forth) Metric calculation options […]

Futurist Nikola Tesla, seen here at age 34 in 1890, is the inventor of the Tesla coil and alternating current machinery. Photo courtesy Wikimedia Commons. In honor of inventor Nikola Tesla‘s 157th birthday, we’ve turned to two Tesla experts and historians to help us compile a list of interesting facts you probably never knew about […]

Andy Cotgreave Andy Cotgreave is Tableau Software’s senior data analyst in the UK. With 16+ years experience battling with good and bad Business Intelligence (BI) tools, Andy has held positions in data analysis, business research and software development. Prior to Tableau, he was a senior data analyst at the University of Oxford. He has also […]

The Kraken One of the great sea monsters of Norse myth and legend is the Kraken, said to be able to overturn ships and drag them down into the cold depths. There seems to be a degree of confusion with the Midgard Serpent, because some legends say there are only two Kraken in existence, and […]