cancel
Showing results for 
Search instead for 
Did you mean: 

Create query in hana studio

0 Kudos

How to create a query on the hana studio for the analysis office in this report form? Dimension: EMPLOYEE, 0CALMONTH KEYFIGURE: Revenue Variable: MONTH.YEAR: (input: 12.2018) I created two keyfigures as RevenueThisYear, RevenueLastYear by Restrist Revenue of variable input

Accepted Solutions (0)

Answers (1)

Answers (1)

deodutt_dwivedi
Active Participant
0 Kudos

Hi,

In a calculation view type cube, you can create 2 restricted measures/calculated columns (one for current year, another for previous year) based on expressions derived from month.year variable passed as an input parameter. Additionally you can restrict the data set at base projection to bring data for year(0calmonth) => (year(month.year) -1), this will bring the data for only current and last year.

Note - This is just a pseudo code for reference.

Regards,

Deo

Dear Deodutt Dwivedi,

I'm having problem about columns of RevenueThisYear is empty of RevenueLastYear and columns RevenueLastYear is empty of RevenueThisYear. Is there another way?

deodutt_dwivedi
Active Participant

Hi ,

In response to your comment, have you tried zero suppression in AO?

Edit1: Kindly replace NULLs with 0 in the expression where you have created your calculated measures.

Regards,

Deo