Skip to Content

Is there a RANK() function available at BOC level?

Hi,

Suppose we have a set of dimensions and measure displayed against it. IF we wish to rank the rows accordingly & display it. Can someone guide if RANK function is available at BOC level or how to implement the same?

Regards,

Kiran Shenvi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 11, 2017 at 07:41 PM

    Hi Kiran,

    Sorry there is no RANK function in regards to calculated measures.

    The story calculation editor only supports the following aggregation functions:

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 23, 2017 at 02:33 PM

    Hi John,

    I was trying to work within our environment where we have a LIVE Data Connection with HANA Database and a model associated with it.

    When I was trying to consume this model in my story and create a new calculation

    it doesn't show the types -> Aggregation and Difference From in the dropdown.

    Can you please confirm if this is a known limitation or some issue?


    Regards,

    Kiran Shenvi

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Kiran,

      Correct that's a limitation. The option to create a new calculation may not appear if calculations are not possible for the chart type or model.