Hello All,
I have tried creating a sample SSAS Project, using the AdventureWorksDW DB.
I have created an account parent-child dimension using an account dimension type.
I'm using the measure Amount from the FactFinance table, and used the ByAccount aggregateFunction property for that measure.
The problem is, when deploying that project I get the following error:
Aggregation function NONE specified for mapping account type Statistical is not supported for ByAccount semiadditive measure.
The Statistical account type aggregation function is set by the business intelligence wizard to None. I see no way to change it.
Does anyone see what's the problem here?
Hi,
The aggregation functions can be changed by selecting Database -> Edit Database in the AS project in BIDS.
-Morten
No comments:
Post a Comment