Signage in BPC 10.1 - when using AO as reporting front-end

[srikanth_ramachandran]

My question is regarding wanting to display the values in the AO report according to the absolute (or DB) signage rather than the 'natural' signage that EPM uses based on the account type. Even when using AO, the liabilities that have a credit bal are displayed as positive and debit amounts are shown as negative. This seems to be due to the signage being set up on the account hierarchy automatically when it is created, based on the account type of the values/nodes in the hierarchy. Is there any way to prevent the Reverse Signage flag from being set on the hierarchy members? Does the CREDITPOSITIVE value in the transformation file control this?

Any help is appreciated.

Thanks,

Sri

[William_Yu1]

Hi srikanth.ramachandran,

Few questions to clarify:

1. Is it BPC standard ?
2. By saying AO report, are you using Analysis plug-in(report based on Query) or EPM plug-in?

Best regards, William

[srikanth_ramachandran]

Hi William, Yes this is standard model and yes I am referring to the Analysis Plug-in; not EPM. Our users have some requirements that seem to fit AO better hence using AO Plug-in in this instance.

Thanks,

Sri

[former_member186338]

Have to ask the same:

BPC - standard or embedded?

[former_member186338]

Sorry, but unable to understand!

If you are using standard model then you have to use EPM plug-in of AO, not Analysis Plug-in or standalone EPM Add-n

What are you looking for in Analysis Plug-in???

P.S. Please attach some screenshot!

[srikanth_ramachandran]

Hi Vadim - basically our requirement is to display the values using Analysis for Office reporting tool (not EPM), such that balances for all liability / income accounts are displayed with the minus sign; as they are stored in the database. This doesnt seem to be possible due to the hierarchy nodes and members having the reverse sign flag automatically selected when the hierarchy is created on the BPC account dimension. I will attach a screen print shortly.

Thanks,

Sri

[former_member186338]

Sorry, but still unable to understand how you are using Analysis Plug-in to view data in BPC standard model!!!

[srikanth_ramachandran]

Connecting to AO data source in Excel plug-in (BPC cube is selected as the data source)

[srikanth_ramachandran]

BPC cube selected

[srikanth_ramachandran]

Cube is selected

[former_member186338]

Sorry, but to my mind it's an absolutely crazy approach: to use BPC infocube in Analysis reporting.

What is the benefit????

[srikanth_ramachandran]

Main use cases are -

1. Several attributes of BPC dimensions used for slice/dice kind of reporting of the BPC balances

2. Absolute or database signage preferred (as opposed to EPM natural signage) for reporting

3. Easier for users to get up and running with AO rather than EPM (more of a learning curve to create reports)

Happy to take your feedback on these Vadim.

Thanks.

[former_member186338]

1. Same can be done with EPM

2. Database signage is achieved by creating simple custom measure.

3. AO reports are very limited compared to EPM reports.

[srikanth_ramachandran]

Thanks Vadim. Re. pt. 1 - is it possible without needing to use epmretrieve() ? Meaning, can users without in-depth knowledge of EPM be able to do handle that?

Re. 2 is there any code snippet you can point me to?

[former_member186338 · Accepted solution]

1 - is it possible without needing to use epmretrieve() ? Meaning, can users without in-depth knowledge of EPM be able to do handle that?

Sorry, but not clear!

If you have proper dimensions with proper number of required hierarchies then everything is simple.

2 is there any code snippet you can point me to?

Sample:

Standard YTD measure for YTD model is:

'IIF(([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC" OR [%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ"),-([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])), ([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])))' SOLVE_ORDER=3

Create VERY simple custom YTD measure: CYTD

'([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%]))' SOLVE_ORDER=3

You can see - no sign change happens!

Same for other measures.

[srikanth_ramachandran · Accepted solution]

Thanks Vadim - that helps! With regard to the slice and dice reporting on attributes - an example is a Product type Dimension which has an attribute of Bank vs Nonbank .. with Analysis I can simply pull the Attribute into the report and display the balances according to Bank vs Nonbank split; with EPM it doesnt seem to be possible via drag and drop.

Also, is it required to have at least one hierarchy per dimension, so that all values can be selected in the report definition ? (Top node and member/descendants combination) - since EPM context seems to require a selection for each and every dimension.

[former_member186338 · Accepted solution]

srikanth.ramachandran

An example of dimensions that has no hierarchy by default:

CATEGORY

CURRENCY

For the rest it's better to have at least one.