SQL Server Analysis Services (SSAS)

Business Intelligent Queries
  • OLAP Queries– Online Analytical process
Architecture Options
  • Data Source -> Integration Service -> Data mart/Data ware House -> Integration Service -> Analysis Service -> Cube Browser/Reporting Services/SharePoint Services
Database Development
  • Design Dimensional Model -> Develop dimensions -> <- Develop cubes -> <- Add Calculations -> <- Deploy to server.
Business Intelligent Development Studio
  • Project Types
    • Analysis Service Project – Develop from scratch
    • Import Analysis Service Database
  • Project Items
    • Data Source
      • Connection & Impersonation information
    • Data Source View
    • Cube – at least one for project
    • Dimension – at least one for project
    • Role – at least one for project
Dimensional Model Development:
  • Data Source
    • Impersonation account must have READ permission on source
  • Top Down vs. Bottom Up Design
    • Top Down
      • Design the cube and dimensions free-form or free template
        • Star Schema Dimension
        • Snow Flake Dimension(Will've child tables down to dimension tables)
      • Generate the schema to build the relational tables
      • Populate the tables using an ETL process
    • Bottom Up
      • Populate the tables using an ETL process
      • Design the Cubes and dimensions based on the table metadata
  • Cube wizard
  • Dimension Designer
    • Dimension Structure & Browser window
    • Hierarchies
      • Provide a navigation path for drilldown from summary to detail data.
      • Improve query performance with more optimal storage.
      • Optionally expose attributes only through user defined hierarchies.
      • Unnatural Hierarchy (Optional)
        • Create a predefined group of attributes
        • Derive no query performance benefits
      • Parent- Child Hierarchy
        • Provide a flexible structure with different number of levels per branch
        • Support data in fact table for non-leaf members
    • Attributes
      • Hey column, Name column, Name, Sort Order, Disable Browsing, Usage.
      • Attribute Relationship    
        • Enhance Query Performance
        • Ensure Correct Totals
        • Facilitate aggregation design
        • Relationship types affect dimension processing( Can use Flexible, Rigid)
    • Unknown Member (Option to set : Visible, Hidden, None, AutomaticNull)
  • Schema Generation Wizard
  • Data Source View
    • Friendly Name for Tables & Columns
    • Named Calculated Column
    • Named Query (Replace Table)



Comments

Post a Comment

Popular posts from this blog

BDD - Acceptance Test Driven Development

Image
Acceptance Test Driven Development What is BDD: BDD is an agile software development technique that encourages collaboration between developers, QA, and non-technical or business participants in a software project. It's more about business specifications than about tests. You write a specification for a story and verify whether the specs work as expected. The main features of BDD development are outlined below:   A testable story (it should be the smallest unit that fits in an iteration) The title should describe an activity The narrative should include a role, a feature, and a benefit The scenario title should say what's different The scenario should be described in terms of Givens, Events, and Outcomes The givens should define all of, and no more than, the required context The event should describe the feature   Advantage of BDD:   The first advantage is that this domain language is usable/understandable by domain experts as well. Given that you e...
Read more

Angular JS – Part 2

Angular Routing Services and Directives: Routing Services: $route - $routeProvider is used to map the URL with template + assigned controller. (specially for SPAs). Methods: when(), otherwise(redirectTo:), current, params, pathParams, reload(). Also we can use resolve() to decide before load template. $routeParams – Used to pass the parameters via URL $location –Use to enable html5 routing. Can get the URL informations Eg. absUrl, protocol, port, host, path, search, hash, url. Replace() method will not keep URL history. Directives: Uses of Directives: Create custom element, custom event, observe and react to changes Use eventApp.dirctive("directiveName",function(){ return {restrict: 'E', template: "<input>"}}); Can restrict the directive to how should use. E(element), C(class), A(attribute), M(comment). Instead of template HTML text, the URL can be used. Use" replace: true" to replace the element name to html i...
Read more

.Net Collections

The  System.Collections namespace contains interfaces and classes that define various collections of objects, such as lists, queues, bit arrays, hash tables and dictionaries. Array list: Implements the IList interface using an array whose size is dynamically increased as required. Dictionary Base: Provides the abstract (MustInherit in Visual Basic) base class for a strongly typed collection of key-and-value pairs. Dictionary is a Generic type. So we can get type safety with Dictionary. Hash table: Represents a collection of key-and-value pairs that are organized based on the hash code of the key. A key cannot be a null reference (Nothing in Visual Basic), but a value can be. Hashtable is not a Generic type. So we can’t get type safety with Hashtable. Hashtable is thread safe. Queue: Represents a first-in, first-out collection of objects. Queues are useful for storing messages in the order they were received for sequential processing. Stack: ...
Read more