HI I have two dimensions, Ensys and CONTROLLER  and two measures KWH and Count(Site ID) .I want to unpivot both dimensions and measure values  as per below screenshot.Please let me know how to achieve.    

Hi , I have below requirementIf one customer have revenue for three months like Jan,Feb.Mar(Q1).Jan=100Feb=20Mar=30Sum of Jan +Feb+Mar=150This 150 value show in separate column to show 3 times in the report as below. I want to calculate the Ratio by ...

Hi,I have below Oracle Query and i want to convert the query to Spark SQL . Please let me know how to write Rownum condition in spark sql.Sample Oracle Query:selectpes.event_num,glp.period_name,(SELECT conversion_rate FROM gl_daily_ratesWHERE from_cu...

Hi,I want to calculate amount for selected quarter and previous  quarter using presentation variable.I have created presentation variable with quarter name and given default quarter is Q2/2024.Now I want to calculate amount for  Q2/2024 and Q1/2024. ...

Hi,Could you please someone explain me how "First Version" function works?Formula:sum(        firstVersion(            EBS_GL.GL_BALANCES.BEGIN_BALANCE_DR_BEQ - EBS_GL.GL_BALANCES.BEGIN_BALANCE_CR_BEQ,             EBS_GL.GL_BALANCES.CODE_COMBINATION_...