Dashboards & Analytics Discussions
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Row Number in Spark SQL MV

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

KHK_0-1737382559224.png
KHK by Partner
  • 450 Views
  • 2 replies
  • 0 kudos

Presentation Variable for Quarter

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

KHK_0-1736319658544.png
KHK by Partner
  • 316 Views
  • 1 replies
  • 0 kudos

Running totals

I've created an aggregate dashboard with attached layout (linked to JDE). The business wants to see the individual transaction with qty and amounts as well as having a running total column against each of the respective records. This is to assist in ...

First Version

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

KHK by Partner
  • 376 Views
  • 1 replies
  • 0 kudos