$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: false, vro: false, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content
-1

Dynamic filter in scripted CV HANA

Mar 09, 2017 at 09:03 PM

43

avatar image

How to get this working using APPLY_FILTER...

[‎********* Begin Procedure Script ************/ BEGIN DATA_SET=APPLY_FILTER("_SYS_BIC"."XA_UTC.XXX/CA_ABC_CUBE_T_EXPOSURE", :FILTER_EXP) ; var_out = SELECT XC_ABC_KONZXXX,RANK FROM (select CC_ABC_KONZS,C_FTGGF, RANK() over (order by CM_ABC_EXPOSURE_TXN_AMOUNT DESC) AS RANK FROM "_SYS_BIC"."XA_CTC.XXXT/VVV" --WHERE CC_ABC_RECORD_TYPE_CODE='Q' --AND "CC_ABC_CALQUARTER_YYYYxQ"='2016Q4' --AND LAND1_1='AU' --AND CC_ABC_PR_ID='Aluminium' ) WHERE RANK<=10;

END /********* End Procedure Script ************/

we want the highlighted part to be passed through input parameter and we need to run the inner SELECT(with rank()) on top of apply_filter result set.

SQL
10 |10000 characters needed characters left characters exceeded

There's no highlighting in your question, so I've no idea, what you are asking.

Also, please be more specific about your problem. Do you get error messages or wrong results or what?

Your table variable DATA_SET doesn't seem to be used anywhere - what is it for in your code?

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers