Skip to Content
0

SAP BO 4.2 webi scheduling dynamic prompt

Mar 17, 2017 at 05:42 AM

332

avatar image

prompt.png

Hi All,

In Bex default date is set to current date.

But while scheduling Webi, in CMC I am not getting the current date as default date.

Every time i have to select Today's date. Dynamic value radio button option is selected but seems that it only works if back end is universe. Does it work if source data comes directly from Bex?

Find the attached file.

prompt.png (34.0 kB)
10 |10000 characters needed characters left characters exceeded

Hi,

Variables configured in Default values panel in BEx query will leverage from version 4.1 and you are on 4.2.. so that should work.

Try putting this variable in characteristic restrictions panel if you want to filter in WebI.

Do you have a customer exit variables in BEx?. BICS should support those too.

Thanks,

Jothi

0

Hi Jothi,

In BEX we are using formula variable processed by Customer Exit.

0

Hi,

Can you try Purging the last refreshed values and schedule report.

Here is the link that can give you more details.

https://archive.sap.com/documents/docs/DOC-62160

Thanks,

Jothi

0

Hi Devanshi Prajapati,

You can resolve this problem? I'm with same error.

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Erdem Pekcan Jun 30, 2017 at 07:05 AM
0

Hi Devanshi,

You need a "magic date" for this scenario. You have to schedule with a date like "31.12.9999" and then in customer exit process this date and convert to your dynamic date (e.g. sy-datum). You need a dummy variable for user input and then a second variable to process it.

You can find an explanation here : http://www.dagira.com/2008/07/21/using-a-magic-date-value-in-prompts/

Regards,
Erdem

Share
10 |10000 characters needed characters left characters exceeded