Business Requirement
It is a common requirement to have a Date Parameter in Reports. Things become difficult if the Report is an OTBI report, and the expected Date Parameter is Date Picker. By default, what we get is a text field in which we need to ensure that the user input is exactly as expected by the program (generally we guide the user via a tooltip). But, for now, we have a workaround explained next.
By default whenever you create a presentation variable it gives 5 options for user input.
But the requirement is to have 'Calendar' as a value in a dropdown list.
Steps:
-
Select the Choice List Option:
-
In 'Choice List Values' select 'All Column Values'
-
Now select any attribute from the Subject Area of Date Type. For this example, let us choose Start Date from Person Folder (Workforce Management – Person Real Time). Choose Variable Data Type as 'Date':
-
Click on OK.
-
Edit the prompt again and 'Calendar' now appears as a User Input in the dropdown list:
-
Save the changes.
-
The Date Picker appears as desired.
It is a common requirement to have a Date Parameter in Reports. Things become difficult if the Report is an OTBI report, and the expected Date Parameter is Date Picker. By default, what we get is a text field in which we need to ensure that the user input is exactly as expected by the program (generally we guide the user via a tooltip). But, for now, we have a workaround explained next.
By default whenever you create a presentation variable it gives the following options for user input:
But the requirement is to have 'Calendar' as a value in a dropdown list.
Steps:
-
Select the Choice List Option:
-
In 'Choice List Values' select 'All Column Values':
-
Now select any attribute from the Subject Area of Date Type. For this example, let us choose Start Date from Person Folder (Workforce Management – Person Real Time). Choose Variable Data Type as 'Date':
-
Click on OK.
-
Edit the prompt again and 'Calendar' now appears as a User Input in the dropdown list:
-
Save the changes.
-
The Date Picker appears as desired.
Comments
to find out about this topic. You understand so much
its almost hard to argue with you (not that I personally would want to…HaHa).
You certainly put a new spin on a topic which has been discussed for years.
Wonderful stuff, just excellent!
my web page Poker stars: https://Freestyler.ws/forum/discussion/1851584/im-happy-i-finally-registered
expеrience. thanks admin
Here iis myy blog :: jasaƅet777: https://Www.Groovelineentertainment.com/blog/272038/promote-your-enterprise-and-products-through-marketing-with-articles-to-top/
The sketch is tasteful, your authored subject matter stylish.
nonetheless, you command get got an shakiness over that you wish bbe delivering the following.
unwell unquestionably come further formerly again since exactly the same nearly very
often inside case you shield this hike.
Visit my web blog :: REVs Check: https://aucn.net.au/australian-car/cam/revs-check.html
Regards
Also visit my web site; PPSR Check: https://aucn.net.au/australian-car/cam/ppsr-check.html
What could you suggest about your put up that you simply made a
few days ago? Any certain?
of writing at this web page.
mind that how a user can understand it. So that's why this piece of writing is great.
Thanks!
to and you're simply too great. I actually like what you have acquired here, really like what you are stating and the best way during which you say it.
You make it enjoyable and you continue to care for to stay it smart.
I can't wait to learn far more from you. That is actually a
terrific web site.
I like what I see so now i am following you.
Look forward to finding out about your web page again.
my breakfast coming yet again to read more news.
the users to visit the site, that's what this site is providing.
awesome for people experience, well, keep up the good work
fellows.
you, However I am encountering troubles with your RSS.
I don't understand why I cannot join it. Is there anybody
else having identical RSS issues? Anyone that knows the answer
will you kindly respond? Thanks!!
you made blogging look easy. The whole glance of your website
is excellent, let alone the content!
is a enormous source of facts.
Please stay us up to date like this. Thank you for sharing.
What host are you the use of? Can I am getting your affiliate link for your host?
I desire my website loaded up as fast as yours lol
for ones time for this fantastic read!! I definitely really
liked every little bit of it and I have you saved to fav to
check out new stuff in your website.
It's always useful to read articles from other writers and practice something from their
web sites.
get a lot of spam responses? If so how do
you protect against it, any plugin or anything you can recommend?
I get so much lately it's driving me insane
so any assistance is very much appreciated.
visiting this web page and reading very informative articles at this
time. save refuges: https://www.aid4ue.org/about/
he must be pay a visit this site and be up to date all the time.
right now. (from what I've read) Is that what you're using on your blog?
incredibly slow for me. Is anyone else having this issue or is it a issue on my end?
I'll check back later on and see if the problem still exists.
it up! I'll go ahead and bookmark your website to come back later.
Many thanks
you using? Can I get your affiliate link
to your host? I wish my website loaded up as fast as yours lol
proportion we communicate more approximately your
article on AOL? I need an expert in this house to unravel my problem.
Maybe that is you! Having a look forward to see you.
this post was good. I don't know who you are but definitely you're going to a
famous blogger if you are not already ;) Cheers!
with us so I came to check it out. I'm definitely loving the information. I'm book-marking and
will be tweeting this to my followers! Superb blog and excellent design and style.
to find quality writing like yours these days.
I really appreciate people like you! Take care!!
searching for a comparable subject, your web site got here up, it looks great.
I've bookmarked it in my google bookmarks.
Hi there, simply was alert to your weblog via Google, and located that it's truly informative.
I am going to be careful for brussels. I'll appreciate in the event you proceed this in future.
Numerous folks will likely be benefited from your writing.
Cheers!
because i love to learn more and more.
great author.I will remember to bookmark your blog and will
eventually come back from now on. I want to encourage you
to continue your great posts, have a nice holiday weekend!
and now this time I am browsing this site and reading very informative articles or reviews here.
you made blogging look easy. The overall look of your web site is magnificent, let alone the content!
precisely what I'm looking for. Would you offer guest writers to write content for yourself?
I wouldn't mind creating a post or elaborating on a lot of the subjects you write about here.
Again, awesome web log!
and in accession capital to say that I acquire actually enjoyed account your
blog posts. Anyway I'll be subscribing for your feeds or even I success you access
constantly quickly.
propose him/her to pay a quick visit this website, Keep up the good job.
I wonder how so much attempt you place to create any such great informative web site.
He was totally right. This post actually made my day.
You cann't imagine just how much time I had spent for this
information! Thanks!
You have some really great posts and I feel I would be a good asset.
If you ever want to take some of the load off, I'd absolutely love to write some articles for
your blog in exchange for a link back to mine.
Please blast me an email if interested. Thank you!
with us so I came to look it over. I'm definitely loving the information. I'm
bookmarking and will be tweeting this to my followers!
Great blog and brilliant design.
is added I get three e-mails with the same comment. Is there any way you can remove people from that service?
Many thanks!
with us. Please stay us up to date like this. Thank you for sharing.
see this web page everyday because it offers quality contents, thanks
a very easy on the eyes which makes it much more enjoyable for me to come here and visit more
often. Did you hire out a developer to create your theme?
Superb work!
Brief but very precise information… Thank you for sharing this
one. A must read post!
Data Type for a Presentation Variable in OTBI Analysis | Date Variable in OTBI
be okay. I'm definitely enjoying your blog and look forward
to new posts.
Your writing taste has been amazed me. Thank you, very great post.
comment is added I get four e-mails with the same comment.
Is there any way you can remove me from that service? Thanks a lot!
Thank you! Where are your contact details though?
useful data, thanks for providing these kinds of statistics.
and now this time I am visiting this website and reading very informative articles or reviews
here.
benefit from it I am sure.
this subject. I really like all the points you've made.
any problems of plagorism or copyright violation? My blog has a lot of unique content I've either authored myself or outsourced but it appears a
lot of it is popping it up all over the internet
without my permission. Do you know any solutions to help
prevent content from being ripped off? I'd truly appreciate it.
I am slightly sure I will be informed many new stuff proper
right here! Good luck for the following!
made.
design. Superb choice of colors!
I'll bookmark your blog and take the feeds additionally?
I am glad to search out numerous useful information right here within the publish, we want work out extra strategies on this regard, thanks for sharing.
. . . . .
to find things to improve my web site!I assume its good enough to make use of some
of your ideas!!
daughter and said "You can hear the ocean if you put this to your ear." She placed the shell to her ear and screamed.
There was a hermit crab inside and it pinched her
ear. She never wants to go back! LoL I know this is totally off topic but I had to tell someone!
visit this web page every day since it provides feature
contents, thanks
time I am visiting this web page and reading very
informative content here.
effort to make a superb article… but what can I say… I hesitate a whole lot and never manage to get
anything done.
And i am satisfied reading your article. But wanna remark on few common issues, The website style is ideal, the
articles is actually excellent : D. Excellent job, cheers
Very useful info particularly the closing section :) I deal with such information a lot.
I used to be seeking this certain information for a long time.
Thanks and best of luck.
you once again.
wp themes: http://onthegofinishingpowder.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
wordpress themes: http://steeleconsulting.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
time and actual effort to make a great article… but what
can I say… I hesitate a lot and never manage to get anything done.
am going to deliver in school.
RSS feed for comments to this post