Sanju-Blogs

Organizations need to drive actionable insights to people across the enterprise. Rely on one of the most widely used multidimensional analysis tools to build comprehensive, enterprise-scale analytic solutions that reach every user through familiar applications. SQL Server Analysis Services (SSAS) provides Rely on feature-rich, powerful, and easy-to-use online analytic processing (OLAP) and data-mining capabilities. Scale analytical solutions to meet enterprise needs. Enhance productivity with design aids and best practices. Drive actionable insight with help from familiar tools. Consolidate enterprise analysis data and KPIs. Before getting in to SSAS, let us get few Terminologies understand. Cube The basic unit of storage and analysis in Analysis Services is the cube. A cube is a collection of data that’s been aggregated to allow queries to return data quickly. It is a set of related Measures (Fact) and Dimensions that is used to analyze data Dimension A Dimension is a group of attr...

Multithreading is managed internally by a thread scheduler, a function the CLR typically delegates to the operating system. A thread scheduler ensures all active threads are allocated appropriate execution time, and that threads that are waiting or blocked (for instance, on an exclusive lock or on user input) do not consume CPU time. On a single-processor computer, a thread scheduler performs time-slicing — rapidly switching execution between each of the active threads. Under Windows, a time-slice is typically in the tens-of-milliseconds region — much larger than the CPU overhead in actually switching context between one thread and another (which is typically in the few-microseconds region). On a multi-processor computer, multithreading is implemented with a mixture of time-slicing and genuine concurrency, where different threads run code simultaneously on different CPUs. It’s almost certain there will still be some time-slicing, because of the operating system’s need to service its o...