cancel
Showing results for 
Search instead for 
Did you mean: 

How to transfer variables from BOBJ to CV

Former Member
0 Kudos

Our situation

Webi

   |

Universe

  |

Calc Views

In our CV we use complex logic:

var_eban = CE_COLUMN_TABLE("ECC"."EBAN");

var_mseg=...

var_out=....

If I understand correctly when we use filter in BOBJ(which generate SQL:  select "BANFN","MENGE" from "SYS_BIC/CV1" when "BANFN"=input from user) CV read all information from all BANFN .And only after this system run our filter on one banfn. It's too long.

Any chance to transfer information from BOBJ 4 selection screen to CV logic, for examle to var_eban. I want to run CV only on one banfn but not on all.

Accepted Solutions (0)

Answers (1)

Answers (1)

hai_murali_here
Advisor
Advisor
0 Kudos

Hi llya,

You cant consume the variables created in HANA Studio in any of the clients tools(including Universe) and also in the reverse way as of today.

As you said,if you define your filter(as LOV,Prompt or constant) in Universe,the entire data set will be fetched to semantic layer and then only the filtering will happen which is again performance issue.

If you create a variable in CV itself and then consume in Universe,the filtering will happen in DB layer itself.Unfortunately,the variables created in CV are not exposed in Universe which may be supported in the upcoming version of SAP HANA.

Rgds,Murali