Default system month and year

[Former Member]

Hello Experts,

I am new to SAP BO Design Studio. I have been exploring it quite a bit but I am facing some challenge with one
issue. I will appreciate if anyone of you can assist me solving this issue.

Version: Design Studio 1.1 SP2
Data source: 1 x Bex query
Report Type: Bar Chart using for monthly analysis

Challenge: I am using DROPDOWN for default month/year but when I execute the report, DROPDOWN
is only showing the default value which I selected for the DROPDOWN items as default.

Business wants to see current month / year with current data when executing the
report. If they want to select another date then they can select from dropdown
to explore further for previous months / year report.


In the DROPDOWN_1 Item selection, I have selected year-month.

I am also using LISTBOX_1 which set to invisible and populating current date e.g 04/02/2014 just for me to check the feed from backend.

I have tried using the following script I on startup and DROPDOWN_1 Script but no luck.

On Startup:

POPUP_DISCLAIMER.show();

DROPDOWN_1.setSelectedValue(DS_1.getVariableValueExt("ZCURMTH"));

LISTBOX_1.setItems(DS_3.getMemberList("ZDATE",
MemberPresentation.TEXT, MemberDisplay.TEXT, 1));

TEXT_TIME_STAMP.setText("Data refreshed as of "+LISTBOX_1.getSelectedText());

On “DROPDOWN_1:

APPLICATION.setVariableValueExt("ZCURMTH",
DROPDOWN_1.getSelectedValue());

Display Items:

In the past, we have used this process with variables at back end and also with ABAP. But I would like to know if we can achieve this without ABAP or BW effort.

Thank you.

[Former Member · Accepted solution]

Hi,

Write following on Startup

var vDate = APPLICATION.getInfo().dateNowInternalFormat;

var vDay = Convert.subString(APPLICATION.getInfo().dateNowInternalFormat, 6,8);

vMonth = Convert.subString(APPLICATION.getInfo().dateNowInternalFormat, 4,6);

vYear = Convert.subString(APPLICATION.getInfo().dateNowInternalFormat, 0,4);

Then SetSelected in DropDownUsing month & year above.

[Former Member · Accepted solution]

Hi Nikhil,

Thank you for reply.

I have used your above script on startup.

"

var vDate = APPLICATION.getInfo().dateNowInternalFormat;

var vDay = Convert.subString(APPLICATION.getInfo().dateNowInternalFormat, 6,8);

vMonth = Convert.subString(APPLICATION.getInfo().dateNowInternalFormat, 4,6);

vYear = Convert.subString(APPLICATION.getInfo().dateNowInternalFormat, 0,4);"

What it did is showing "Fical Year Period" as display rather then current year/month.

How can I show current year/month from my values of Dropbox_1 as default value of current month.

Thanks.

[Former Member · Accepted solution]

Hi,

var vDate = APPLICATION.getInfo().dateNowInternalFormat;

var vDay = Convert.subString(APPLICATION.getInfo().dateNowInternalFormat, 6,8);

vMonth = Convert.subString(APPLICATION.getInfo().dateNowInternalFormat, 4,6);

vYear = Convert.subString(APPLICATION.getInfo().dateNowInternalFormat, 0,4);

DROPDOWN_1.setSelectedValue(vYear+"/0"+vMonth);

[Former Member · Accepted solution]

Thank you Nikhil,

It worked great really appreicate it.