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