From:	Maynard, William E.
Sent:	Thursday, March 29, 2001 4:05 PM
To:	Boyden, Lyle C.; DANIELLE BURRELL; DENISE DUPONT; DONALD MAY; Fahrenbacher, Jorge; LaRoche, Thomas E; LINDA MELANSON; MARC CHARBONNEAU; Naik, Vibha; Peters, Robert J.; Ruszczyk, Henry; TRACI PARRISH
Cc:	Rancourt, David B.
Subject:	BW design gem

Attachments:	Picture (Device Independent Bitmap)
Complements of Dave Rancourt's investigation (still a techie at heart):

Use of formula variables will allow calculations within queries that involve master data attributes, without having to bring those attributes to the cube via transaction data.

Here's how it works:
•	Create a new formula variable - in from the same place where we create normal Bex variables similar to this.  Pick the characteristic and its attribute that you want to use in a calculation. Use other options similar to sample below:

 

•	Go to Bx and build a query:
•	Build a new calculated key figure and select a formula variable from those available (you should see all formula variables associated with characteristics in your cube. E.g., you will see the new formula variable above if your cube has 0material).
•	Run new query with this new calc. key figure.... 
•	Wait for the applause.

Will Maynard
CSC / Pratt & Whitney
Business Information Warehouse Team (BW)
Tel: (860) 731-9210, Fax: (860) 557-9851
maynarwe@pweh.com