Once I build a model without selecting "create aggregrates". Can I take that model and change one decimal attribute (PCOM AMT(C2) and make that a numeric aggregate with the additional aggregrate attributes? I tried changint it to "isaggregrate" and then regenerating the attribute but there was no change. Is isaggregrate only used for new expressions?
I get the following message:
The IsAggregate property for the Attribute 'PCOM AMT' is true, but a Column binding is specified. IsAggregate cannot be true if Column is specified.
If I remove binding and rebuild I get this message.
The binding is missing for the Attribute 'PCOM AMT'. Attribute must have exactly one Column binding if Expression is not specified.
Thank you!
IsAggregate flag on entity attribute only tells the model that the attribute can be used as aggregate. Taking a column-bound attribute and marking it IsAggregate will not make it an aggregate.
What you need to do is to leave the column-bound attribute as is and create new attribute that will have an aggregate expression like this: Count(my_column_mound_attribute). Then mark this new attribute as IsAggregate.
Regenerating model will not automatically add new aggregates.
No comments:
Post a Comment