title: OBIEE TOPN Display Function
body: <p>How does TOPN Display function in OBIEE work? And how can I do it with SQL Server?</p>
  
  <pre><code>where TOPN(N,10) &lt;= 10)
  </code></pre>
  
  <p>This is my query</p>
  
  <pre><code>SELECT
    N,
    SUM(column),
    REPORT_SUM(SUM(column) BY N)
  FROM 
    TABLE
  WHERE
    (TOPN(N,10) &lt;= 10)
  </code></pre>