Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.6K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
How Discoverer decodes the EXP_FORMULA1 in eul5_expressions table?

3521254
Member Posts: 2
in Discoverer
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?
Tagged:
This discussion has been closed.