cancel
Showing results for 
Search instead for 
Did you mean: 

Displaying current month in prompt

Former Member
0 Kudos

Hi,

I want to show the current month as the default value in Prompt in XI R3.1 Webi. i.e. when the user runs the report, the prompt for "Month" should show the current month (Say March) and if user wants to change it he can change it to someother month.

Pls let me know how to acheive this (May be by doing changes to report or to the Universe).

Regards

Jim

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

You can try the below step in Universe

Steps

1.You have a date time field = u201CDateXu201D

2.Build another object of the same field in unv = u201CDate X New Objectu201D

code:

case When to_date (Sysdate, "MM") then "Current Month"

end

3.Build Condition in Unv = Date Picker

code:

@Select(Cass\DateX New Object) = @Prompt(u2019Date Pickeru2019,'Au2019,{u2019Customu2019,'Yesterdayu2019,'Last 10 Daysu2019,'Todayu2019},mono,constrained,persistent,{u2019Current Monthu2019})

You can take reference of the below

http://www.dagira.com/2008/07/15/how-can-i-make-today-my-default-prompt-value/

Former Member
0 Kudos

Hi srrachna,

Is the code mentioned will show the actual day? I think it will show the hard coded value. Kindly clarrify.

Regards

Jim

Former Member
0 Kudos

This will show you the current date dynamically. when ever you run it with th value it will sho you that day data.

Though Current Day seems hard coded at first glance but we are poitning it to Sysdate in another variable. SO it will work for actual day.