Writing Calculation in Data Visualisation

user13507279

Organization Name

Natwest Group

Description

Through EPM connector we can make direct connection with EPM clouds applications and can get the insight of data through visualisation. While working POC I came across it is not possible to write any simple formula in DV. For an instance I have “Net interest Income” and “Loan to customer gross” in PBCS(cube) and I would like to calculate NIM (Net interest Margin) which is equal to “Net Interest income”/”Loan to customer Gross”.

We can achieve this through the creation data flow. However, it is also not possible to create data flow, if the connection is created through EPM connnector. The same is doable in case of Oracle table.

Therefore it would be definitely helpful for customer if at some extend writing calculation is possible on EPM connector data set or let customer can create data flow on the top of EPM connector data set.

Use Case and Business Need

Through EPM connector we can make direct connection with EPM clouds applications and can get the insight of data through visualisation. While working POC I came across it is not possible to write any simple formula in DV. For an instance I have “Net interest Income” and “Loan to customer gross” in PBCS(cube) and I would like to calculate NIM (Net interest Margin) which is equal to “Net Interest income”/”Loan to customer Gross”.

I understand we can write this in PBCS and then retrieve in DV. But it is just an example. Like in my case whatever data customer receive from PBCS they would write some secret calculation on it in excel on the fly and then generate the graph through excel only.

Alternatively, even we can create data flow in dv and can write whatever calculation we want. However, it is also not possible if the connection is created through EPM connnector. The same is possible in case of Oracle table.

it would be definitely helpful for customer if at some extend writing calculation is possible through EPM connector or let customer can create data flow on the top of EPM connector data set.

Original Idea Number: 11be3955c4

gmigotto

Agree. Even for us this is a great limitation.

user13507279

Let me illustrate through another concrete example:

	FY20	FY21	FY22
MIR Customer Interest Received	1000	2000	3000
MIR NII Payable	-150	-200	-300
NII	850	1800	2700

I want to calculate NII which is equal to "Interest Receivable" + "Interest payable". Seems easy to calculate through script, formula or hierarchy consolidation in PBCS. However it is not possible to calculate in data visualisation on EPM connector data set.