-
From my last continuing post on MSBI # 5– SSAS # 1- What is SSAS ? – (SQL Server Analysis Services) - Vishal Pawar's Blog in Beyond Relational Now lets start digging into Development surface for SSIS After opening BIDS project as mentioned in following link BISQL#2:How To Create Solution...
-
As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to filter the objects in the object explorer. Suppose you have many tables in the database...
-
SSAS Is stands for SQL Server Analysis Services Its is Analytical tool from Microsoft in BIDS Design Scalable Solution with SSAS •Productivity Enhancing Designers – Optimized design experience – Best Practice Design Alerts – Dedicated aggregation designers – Enhanced UBO •Scalable Infrastructure – Heterogeneous...
-
SSRS Stands for SQL Server Reporting Services Future of SSRS SSRS is Reporting Tool From MS for really ease of Developing any type of report It provides a unified, server-based, extensible, and scalable platform from which to deliver and present information. Its scope extends from traditional paper reports...
-
SSIS is stands for SQL Server Integration Services According to me SSIS is basic block of building any MS BI application which should be have three P’s-Pure,Perfect,Painless. It is ETL-(Extract,Transform and Load )Tool form Microsoft based on SQL and Own existing platform. ETL is the process in...
-
In my previous post regarding indexes I presented a method of inspecting all indexes in a database using sys.dm_db_index_physical_stats. Let us develop it a little bit more. Suppose you want to loop through all indexes and rebuild those which fragmentation exceeds 30 percent, and reorganize those which...
-
As you know I have started a new series on " Exploring SSMS " by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to Connect to msdn forums or submit your feedback to connect item Connecting to msdn...
-
As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to change the value of the option SELECT Top N rows Sometimes you may need to view...
-
SSAS has two major functions: a high-performance cubing technology, and a data-mining technology
-
Here are the steps you can take to create an SSAS database using BIDS. Create an SSAS project in BIDS. Create a data source (DS) that connects to your data warehouse in star schema. Create a data source view (DSV) to act as a layer between your data source and the data warehouse and to protect you from...
-
A data warehouse is made of fact and dimension tables. Fact tables: hold measures, which are the numeric columns that you want to put on the report. Dimension tables: hold the columns in which you want to filter the data. SSAS adopts many of the same items but has changed their names. Measure: individual...
-
Assuming that now we’ve loaded our data warehouse. The rest of my notes are all about SSAS. SSAS is a service that can pre-aggregate data and make it faster to query data. According to the workshop presenter, it took only 2 seconds to query a 24 terabytes data (in grocery industry) Reduce report...
-
This is my second notes on fact table modeling. They are tips to improve performance and scalability. Fact tables are often designed to be index light , meaning that indexes should be placed only to support reporting and cube processing. Fact tables are often much larger in row count and data volume...
-
Finally here is my notes about fact table modeling. A fact table is the center of the star schema It contains two primary types of data: Key columns and Data columns. Fact table holds the keys to relate the needed dimension tables Many OLAP tools, such as Analysis Services, look for star schema model...
-
This is my last notes on dimension modeling. Avoid unnecessary normalizing. In a star schema, the practice of normalizing is called snowflaking. This is usually unnecessary, unless your dimension tables is so large it needs to be physically separated on the storage array. CamelCasing, the capitalization...