Specify Measures and Attributes

You must specify measures and attributes to analyze the desired sales information. To do this, you need to set properties on each view and table in the SalesAnalysis perspective.
The following properties are used to define how the data in the cube is presented.

• AnalysisDimensionType - determines the type of join to use when tables are related, or specifies that the table is a transaction table.

• AnalysisDimensionLabel - description for the view.

• AnalysisUsage - determines whether a field is used as an attribute or a measure.

• AnalysisDefaultTotal - determines how the values are aggregated.

• ExchangeRateDateField - selects the date field to use to determine the exchange rate. Because the cube can display multiple currencies,the exchange rate is used as of a specific date.Follow these steps to set properties on the CustTransTotalSales view:

1. In the SalesAnalysis perspective, select the CustTransTotalSales view.

2. In the Properties sheet, set the following values:

o AnalysisDimensionType: Transaction

o AnalysisDimensionLabel: Sales type

3. For the following fields in the view, set the AnalysisUsage to Attribute:

o TransType

o TransDate

4. For the AmountMST field, set the following parameters:

o AnalysisUsage: Measure

o AnalysisDefaultTotal: Sum

o ExchangeRateDateField: TransDate. This setting specifies that the currency exchange will be calculated using the rate on the transaction date.

Follow these steps to set properties on the CustTableCube view:

1. In the SalesAnalysis perspective, select the CustTableCube view.

2. In the Properties sheet, set the following values:

o AnalysisDimensionType: Auto. This uses the setting from the parent table

o AnalysisDimensionLabel: Customer information

o AnalysisMeasureGroupLabel: Customer details 

3. For the following fields in the view, set the AnalysisUsage to Attribute:

o Blocked

o GroupName

o City

o County

o Name

o State

4. For the AccountNum field, set the following parameters:

o AnalysisUsage: Measure

o AnalysisDefaultTotal: Count

Follow these steps to set properties on the CustPaymModeTable table:

1. In the SalesAnalysis perspective, select the CustPaymModeTable table.

2. In the Properties sheet, set the following values:

o AnalysisDimensionType: Auto

3. For the following fields in the table, set the AnalysisUsage to Attribute:

o Name

o PaymMode

o TypeOfDraft

o AccountType 

 
 


Best Regards,
Hossein Karimi