Reporting help for SAP Bex query based on HANA compsitie provider

[former_member211603]

Hi All,

We have calculation view(CV) -> composite provider(CP). I have to built a bex query on CP with below requirement:

SAP HANA studio 2.3.

Input parameter in view: Deal: 123 And ACT_Date: <=3/31/2018 (user can enter any input date, I have taken <= sign to consider all records for processing)

CV data:

Report output should display Actual_YTD only for Rep period:12. Report layout as below:

User want to see data for Deal 123, YTD and tenant.

From ACT_Date, YTD data should be split by latest year wise in 3 columns always. And if you see input date has no reference with data set returned with <=3/31/2018 selection.

I can not do any customer exit in Bex query because input date does not give any reference to ACT_Date and YTD. Requesting you to help to know how these yearly split columns can be derived at hana calculation view level to display respective YTD amount.

One more example for reference: User input date ACT_Date <= 12/31/2017

output:

Thank you.

[former_member211603 · Accepted solution]

Thank You Shai for looking into my question and replying to it.

Issue has been solved.

I am able to get this requirement done in hana calculation view by using calculated columns. and then directly pull result data into Bex for display.

[shai_greenberg]

Hi P.J,

If I understand the issue correctly, you get the dataset from the Calculation View but can't use the value of the input parameter.

What you require is the values for the last 3 years returned in the output. One way to achieve such a requirement would be to create a formula variable based on replacement path from the year object. Based on the examples given, you might be able to use a top 3 condition to get the last three values, although I'm not too sure whether that would be a good fit for other examples.

I'm also not sure I understand how the tenant requirement fits into that - the structure shown in the images seems to suggest two separate queries - the way to achieve that depends on your reporting tool.

- Shai

[former_member211603]

Can somebody please help with some inputs/suggestion,this is really holding report completion.