Skip to Content

How To Catch .Dateinfo() On Variable Initialization ?

Hello Folks,

I am trying to by-pass Mandatory Bex Prompts.

I dont want the hard-coded date to be pass from Global Script Variables and calling it at variable Ini..event for a simple reason, that date will be a passed date if i run the dashboard anytime after the given hard-coded date.

Challenge ?

Application.getinfo(date);

is not available On Variable Initialization EVENT.

Some thoughts?

Do you think it would be a good idea to pass hard-coded 10 to 11 months or some years in advance ? Design Studio will not return any record and will only retrieve latest and great data available

Appreciate your suggestion and recommendation like always.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Dec 09, 2016 at 08:15 AM

    Hi Mohd,

    In addition to Tammy's suggestion you could also try coming up with a logic on the query exit. For example using a moving range starting at a particular date depending on today etc which is evaluated on the backend during runtime dynamically.

    Another line of thought would be loading the query in scripting so that you have all Design Studio scripting methods available.

    For example in event On Startup: DS_1.loadDataSource(); DS_1.setVariableValueExt("variable_name", "value");

    Kind regards

    Martin

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Mohd,

      Yes, that is what I meant in the end. Good to know that this worked out for you. I would stringly recommend to update eventually.

      Happy Holidays to you too and please flag correct answers.

      Kind regards

      Martin

  • Dec 09, 2016 at 12:30 PM

    Hi Mohd,

    If the variable needs to be Mandatory, you can set default value for the variable in BW.

    You can always set current date as default value to the variable, So you don't have to pass it in dashboard.

    Thanks,

    Poovarasan

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 08, 2016 at 08:34 PM

    The easiest way is to make the mandatory BEx prompts optional in the BEx query - is that an option for you?

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11, 2017 at 02:11 PM

    thanks everyone for your sugestions

    Add comment
    10|10000 characters needed characters exceeded