Session-Level Calculated Member Examples

The data that is used in these examples is from a company that sells electronics and outdoor and sporting goods equipment.

This example creates the session-level calculated member called avg_price in the sales cube on the Measures dimension. This calculated measure shows the average price:

create session
    member [sales].[measures].[avg_price] as
      '[Measures].[total] / [Measures].[qty]'   

Nothing is returned when you create a session-level calculated member.

This example uses the session-level calculated member called “avg_price.” It shows the quantity, total, and average price of goods sold from 1998 through 2000.

SELECT
    {[measures].[qty], [measures].[total],
 [measures].[avg_price]} ON COLUMNS,
    {[time].[all time].children} ON ROWS
 FROM sales

Here is the resulting output:

This example uses the session-level calculated member called “avg_price.” It shows the quantity, total, and average price of goods sold in different customer regions.

SELECT
    {[measures].[qty], [measures].[total],
 [measures].[avg_price]} ON COLUMNS,
    {[customer].[all customer].children} ON ROWS
 FROM sales 

Here is the resulting output:

This example uses the session-level calculated member called “avg_price.” It shows the quantity, total, and average price of goods sold in the different product groups.

 SELECT
    {[measures].[qty], [measures].[total],
 [measures].[avg_price]} On COLUMNS,
    {[product].[all product].children} ON ROWS
 FROM sales

Here is the resulting output: