Skip to Content

Input parameter with Derived From Procedure for MTD, QTD, YTD calculations thru BEx Variable?

Dear, All,

In Bw on HANA system with a Calculation View:

We have created a Calculation view with lots of Timeframe calculations like CYMTD, CYQTD, CYYTD, PYYTD, PYQTD, PYYTD etc...And this Calc View has been consumed into Composite provider & created a Bex Query on top of it. In order to capture user Input Parameter value, BW info object has been associated with an Input parameter also BEx Variable has been assigned.

However, In Calculation view, the Derived from a procedure was not receiving any value thru BEx variable?

It works for the Direct Input parameter restriction, but not getting passed to the procedure.

Thanks in advance!!!

capture3.jpg (51.2 kB)
capture1.jpg (19.3 kB)
capture2.jpg (23.1 kB)
capture4.jpg (15.6 kB)
capture5.jpg (40.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 08 at 08:32 AM

    Hi,

    Did you try to look at the bex query in rsrt - to see HAHA SQL statement?

    Does the query send any value in parameter object?

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Andrey,

      Thanks for the reply!!!

      I see that it is passing to parameter object for testing, I created a restricted column measure and applied the same Input parameter in Calc view and it works very well. However, not passing to derived procedures??

      By the way, If I consume the same calc view directly thru Bex Query with no Composite provider ALL FILTERS WORK VERY WELL with no special care. But We need this thru Composite provider so that we can utilize BW Hierarchies.

      Here is the screenshot that I see in RSRT. Any more suggestions would be really helpful, please.

      capture-06.jpg (22.2 kB)
  • Jan 10 at 08:38 AM

    Unfortunately I'd suggest to open OSS ticket...

    Add comment
    10|10000 characters needed characters exceeded