How to add a parameter which is a formula

[Former Member]

We have a formula to get the sales rep (called the corrections rep) and would like to offer this a param if the user only want to see and process their own

records. how to make this as a param?

this is the formula

(

SELECT

    {fn REPLACE(MYDTA.REFER1.RFDTA,'0000000' ,'' )}

FROM

    MYDTA.REFER1

WHERE

        MYDTA.REFER1.RFCAT = '0025'

    AND MYDTA.REFER1.RFSQ2 = '1'

    AND MYDTA.REFER1.RFSLC = "OEORH41CD"."OHSLR#"

)

[abhilash_kumar · Accepted solution]

Hi Paul,

You cannot create parameters on formula fields or SQL Expression fields.

You would need to get the RFDTA field (with the where clause) as part of the Command Object or View.

-Abhilash

[Former Member]

Hi Paul,

If you have installed BOE or CRS then you can use the BVM client tool to create a LOV. This LOV can be used across reports to get 'Sales rep' prompt.

The Data Foundation of the Business View can be based off a Command Object SQL that you have given.

Please look at the Business View Manager(BVM) user guide here:

https://help.sap.com/businessobject/product_guides/boexir31/en/xi3-1_bv_admin_en.pdf?xyzallow

-Prathamesh

[Former Member]

Another option would be to use a main report to get the RFDTA via Command object SQL as Abhilash suggested and create a parameter inside the main report.

Now, the report which requires this prompt can be embedded into the main report as a sub report and linked on the parameter from the main report.

-Prathamesh