Share
Report
16Starting last year, we've been developing an SSAS based BI layer for our Dynamics SL. We've setup a GL view and a cashflow view.
Now we want to take a step further and internalize account hierarchy within the analysis cube.
As in:
- Expenses
- Administrative and general expenses
- Insurance fees
- (one or several accounts goes in this level)
- Insurance fees
- Administrative and general expenses
The financial staff is talking about 5 levels above the account number.
What would be the best approach for this?
Generally, we are very happy with our subaccount and account design. I've been reviewing our Management Reporter definitions and I see we can work this out, but MR is too print-render oriented. I don't see it would work well together with SSAS.
SL has an account class definition, but has only one level.
Is there some third party add-on for this?
*This post is locked for comments
All responses (
Answers (
