Dynamic Headers using an SSAS Parent Child Dimension
Hi, We are trying to build some finanical reports (Balance Sheet, Income Statement, etc) in reporting services using Analysis Services as a data source. The problem we are running into is more of a formatting issue around the use of custom headers. We want to have the ability to do the following: Interest Income (as a header) Loans Deposits Funds sold Total Interest Income (rollup of children above) Interest Expense (as a header) NOW CDs Total Interest Expense (rollup of children above) Provision for loan losses (single line item, no group needed) Getting the parent to appear after the child is pretty simple by using the hierarchize function. The problem is getting the parent as a header to appear. The crux is that we only want to use certain levels (not every single level) in the parent child hierarchy for doing a header. For example, above, Interest Income and Interest Expese would have a header, whereas Provision for loan losses would not. This is pretty common formatting features for financial reports, plus its very common to use a parent child for Chart of Accounts, thus somebody has had to have run into this in the past. Thanks, Joe
October 28th, 2010 10:03pm

Interest Income (as a header) Loans Deposits Funds sold Total Interest Income (rollup of children above) Interest Expense (as a header) NOW CDs Total Interest Expense (rollup of children above) Provision for loan losses (single line item, no group needed) Hi Joe, I am a little confused about your requirement, could you please more specific about what kind of control you utilized? Is your top report designed in one control or sever control? If possible, you could also post your report XML file in the forum. Thanks, Challen Fu
Free Windows Admin Tool Kit Click here and download it now
November 2nd, 2010 7:52am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics