I don't think you can save that info as a "default" aggregation rule every time you use that column.
Thanks Gianni for your answer. so...you think that is not possible?
Do you know if in obiee 10 was possible?
1 person found this helpful
Honestly I will say it wasn't possible in OBIEE 10 (can't remind exactly because it was so long time ago ....)
For 99.5% of the columns "default" works just fine, yours is a special case.
Try to help your users reminding to do that change by adding it as a comment in the column in the RPD.
Or if you ask because you have 2342134 analysis using this column and you need to change all of them to "Server Complex Aggregate" just do a search/replace with the Catalog Manager, in 2 minutes all the analysis will have the new aggregation rule.
Not possible now, not possible back then.
Thanks for your replies!