BPC Reporting

[former_member602692]

Hi Experts,

Would like to ask if you have a known issue like on ours:

Background: We have 4 currencies in CURRENCY dimension (LC, USD, USD@avg, Cons_Curr)

Issue: We cannot pull the USD@AVG currency together with other currencies in 1 report if the TIME dimension is not in Base level.

[former_member186338]

Sorry, but absolutely not clear!

System version and SP?

Dimension members screenshot...

[former_member602692]

Hi Vadim,

Version 10.0 SP 32

The dimension members in the screenshot are just hard coded for sample sake. Main concern is that when pulling in parent or dependent member of TIME dimension (e.g. 2020.Total - Parent in screenshot), we cannot pull USD@AVG currency alongside of other currencies. BUT if pulled in base level of time which is the Monthly - we are able to pull the USD@AVG alongside with other currencies.

Hope that is clear.

Thanks in advance!

[former_member186338]

Version 10.0 SP 32 - this is EPM version, but I am asking about BPC version/SP!

Please provide a screenshot of web administration of CURRENCY dimension members! Asking second time.

[former_member602692]

Hi Vadim,

BPC 10 SP13. Here's the screenshot of the CURRENCY dimension sheet.

[former_member186338 · Accepted solution]

The issue can be with special character "@" in the member ID "USD@AVG"

Use "USD_AVG"

P.S. BPC 10 SP13 - is terribly old! Think about upgrade to the latest SP27

[former_member602692 · Accepted solution]

Thank you! Just not sure if that will resolve as we are able to pull USD@AVG if on base member of the TIME. Also, CONS_CURR has a special character as well but we are able to pull alongside with other currencies even in Parent level of TIME.