Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

lead function equivalent in bods

All,

This snippet of code is part of the HANA mini-checks and we want to use it in a bods df, however we are against copying sql into a bods sql window and launching it, so we would like to use the bods sources, transforms, etc. so we get good advantage of the push-down functionality.

Additionally we have told our developers not to use the sql window either so I'd like not to break any rules we created.

Here is the sql snip:

SELECT   'COLUMN' AREA, 

SERVER_TIMESTAMP, 

SCHEMA_NAME, 

TABLE_NAME DETAIL,  

PART_ID,   HOST, 

PORT, 

RECORD_COUNT NUM_ROWS, 

MEMORY_SIZE_IN_TOTAL ALLOC_BYTE, 

MEMORY_SIZE_IN_TOTAL USED_BYTE, 

MEMORY_SIZE_IN_MAIN MAIN_BYTE, 

MEMORY_SIZE_IN_DELTA DELTA_BYTE, 

GREATEST(0, MERGE_COUNT - LEAD(MERGE_COUNT, 1) OVER     (PARTITION BY SCHEMA_NAME, TABLE_NAME, PART_ID, HOST ORDER BY SERVER_TIMESTAMP DESC)) MERGES

FROM   _SYS_STATISTICS.HOST_COLUMN_TABLES_PART_SIZE CT

So that lead function I need to remediate it in BODS.

Anyone familiar with how it should be remediated?

Thanks for your review.

Mike

Former Member
Not what you were looking for? View more on this topic or Ask a question