Skip to Content

Passing Input Parameter from BEx via Composite Provider to Calculation View

Hi,

Issue:

Even though in RSRT, the FISCPER value of 2018001 seems to be passed correctly to the Input Parameter of Calculation View, there is no corresponding data in the Query Result.

Tests were performed both on existing CP and on a new CP built directly on the used CV.

Tested not only variable fetched by Customer Exit but also a constant e.g. 2018001.

Looking forward to your help.

Tests:

When opening the CV in DB, in Data Preview mode and putting in 2018001 as an Input Parameter, the result is displayed correctly.

When opening the BEx query, variable value seems to be passed OK but there is no result. "No applicable data found".

Scenario:

There is a CV1, It has a 0FISCPER input parameter mapped to CV2 and CV3 used as a sub-CVs.

CV1 is published in CP, the input parameter is mapped accordingly to BEx query and filled in customer exit.

CP:

BEx:

Thanks,

Sebastian

ss1.png (24.7 kB)
ss2.png (28.9 kB)
ss3.png (9.4 kB)
ss4.png (4.0 kB)
ss5.png (11.6 kB)
ss6.png (7.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • Best Answer
    Jan 04 at 02:55 PM

    Hi,

    The issue was with the AMOUNT type conversion.

    In CompositeProvider, there is a bug, direct conversion from (HANA) CalculationView Amount Filed type DEC17.2 to (BW) type CUKY17.2 is not supported. BW version: 7.50 on HANA.

    Previously it worked because OpenODS View was playing the HANA and BW middleman role.

    .

    The workaround, solution:

    Add CalculationView to dedicated CompositeProvider, do not assign any InfoObjects, make sure the type is as in the database (NUMBER, DEC17.2 for amount and CHAR5 for currency).

    Add CompositeProvider to another CompositeProvider, assign characteristics of BW types, enjoy correct results. BW-BW conversion works OK.

    .

    Useful links:

    https://launchpad.support.sap.com/#/notes/2228967

    https://launchpad.support.sap.com/#/notes/2198480

    https://wiki.scn.sap.com/wiki/display/BI/HANA+Analytics-API

    https://help.sap.com/viewer/52715f71adba4aaeb480d946c742d1f6/2.0.00/en-US/d5c8230abb571014acc592c2c96d92bd.htmlhttps://wiki.scn.sap.com/wiki/display/BI/VP+on+HANA%3A+Example+with+Input+Parameter

    https://answers.sap.com/questions/680852/values-is-not-passed-to-calculated-view-using-comp.html

    https://help.sap.com/viewer/04030263a0d041309a039fa3ea586720/7.4.19/en-US/bc90cda8dfa04937a4c2b3e85768dd78.html


    Kind regards,

    Sebastian

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03 at 07:24 AM

    Is the field in CP associated with 0FISCPER info object?

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03 at 08:18 AM

    I would suggest you to do the following (as a test):

    1. Associate the field with standard 0FISCPER IO in CP in output tab selecting "Usage of system-wide unique name"

    2. Create a hard coded restriction in BEX and see if it is passed to CV correctly (should be ok)

    3. If point 2 is ok then create a user exit with your logic

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Andrey,

      Thanks for your help. It did not help. I think by standard and in SAP help, the Input Parameter field is not supposed to be associated to any InfoObject.

      There might be a connection issue though. I've updated the post with a comment.

      Kind regards,

      Sebastian

  • Jan 03 at 09:17 AM

    Regarding "I think by standard and in SAP help, the Input Parameter field is not supposed to be associated to any InfoObject" - it is definitely supported and I use it widely (association of IO to input parameters).

    Regarding connectivity problems - unfortunately no idea :)

    Add comment
    10|10000 characters needed characters exceeded

    • See, thanks, thought so as once the 0FISCPER and 0FISCVARNT IOs were associated, compounded and restricted by 001.2018 constant (and not 2018001 like the format in DB) RSRT stops displaying any results and SQL trace has no value passed for input parameter field even though the default value in the DB is 2018001.

      From the other hand, when a field is used:

      the query outputs the values when a default parameter is set in the DB,

      The Query returns "No applicable data found" when a default value is removed.

      ss13.png (56.4 kB)
      ss14.png (4.1 kB)
  • Jan 03 at 11:43 AM

    Quite weird...

    I've reproduced your situation and got, as expected, correct results:


    parameters.png (19.1 kB)
    expression.png (8.5 kB)
    cp.png (29.5 kB)
    bex.png (5.8 kB)
    rsrt.png (6.3 kB)
    result.png (2.4 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03 at 03:19 PM

    I can't see you printscreens in the last response (seems like they weren't uploaded).

    Regarding your question - I don't work with CV via "HANA system attached to BW project in BW Modeling perspective".

    I work only via "Systems" tab and corresponding HANA system ("Repositories" tab for table functions/procedures).

    I tried to do it via "HANA system attached to BW project in BW Modeling perspective" - it doesn't work (preview) - gives error "Cannot get the data provider outline".

    But via "Systems" tab and corresponding HANA system it works fine.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Andrey,

      Could you please tell how do you set up the amount in BW and HANA?

      I identified that once the amount is added into the CP, it starts displaying no data.

      Once only the characteristics are there, they are being shown correctly.

      I have tried different semantic types, assigning different BW IO but nothing seems to help.

      Thanks

      Sebastian

  • Jan 03 at 08:43 AM

    As the comment 'Submit' does not work, pasting here.

    System Setup, as it might be the issue.

    As we had problems connecting HANA Source System to the BW project, a new system connection had to be created and set up in order to add HANA System and Log In to HANA System from BW perspective.

    BW perspective:

    Hana Modeler perspective, a system used in BW perspective shows "Server not compatible" in the HANA Modeler perspective.

    In result, there are two different systems connections available

    The two systems:

    1.Available from BW modeling and SAP HANA modeler perspective. Connected to the BW project. The modeling has not been done via that connection. Once opened from BW perspective, It displays warnings for the CVs and no Data Preview is possible.

    It is a temporary connection pointing the IP to the loadbalancer system.

    2.The one used for modeling, not linked to the BW system in BW Perspective. Data Display possible in HANA Modeler perspective, no warnings in CVs.

    1. When opening from a connected system from BW modeling, the following errors/warnings are displayed:

    2. There are no warnings and Data Preview is executed OK on the System that the modeling was done.

    Please mind once the Input Parameter was not there, the data from Calculation View was being displayed correctly. Could it be an issue with system connection that somehow it does not pass the value?


    ss9.png (20.3 kB)
    ss10.png (17.6 kB)
    ss11.png (157.5 kB)
    ss12.png (10.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03 at 04:49 PM

    Please find below with the snapshots. Thanks, think will try the alternative to update some ABAP parameter table and read in in CV.

    Thank you for your help, tried to replicate 1:1, changing Input Parameter from Column to Direct, adding Fiscal Variant, opening composite provider directly in RSRT, unfortunately, the same result.

    When doing the same in the Data Preview of Calculation View or with a default value set up:

    values are shown:



    ss16.png (36.4 kB)
    ss15.png (38.6 kB)
    ss17.png (9.0 kB)
    ss18.png (21.0 kB)
    ss19.png (12.1 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 04 at 07:50 PM

    Dear, Sebastian, All,

    A similar requirement like here In Bw on HANA system, How do we pass User Input parameter Date value for FROM Procedure/Function? thru BEx variable.

    We design same as you

    1. Created HANA View with Timeframe calculations like CYMTD, CYQTD, CYYTD, PYYTD, PYQTD, PYYTD etc...

    2. For HANA View User Input Parameter, Associate the field with standard IO in CP in output tab selecting "Usage of the system-wide unique name"

    3. After consuming Input parameter in BEx, assigned BEx VARIABLE restriction, Now HANA view was able to pass filters for the same parameter, However, for calculating FROM values the procedures were not able to capture User Input Parameter values, which is BEx variable in our case.


    capture1.jpg (19.3 kB)
    capture2.jpg (23.1 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Hi Suresh,

      To filter the data, you can create a calculated column,

      An example below would be for the first period of the year.

      leftstr('$$P_0FP_TO$$',4) + '001'<br>

      Dunno how about for the Procedure/Scalar Function.