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_...

Hi,I want to create a formula in business view to calculate last six months sum.Please let me know how to write formula.  

HI,I am getting below error in schema loads, i did full load for each schema but still getting the same error.Please let me know how to fix the issue.