Exforsys.com
 
Home Tutorials MSAS
 

Tutorial 59: MSAS - Creating and Maintaining Calculated Members in Virtual Cubes

 

Tutorial 59: MSAS - Creating and Maintaining Calculated Members in Virtual Cubes

Page 1 of 2
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.


Next Page: Tutorial 59: MSAS - Creating and Maintaining Calculated Members in Virtual Cubes - Page 2


Read Next: Tutorial 60: MSAS - Defining and Creating Auctions



 

 

Comments


Sridhar V said:

  Please explain me how to create an action based on dataset type in MSAS 2000
November 22, 2007, 11:52 pm

Sridhar V said:

  Please help me how to automate the cube processing by scheduling,
November 22, 2007, 11:56 pm

Post Your Comment:

Members Please Login
Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe    

Sponsored Links

 

Subscribe via RSS


Get Daily Updates via Subscribe to Exforsys Free Training via email


Get Latest Free Training Updates delivered directly to your Inbox...

Enter your email address:


 

Subscribe to Exforsys Free Training via RSS
 

 
Partners -  Privacy and Legal Policy -  Site News -  Contact   Sitemap  

Copyright © 2000 - 2009 exforsys.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape