On January 27th, this site will be read-only as we migrate to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,579 Users
  • 2,269,760 Discussions
  • 7,916,784 Comments

Discussions

How Discoverer decodes the EXP_FORMULA1 in eul5_expressions table?

1. In one of the folders, I have defined an item using a functions like

STDDEV(4) KEEP(DENSE_RANK FIRST ORDER BY  Invoice_Id ) OVER(PARTITION BY Invoice_Num )

2. This expression is stored in table EUL5_EXPRESSIONS in EXP_FORMULA1 column as

[1,225]([1,243]([5,2,"4"]),[1,226]([1,227](),[1,139]([1,140]([6,302815]))),[1,252]([1,138]([6,302816])))

3. When I decode this, I get the output

KEEP(STDDEV2(4),KEEPCOMPONENT(DENSERANKFIRST(),ORDER(NPASSORDERCOMP(INVOICE_ID))),OVER(PARTIION(INVOICE_NUM)))

which is not exactly what I have defined in point1. Is there anyway to decode point2 to get what's there in point1. How Discoverer decodes it?

This discussion has been closed.