Difficulty with local members and headings

[Former Member]

Hello,

Due to confidentiality, I can't post an actual screenshot, but I have created how I would like to set up my report below. The report is build that the rows are base levels of parent accounts (i.e. base level of S10000-Assets then separated by two blank members then base level of S20000-Liabilities, etc.). The columns are two reports. Report one is dynamic company codes based on what "Group" the user selects in the Page Axis.  Report 2 is static datasource totals.

There are 3 issues I am having:

1) Having the local members summing each section stay on the page, and stay dynamic. The =SUM(EPMALLMEMBERS) worked when I put it at the bottom of the report. But I don't think I can use it for this report.

2) Having a header stay for Liabilities and Equity. I am using blank members to separate the sections of the balance sheet and would like to rename on so it stays before the Liabilities and Equity sections, but I haven't been able to figure it out yet..

Any guidance would be greatly appreciated.

[former_member186338 · Accepted solution]

Sorry, but why do you need local members? Why you are not using hierarchy totals in account hierarchy?

[Former Member · Accepted solution]

Hi Vadim,

I originally built the report with hierarchy totals in substitution of a local member, but my manager wanted the report built identical to how it was built in BPC v7.5. So I was inquiring if it's possible to use local members in this way?

Thanks!

[former_member186338 · Accepted solution]

Sorry, but in 7.5 parents also have to be used (and there are no local members in 7.5 ). Please don't reinvent the wheel, use correct approach.

I suspect that in 7.5 the static report was used...

[former_member186338 · Accepted solution]

Is it a report or input form for offline processing?

[Former Member · Accepted solution]

Hi Vadim,

I agree there are no local members in 7.5, but the 7.5 report was built by having a formula after the last account in the assets, liabilities and equity. See screenshot. So it didn't need to use parents.

The 7.5 report was dynamic as well.. when the user selects a "Group" then the total number of companies within the group will populate in the columns.  It is just a regular report and not an input form. In 7.5, we would have used pipes to separate the sections, so I could insert a header for the section and a formula after a section, and it would recognize how the report changes to change the formula.

[former_member186338 · Accepted solution]

Sorry, but parent is absolutely standard method to aggregate children. You are trying to replace BPC engine with Excel formulas

In BPC 10 you can use local members to insert headers, blank lines etc... But use real parent to aggregate!

P.S. BPC 10 reports are absolutely different compared to BPC 7.5, don't spend time trying to do the same!

[Former Member · Accepted solution]

Thanks Vadim! I learned a lot and made it work. I agree that using the parents to aggregate gets the same result and is more reliable.