The INSERT DATAITEM statement must include one of the following arguments:
insert datasource sasserver="SASMain" table="Common"."WORLDPOP2002" id="PopulationData"; insert dataitem column="PopulationData"."Projected_Population_millions_";
<<Measures.new_business_value_sum>>, <<campaigns>>, <<campaigns.campaigns>>, [campaigns].[All campaigns].[ADVT]
insert datasource sasserver="SASMain" cube="Simba"; insert dataitem hierarchy="MARKET"."GEOGRAPHICAL" id="Geographical";
insert dataitem hierarchy="MARKET"."GEOGRAPHICAL" id="Geographical1"; insert dataitem expression="<<MARKET.GEOGRAPHICAL>>" id="Geographical2" type=character;
insert dataitem expression="<<MARKET.GEOGRAPHICAL.STATE>>.members" id="State" type=character;
insert datasource sasserver="SASMain" cube="SASMain - OLAP schema".Simba; insert dataitem measure="ACTUALAVE" id="Average Actual";
actions=(nosort)
tells
SAS Web Report Studio not to offer the Sort menu selection for this data item.
actions=(RANK SORT NOFILTER NONAVIGATE)
InternalAggregation
and InternalAggregationAdditive
), see "Summarizing Data:
Using Aggregate Functions" in the "Retrieving Data from a Single Table"
chapter in the SAS SQL Procedure User's Guide.InternalAggregation
specifies that the values of the measure data item are aggregated
by a nonadditive expression. A nonadditive expression is one for which
the arithmetic summation of the aggregated values of the measure data
item is not equal to the arithmetic summation of all of the detail
values of that data item. For example, SUM(COL1)/COUNT(COL1)
is a nonadditive expression. If you specify that a data item has
a nonadditive expression, then the total for that data item is calculated
by applying the specified expression to the detail values of the data item.
InternalAggregationAdditive
specifies that values of the measure data item are aggregated by
an additive expression. An additive expression is one for which the
arithmetic summation of the aggregated values of the measure data
item is equal to the arithmetic summation of all of the detail values
of that data item. For example, SUM(COL1*COL2)
is an additive expression.
If the data item is defined by an expression that references
a measure data item or that contains an aggregate function, then the
only valid values for the AGGREGATION= option are InternalAggregation
or InternalAggregationAdditive
.
aggregations_drop_list=(Freq FreqDistinct CSSDistinct)
aggregations_keep_lisT=(Freq FreqDistinct CSSDistinct)
custom_properties=(("MA_Level" "Nominal" "Descriptive text goes here.") ("MA_UseInSubjectIdTop" "Subject_ID_" "Subject ID"))
. < > [ ] { } \ / ^ @ ~If a name contains any of these characters, they are replaced with an underscore (_) when the ID is generated from the name.
The first 32 characters of an ID must be unique across an information map. An error occurs if you specify an ID that is the same as an existing ID (data item, data source, filter, or other). An ID that differs only by case from another ID in the current information map is not considered unique.
A data item name can contain blank spaces, but it cannot consist only of blank spaces. Nulls and non-blank nonprintable characters are not valid characters in a data item name. A data item name can contain the following special characters, but they are replaced with an underscore (_) in the ID that is generated from the name:
. < > [ ] { } \ / ^ @ ~Square brackets ([ ]) are not valid in an OLAP data item name.
value_generation=( ("CA" "California") ("NC") ("NY" "New York") )