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 – Creating and Maintaining Calculated Members in Virtual Cubes

By Exforsys | on April 24, 2005 |
MSAS
Calculated members can be imported into virtual cubes from their component cubes. New calculated members also can be created directly into virtual cubes. The Calculated member Builder can be used to build the members or calculated members created in component cubes can be imported and then the same can be edited.

The virtual cube editor is used to maintain the calculated members in virtual cubes. The Virtual cube Editor provides a single click access to Calculated Member Builder and the Import Calculated Members dialog box, which can be used to import calculated members into the virtual cube.

Creating a Calculated Member in a Virtual Cube

In the Analysis Manager tree pane, right-click the virtual cube, and then click Edit.

In Virtual Cube Editor, on the Insert menu, click Calculated Member.

15b.gif

In Calculated Member Builder, in the Parent dimension box, select the dimension that will include the calculated member. Select Store.

In the Parent member box, specify the member that will include the calculated member.

In the Member name box, type a name for the calculated member as Store Profit.

In the Value expression box, construct an expression to produce the values of the calculated member.

[Measures].[Store sales]-[Measures].[Store Cost]

Use any combination of the following methods to add to the expression:

Drag items from the Data and Functions boxes.

Click an item in the Data or Functions box, and then click Insert.

Click the arithmetic operator and number buttons.

Type.

(Optional.) To register additional function libraries, click Register.

To close Calculated Member Builder, click OK.

To save the calculated member, in Virtual Cube Editor, on the File menu, click Save.

Importing a Calculated Member into a Virtual Cube

While importing a calculated member into a virtual cube, it is important that the syntax of the Calculated member is validated. Syntax errors can occur due to incorrectness of the expression or that the value expression includes a measure, dimension or other objects which are not available in the virtual cube. The calculated member will not be displayed to end users so long as the error is not rectified. The syntax errors can be corrected by invoking the Virtual cube Wizard from within the Virtual cube Editor, or by clicking Structure(Wizard) on the Edit menu of the Virtual Cube Editor. The calculated member can also be edited in the Calculated Member builder and re-imported.

If the user imports a calculated member that bears the same name as an existing calculated member in the cube, the imported member is renamed automatically. The new name will be the old name plus a numeric suffix.

Calculated members can be imported only from cubes that are in the same database as the virtual cube.
In the Analysis Manager tree pane, right-click the virtual cube, and then click Edit.

In Virtual Cube Editor, on the Edit menu, point to Import, and then click Calculated Members. 

In the Import Calculated Members dialog box, the calculated members are displayed. The user can select the check box beside the calculated member, and then click OK. (To select all the calculated members in a cube, select the check box beside the cube.)

In Virtual Cube Editor, on the File menu, click Save.

To edit a calculated member in a virtual cube

In the Analysis Manager tree pane, right-click the virtual cube, and then click Edit.

In the Virtual Cube Editor tree pane, right-click the calculated member, and then click Edit. The Calculated member builder dialog box appears.

In Calculated Member Builder, in the Parent dimension box, select the dimension that will include the calculated member, or select Measures.

In the Parent member box, specify the member that will include the calculated member. Click Change to select a member other than the displayed member.

In the Value expression box, construct an expression to produce the values of the calculated member. Use any combination of the following methods to add to the expression:

Drag items from the Data and Functions boxes.

Click an item in the Data or Functions box, and then click Insert.

Click the arithmetic operator and number buttons.

Type.

To close Calculated Member Builder, click OK.

To save the calculated member, in Virtual Cube Editor, on the File menu, click Save.

In this lesson we learnt about Virtual cubes, the benefits of creating and using such cubes and also how to create calculated members for such cubes. Virtual cubes can effectively remove dimensions or measures from a cube, combine measures from multiple cubes that share at least one dimension or both. 

« « MSAS – Building a Virtual Cube
ASP .NET Migration and Interoperability » »

Author Description

Avatar

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

Free Training

RSSSubscribe 401 Followers
  • Popular
  • Recent
  • Understanding OLAP Models

    March 2, 2005 - 0 Comment
  • MSAS: Virtual Dimensions

    April 7, 2005 - 0 Comment
  • MSAS : Microsoft Data Warehousing Overview

    March 15, 2005 - 0 Comment
  • MSAS – Processing Dimensions and Cubes

    April 17, 2005 - 0 Comment
  • MSAS : Shared vs Private Dimensions

    March 31, 2005 - 0 Comment
  • MSAS – Defining and Creating Drillthrough

    April 26, 2005 - 0 Comment
  • MSAS – Applying OLAP Cubes

    March 3, 2005 - 0 Comment
  • MSAS: Introduction and Working with Cubes

    April 9, 2005 - 0 Comment
  • MSAS : The Data warehousing framework of SQL Server 2000 – Part 1

    March 15, 2005 - 0 Comment
  • MSAS – Optimizing Cube Processing

    April 18, 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
© 2022. 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.Accept Reject Read More
Privacy & Cookies Policy
Necessary Always Enabled