Have Geek Brain

SQL Server Analysis Services 2008 Aggregates and ByAccount

I am having problems getting the "ByAccount" aggregation to work in SQL Server Analysis Services (SSAS) 2008.

I am trying to create a financial reporting solution with balance sheet and profit and loss items.

I have a fact table with numbers at the level of detail. I am currently interested in one measure, "Reporting Amount" and the "Aggregate Function" property set to "ByAccount".

I have a time dimension consisting of a year and a period, with the year set for the type "ReportingYear" and the Period set for "ReportingMonthOfYear".

I have a dimension "Account" consisting of the following attributes: AccountId (for setting the type AccountNumber), AccountType (for setting the AccountType parameter), ParentAccountId (for setting the type "Account using the parent").

If I go to "Edit Database", I can see that the appropriate mappings for the account types are set, and for the balance types, "LastNonEmpty".

However ByAccount just doesn't take effect, I am not collecting anything with "LastNonEmpty". What am I missing?

0


a source to share


1 answer


I eventually discovered that the problem was that the AccountType column was an integer Id. Changing this line for the line containing the actual description of the account type such as "Asset", "Liability", etc., fixed the issue.



+1


a source






More articles:


All Articles