6,648
Like
Share
ReportThe 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
*This post is locked for comments