SSAS


Comments

Post a Comment

Popular posts from this blog

Data Warehousing Interview Questions and Answers

What is Data Warehousing? Data warehousing is the process of storing and managing data from varied sources to provide meaningful business insights. It involves data integration, cleaning, and transformation to support decision-making processes. What is Business Intelligence (BI)? Business Intelligence (BI) refers to technologies, applications, and practices for the collection, integration, analysis, and presentation of business information. It helps organizations make data-driven decisions. What is a Dimension Table? A dimension table is a table in a data warehouse that stores attributes or dimensions that describe the objects in a fact table. It provides context for measures in the fact table. What is Dimensional Modeling? Dimensional modeling is a design technique for organizing data in a data warehouse. It involves creating dimension tables and fact tables to provide a structure that is optimized for querying and analysis. What is a Fact Table? A fact table is a central table i...
Read more

SSRS--Interview Basic Questions

Image
 1). What is SSRS (Sql Server Reporting Services) ? Ans : Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources.Which allow you to create tabular, matrix, rectangle, sub-report,,charts, Gauge, indicator reports in managed environment. Like a) Development Tool b) Configuration Tool c) Administration Tool d) Report Viewing Tool 2) What is report Manager? Ans:  Report Manager is a Web-based report access and management tool that you use to administer a single report server instance from a remote location over an HTTP connection. You can also use Report Manager for its report viewer and navigation features. You can use Report Manager to perform the following tasks: View, search, print, and subscribe to reports. Create, secure, and maintain the folder hierarchy to organize items on the server. Configure role-based security that determines access to items and operations. Configure rep...
Read more

SQL Server 2012: Multidimensional vs tabular

Image
which model should you use, Multidimensional vs Tabular? Well, there is no clear-cut answer, but there are some factors that can make you choose one over the other: If you want to use DAX, you have to use Tabular If you want to use Power View, you have to use Tabular If your dataset is extremely large, go with Multidimensional If you need writeback support, you have to use Multidimensional If you need access to many different external data sources, choose Tabular If you need complex calculations, scoping, and named sets, choose Multidimensional If you need extreme speed and consistently fast query time, choose Tabular If you need Many-to-Many relationships, choose Multidimensional (can be done in Tabular but difficult) If your solution requires complex modeling, choose Multidimensional If you need any of the following features, you must use Multidimensional: Actions, Custom Assemblies, Custom Rollups, Custom Drillthrough Actions (but BIDS Helper adds support for action...
Read more