Skip to Content
0
Apr 14, 2014 at 03:52 PM

Pass BODS job parameters as HAVA View parameters

552 Views

Hi experts,

I use HANA Calculation View as Data Source and need to pass BODS job's parameters into Calculation View parameters. I have tried to use SQL Transformation with code like this (see below) but it doesn't work.

select RRCTY, RYEAR, FISCAL_PERIOD as POPER, FISCAL_YEAR_PERIOD, RBUKRS, RACCT, RCNTR, WBS, RZZPERNR, PLEVEL, ROW, MEASURE, REP_ID

from SOURCE_1.DIM_EMPLOYEE as emp

inner join "_SYS_BIC"."packeage/CalcView" (PLACEHOLDER."$$IP_SNAPSHOT_TIMESTAMP$$" => {$IP_SNAPSHOT_TIMESTAMP}, PLACEHOLDER."$$IP_REP_ID$$" => {$IP_REP_ID}) as mce1

on emp.EMPLOYEE_CHAR = mce1.RZZPERNR

How can I pass job parameters into HANA Calculation View from BODS?

Thank you!

--

With best regards,

Sergey