Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

In SAS Web Report Studio 3.1, when displaying a relational report that includes a crosstabulation table, you might see the following error:

Error Rendering the Report (Rendering Content)
An invalid function was applied to the following DataItem - Profit per item : InternalAggregation 
   
  
  Root Cause:   com.sas.iquery.strategies.sas.oma.summaryrolap.ROLAPGenerationException: An invalid function was
   applied to the following DataItem - Profit per item : InternalAggregation
	at com.sas.iquery.strategies.sas.oma.summaryrolap.ProcSummaryROLAPStatement.extractDataItemFunction(Unknown Source)
...

This error occurs when at least one measure used in the table is defined as follows:

• The expression is user-defined.
• The aggregation type is either Defined in expression or Defined in expression (additive).
• The expression references physical data items instead of business data items.

For example, if you create a measure with the expression <<ORSALES.Profit in USD>> / <<ORSALES.Number of Items>>, and you select Defined in expression as the aggregation type, then you will see the error if you attempt to use the measure in a crosstabulation table.

If you are running the latest hot fix of SAS Web Report Studio, you might be able to render the crosstabulation table by hiding the measure. However, even if you are able to hide the measure, the error will occur if the report is synchronized and you modify the section query using the Data selected from pane.

As a workaround, you can use business data instead of physical data, or you can change the aggregation type to something like SUM(argument). If you modify the measure, make sure that you are still getting the expected results.

SAS Web Report Studio 4.2 prevents you from adding this type of measure to crosstabulation tables.

For more information about measures that are not supported in relational crosstabulation tables, see SAS Note 34257.

Operating System and Release Information