Skip to Content

Values is not passed to calculated view using composite provider

Hello.

I have created a Calculated View with a parameter like this:

TEST.JBG/PR_CV_TEST_FILTRO

The parameter isn’t mandatory

I have checked the hana view and runs correctly:

I have created a Composite Provider with source the hana view previuos:

ZEJ_T_FILTER

When i try to execute the Composite Provider to get the data, i don’t get any record (the paramter is not passed to the calculated view).

I have create a bex query with the parámeter as input value with a bex variable and i don`t get any data.

ZEJ_TEST_FILTER

and with RSRT transacction i don't get records

I have chage the parameter to mandatory, when i try to execute the bex query or the composite, i get this error:

Becasuse the parameter is not passed to the Calculated View.

Kind regards

d1.png (133.8 kB)
d2.png (150.7 kB)
d3.png (74.2 kB)
d4.png (130.3 kB)
d5.png (125.8 kB)
d6.png (178.1 kB)
d7.png (46.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Nov 20, 2018 at 07:58 AM

    Hello.

    Finally, I has been solved the problem executing the step #12 of RS_BW_POST_MIGRATION ABAP report.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 09, 2018 at 02:23 AM

    Hello Javier,

    Could you check Note 2470783 and 2550684?

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Giselle.

      The note 2470783 is about SAPK-75009INSAPBW, i have this SP and the other (2550684) is about SAPK-75011INSAPBW.

      I will check with my system administrator to upgrade the system to this level package.

      Kind regards.

  • Nov 14, 2018 at 06:37 AM

    Hello Gonzalez,

    a) When you make the input parameter mandatory, this input parameter has to be mapped as a target field in the composite provider. You can see the input parameter in the source field list in the composite provider list. Map this input parameter to an Infoobject and You will have to create a variable for this infoobject and pass the value to get the desired BEx output.

    https://archive.sap.com/kmuuid2/e02f49dd-d74d-3010-30a7-e4e1d32178d3/How%20to..%20Consume%20HANA%20Models%20with%20Input%20Parameters%20in%20BW%20Virtual%20Providers

    b) Do not use an input parameter in the hana view. The bex variable directly should be able to filter the data at Bex level. The issue with this method is that there will not be any filters at Hana view level. View will bring the entire data and BEx will filter based on the variable passed. So you can expect delay if your hana view is on a huge table.

    c) There is also another indirect solution using ABAP tables as an input parameter. You need a customer exit BW variable to update the input value that you are giving to an abap table. The input parameter read this from the abap table and passed it to the hana view

    Regards

    Gajesh

    Add comment
    10|10000 characters needed characters exceeded

    • Hello.

      I have updated the system but the error hasn't been solved.

      About your points.

      A) This is the solution implemented.

      B) Yes, i epect a huge table and the results of the hana view is depending of the parámeters

      C) I will study this case if i don't find any other solution.

      Kind regards.