Logo

Navigation
  • Home
  • Services
    • ERP Solutions
    • Implementation Solutions
    • Support and Maintenance Solutions
    • Custom Solutions
    • Upgrade Solutions
    • Training and Mentoring
    • Web Solutions
    • Production Support
    • Architecture Designing
    • Independent Validation and Testing Services
    • Infrastructure Management
  • Expertise
    • Microsoft Development Expertise
    • Mobile Development
    • SQL Server Database and BI
    • SAP BI, SAP Hana, SAP BO
    • Oracle and BI
    • Oracle RAC
  • Technical Training
    • Learn Data Management
      • Business Intelligence
      • Data Mining
      • Data Modeling
      • Data Warehousing
      • Disaster Recovery
    • Learn Concepts
      • Application Development
      • Client Server
      • Cloud Computing Tutorials
      • Cluster Computing
      • CRM Tutorial
      • EDI Tutorials
      • ERP Tutorials
      • NLP
      • OOPS
      • Concepts
      • SOA Tutorial
      • Supply Chain
      • Technology Trends
      • UML
      • Virtualization
      • Web 2.0
    • Learn Java
      • JavaScript Tutorial
      • JSP Tutorials
      • J2EE
    • Learn Microsoft
      • MSAS
      • ASP.NET
      • ASP.NET 2.0
      • C Sharp
      • MS Project Training
      • Silverlight
      • SQL Server 2005
      • VB.NET 2005
    • Learn Networking
      • Networking
      • Wireless
    • Learn Oracle
      • Oracle 10g
      • PL/SQL
      • Oracle 11g Tutorials
      • Oracle 9i
      • Oracle Apps
    • Learn Programming
      • Ajax Tutorial
      • C Language
      • C++ Tutorials
      • CSS Tutorial
      • CSS3 Tutorial
      • JavaScript Tutorial
      • jQuery Tutorial
      • MainFrame
      • PHP Tutorial
      • VBScript Tutorial
      • XML Tutorial
    • Learn Software Testing
      • Software Testing Types
      • SQA
      • Testing
  • Career Training
    • Career Improvement
      • Career Articles
      • Certification Articles
      • Conflict Management
      • Core Skills
      • Decision Making
      • Entrepreneurship
      • Goal Setting
      • Life Skills
      • Performance Development
      • Personal Excellence
      • Personality Development
      • Problem Solving
      • Relationship Management
      • Self Confidence
      • Self Supervision
      • Social Networking
      • Strategic Planning
      • Time Management
    • Education Help
      • Career Tracks
      • Essay Writing
      • Internship Tips
      • Online Education
      • Scholarships
      • Student Loans
    • Managerial Skills
      • Business Communication
      • Business Networking
      • Facilitator Skills
      • Managing Change
      • Marketing Management
      • Meeting Management
      • Process Management
      • Project Management
      • Project Management Life Cycle
      • Project Management Process
      • Project Risk Management
      • Relationship Management
      • Task Management
      • Team Building
      • Virtual Team Management
    • Essential Life Skills
      • Anger Management
      • Anxiety Management
      • Attitude Development
      • Coaching and Mentoring
      • Emotional Intelligence
      • Stress Management
      • Positive Thinking
    • Communication Skills
      • Conversation Skills
      • Cross Culture Competence
      • English Vocabulary
      • Listening Skills
      • Public Speaking Skills
      • Questioning Skills
    • Soft Skills
      • Assertive Skills
      • Influence Skills
      • Leadership Skills
      • Memory Skills
      • People Skills
      • Presentation Skills
    • Finding a Job
      • Etiquette Tips
      • Group Discussions
      • HR Interviews
      • Interview Notes
      • Job Search Tips
      • Resume Tips
      • Sample Resumes
 

MSAS – Building a Virtual Cube

By Exforsys | on April 24, 2005 |
MSAS
In the above section we studied some of the reasons why we would want to create virtual cubes and how logical results can be obtained by making such cubes. We also saw that a virtual cube can be built quickly and easily by using the Virtual Cube Wizard.

Building a Virtual Cube

The Wizard takes the user through a series of steps that prompt him to specify the cubes, measures and dimensions to be used for building the virtual cube. The virtual cube then creates a combined view of the selected cubes by including the measures and dimensions selected. Please note that a virtual cube based on a linked cube does not support custom rollup operators, custom rollup formulas, cell calculations, or custom member formulas contained in the linked cube.

We can build a virtual cube by invoking the virtual cube wizard. Let us say we will create a virtual cube using the sales and Budget cubes of FoodMart 2000 database. We want to compare the budgeted sales against the actual sales. Right click on cubes folder under FoodMart 2000 database and select New Virtual Cube.

In the Wizard welcome screen click Next and navigate to the Select the cubes to include in the Virtual cube as Sales and Budget.

Next select Amount and Unit sales from the list of measures available

Rename the measures as the measures must have unique identifiers for a Virtual cube. Select Time, Product, Store and Account as dimensions of the Virtual cube.

Name the Virtual cube “The Sample” and let the Process now radio button remain checked and click on Finish.

The Process log window opens and the cube is processed.


The Virtual cube editor now displays the data from the consolidated virtual cube.

}

Customization of data from a cube for presentation

The reason why we need to customize data for presentation is that there may be certain data which should not be accessible to certain users. We need to restrict their access to such data. There may yet other users who will need to access all data. We may need to give them access to the data. The virtual cube enables us to create a cube out of existing cubes and enables us to include or exclude dimensions and measures for the virtual cube. By excluding dimensions we can restrict users from accessing data in those dimensions, yet give him access to data he can view by including those specific dimensions.

In Analysis Manager Tree pane right click the cubes folder and click New Virtual cube.

Click Next on the Virtual Cube Editor Welcome screen.

The Wizard displays the cubes existing in the database.

Select the cubes to be included in the database. Let’s say we want to click on Sales Cube. Click on Sales cube and click next.

The measures for the cube are displayed. Double click unit_sales and sales_cost. Click on the measure names selected and rename them. A unique name is required for measures in a virtual cube. We could name our measures Sales_per_Unit and Cost_per_store.

The Dimensions box is displayed. All the dimensions of the cube are displayed. Double click Time, State..

Double-click Time, Product and Customers and then click Next

Type Basic sales as the name of the Virtual cube. Let the Process now option remain selected, click finish and close the process log window once the processing is complete.

The virtual cube Wizard leaves us back at the Virtual cube Editor. This is a modified version of the Cube Editor. It does not contain the schema tab only the data screen.

To make structural changes to the virtual cube the user must click Edit structure Wizard toolbar button to redisplay the virtual cube wizard.

The Analysis server has to process the virtual cube. Processing creates files to identify the cube and indicate how to relate the virtual cube to the original cube.

{mospagebreak}

Consolidation of data from multiple cubes into a Virtual cube

The sales information is contained in the Sales cube. The region details are contained in the region cube. Let us say we want to combine the two to obtain information on the sales made in different regions. A virtual cube can be used to compare the measures from the different cubes.

Right click the cubes folder, and click New Virtual cube. Click Next on the welcome screen. In the list of available cubes click Sales and Region.

Click Next. In the measures list select the measures required. Then click the dimensions required from the Dimensions list and click next.

Give a name to the virtual cube, Process the cube and view the data.

When measures are combined in virtual cubes for inclusion, the user must select a measure from each cube he wants to combine. The wizard automatically removes any cubes that do not have measures. Technically, it is possible to combine two cubes without a shared dimension, but none of the cells in the virtual cube will contain a value.

« « MSAS – Understanding Virtual Cubes
MSAS – Creating and Maintaining Calculated Members in Virtual Cubes » »

Author Description

Avatar

Editorial Team at Exforsys is a team of IT Consulting and Training team led by Chandra Vennapoosa.

Free Training

RSSSubscribe 392 Followers
  • Popular
  • Recent
  • MSAS : The Data warehousing framework of SQL Server 2000 – Part 2

    March 18, 2005 - 0 Comment
  • MSAS – Troubleshooting Cube Processing

    April 18, 2005 - 0 Comment
  • MSAS : Basics of Levels

    March 31, 2005 - 0 Comment
  • MSAS – Introducing Analysis Services Security

    May 2, 2005 - 0 Comment
  • MSAS : Introducing Analysis Manager Wizards

    March 7, 2005 - 0 Comment
  • MSAS: Defining Cube Properties

    April 9, 2005 - 0 Comment
  • MSAS : The Analysis Manager and Analysis Server

    March 18, 2005 - 0 Comment
  • MSAS – Introduction and Managing Partitions

    April 19, 2005 - 0 Comment
  • MSAS: Working with Parent-Child Dimensions

    March 31, 2005 - 0 Comment
  • MSAS – Securing User Authentication

    May 2, 2005 - 0 Comment
  • MSAS – Browsing the Dependency Network

    May 6, 2005 - 0 Comment
  • MSAS – Building a Relational Decision Tree Model

    May 6, 2005 - 0 Comment
  • MSAS – Introduction to Data Mining

    May 6, 2005 - 0 Comment
  • MSAS – Applying security to a Dimension

    May 5, 2005 - 0 Comment
  • Tutorial 65: MSAS – Managing Cube Roles

    May 5, 2005 - 0 Comment
  • MSAS – Understanding Database Roles

    May 5, 2005 - 0 Comment
  • MSAS – Securing User Authentication

    May 2, 2005 - 0 Comment
  • MSAS – Introducing Analysis Services Security

    May 2, 2005 - 0 Comment
  • MSAS – Writebacks

    April 28, 2005 - 0 Comment
  • MSAS – Defining and Creating Drillthrough

    April 26, 2005 - 0 Comment

Exforsys e-Newsletter

ebook
 

Related Articles

  • MSAS – Browsing the Dependency Network
  • MSAS – Building a Relational Decision Tree Model
  • MSAS – Introduction to Data Mining
  • MSAS – Applying security to a Dimension
  • Tutorial 65: MSAS – Managing Cube Roles

Latest Articles

  • Project Management Techniques
  • Product Development Best Practices
  • Importance of Quality Data Management
  • How to Maximize Quality Assurance
  • Utilizing Effective Quality Assurance Strategies
  • Sitemap
  • Privacy Policy
  • DMCA
  • Trademark Information
  • Contact Us
© 2023. All Rights Reserved.IT Training and Consulting
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.AcceptReject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT