Analysis Services – Step by Step: Semi-Additive-Account
if set measure semiadditive property lastnotempty, browser shows accounttypes correct aggregation. if set measure semiadditive property sum, browser shows accounttypes correct aggregation. i have problem, if i'm attempting set measure semiadditive property of byaccount. the browser shows accounttypes aggregation sum. if start business intelligence wizard, i can see, default accounttypes have aggregatfunction = sum. dimension account has typ = accounts. measure amount has aggregatfunction = byaccount. can make ?
lutz,
if understand you, want change account type mapping, correct?
for need:
- open olap visual studio (file -> open -> analysis service database);
- in solution explorer, click right mouse button in database (the first item in solution explorer) , select edit database;
- in end of windows account type mapping , can change aggregation functions;
- save changes.
SQL Server > SQL Server Analysis Services
Comments
Post a Comment