Introduction
In one of the previousarticle we have seen how to run a run a Cloud BI Report by a simple click on Springboard Icon. But that particular example would work only for reports which does not needs any user input (commonly referred to as a parameter) required. The user clicks on the icon and the report data is displayed. However, not all reports work that way. Some or probably most of them need one or more parameters. In this article we will try to demonstrate how to run a parameterized report from a Navigator Menu Link or from the springboard icon.
A user should have access to “Structure” Menu Link in order to perform ths activity. Appplication Implementation Administrator role has access to “Structure”
So let’s get started.
Worked Out Example
As a first step we would need to create a parameterized BI Report and verify that the report works fine from the BI catalog. For this example we have taken a report titled “Employee Basic Detail Report” and have verified that the report does works fine from the BI Catalog Area.
As a next step we would need to select the “Employee Basic Detail Report” from the BI Catalog Area and click on More->Schedule Option as shown
Once we click on the Schedule Link it would take us to a new screen. We would need to copy the Web-page link from the address bar and keep it in some text editor (this would be used in next steps).
The page link would appear as:
The actual link has been changed (to ensure confidentiality is maintained). One would have a separate Host and Port details for his/her environment. Also notice that the Action should have a value of schedule
Now as a next step we would need to activate a sandbox and create a new category. Details used are below:
Create New Category |
|
Attribute Name |
Attribute Value |
*Name |
One-Click Parameterized Reports |
Icon |
<any available icon from the search pane> |
Navigator |
Yes |
The details when captured in screenshot would appear as below:
Similarly, we would need to create a New page too. We would need the following details:
Create New Page |
|
Attribute Name |
Attribute Value |
*Name |
Employee Basic Detail Report |
*Icon |
<any available icon from the search pane> |
Category |
One-Click Parameterized Reports |
Navigator |
Yes |
Springboard |
Yes |
Link Type |
Static URL |
Secure Destination |
Unchecked |
*Destination |
<page-link captured in editor in previous steps> |
The details when captured in screenshot would appear as below:
Once we are done we can click on “Save and Close”. We would be able to see the link on the Navigator Menu as shown:
We would also be able to view the link on the springboard too:
Verification
One may choose either of the Navigator Menu or the Springboard Icon and once we click on them we would be taken to the schedule page where from we can pass the parameter values (Person Number as ‘All’) and submit the job as shown:
Similarly, we can again click on either of the Navigator Menu Link or Springboard Icon and pass a specific person number value (100053 for this example) and submit the job:
We would now go to “Job History” and we should be able to see the details of the job submitted
And once we click on “Run1_All’ (the job name submitted with Person Number parameter value as ‘All’) we would view the below output:
And similarly, if we click on “Run2_100053” (the job name submitted with person number as 100053) we would view the following output:
Inference / Summary
So this is how we can run parameterized reports from navigator menu link or springboard icon. While we have used only one parameter for demonstration one may try with multiple parameters too and I am sure it would work fine too.
And with this I have come to an end of this article. Hope this was informative and would help you guys in your projects.
That’s it from my side, have a nice day ahead.
Comments
this site and be updated with the newest information posted here.
I needs to spend some time learning much more or understanding more.
Thanks for wonderful information I was looking for this info for my mission.
This post actually made my day. You can not imagine simply how much time I had spent for this info!
Thanks!
It looks like some of the text in your content are running off the screen. Can someone else please comment and let me know
if this is happening to them as well? This could be a problem with my web browser because I've had this happen before.
Thank you
when new comments are added- checkbox and from now on whenever a comment
is added I receive four emails with the exact same
comment. There has to be a means you can remove me from that service?
Thanks a lot!
can i subscribe for a blog web site? The account
aided me a acceptable deal. I had been tiny bit acquainted of this your broadcast provided bright clear idea
post's to be just what I'm looking for. Do you offer guest writers to write content for you?
I wouldn't mind publishing a post or elaborating on a lot
of the subjects you write regarding here. Again, awesome site!
Do you ever run into any internet browser compatibility problems?
A few of my blog audience have complained about my blog
not operating correctly in Explorer but looks great in Chrome.
Do you have any advice to help fix this problem?
previous to and you're simply extremely fantastic.
I really like what you've bought here, certainly like
what you're saying and the way in which by which you assert it.
You're making it enjoyable and you continue to care for to keep it smart.
I cant wait to learn much more from you. This is really a terrific website.
web site link on your page at proper place and other person will also
do same in support of you.
I hope to give something back and help others like
you aided me.
whether this post is written by him as nobody else know such
detailed about my problem. You are wonderful! Thanks!
visit this web page all the time for the reason that it presents quality contents,
thanks
excellent blog! I guess for now i'll settle for book-marking and adding your RSS feed
to my Google account. I look forward to brand new updates and will share
this website with my Facebook group. Talk soon!
weblog; this website consists of remarkable and genuinely excellent material for
visitors.
I say to you, I certainly get annoyed whilst
other people think about worries that they plainly don't recognise about.
You managed to hit the nail upon the highest and outlined out the entire thing
without having side effect , people could take a signal.
Will likely be again to get more. Thanks
This is the very first time I frequented your web page and up to now?
I surprised with the analysis you made to make this particular
post extraordinary. Magnificent process!
web page and be updated with the newest information posted here.
him/her to pay a visit this blog, Keep up the fastidious work.
this subject and didn't know who to ask.
I am sending it to a few pals ans also sharing in delicious.
And of course, thanks to your effort!
get set up? I'm assuming having a blog like yours would cost a
pretty penny? I'm not very web savvy so I'm not 100% certain. Any tips or advice would be greatly
appreciated. Appreciate it
folks don't speak about these subjects. To the next! Best wishes!!
I'd like to send you an email. I've got some recommendations for your
blog you might be interested in hearing. Either way, great site and
I look forward to seeing it expand over time.
than you may be now. You are so intelligent. You already know
thus significantly relating to this subject, produced me in my
opinion believe it from so many various angles. Its like women and men don't seem to be involved unless it's something to accomplish
with Woman gaga! Your individual stuffs outstanding.
Always handle it up!
Does operating a well-establishe d blog like yours take a large amount of work?
I am completely new to operating a blog however I do write
in my journal everyday. I'd like to start a blog so I will be able to
share my personal experience and thoughts online. Please let me know if you
have any recommendations or tips for brand new aspiring blog owners.
Appreciate it!
experts of this sector don't understand this.
You must proceed your writing. I am confident, you've a huge readers' base already!
Regards
It's awesome to come across a blog every once in a while that isn't the
same old rehashed material. Great read! I've saved your site and I'm including your RSS feeds
to my Google account.
in my view its truly awesome for me.
I'll be returning to your blog for more soon.
it's time to be happy. I have read this post and if I could I desire to suggest you some interesting things or suggestions.
Perhaps you could write next articles referring
to this article. I wish to read even more things about it!
donate to this brilliant blog! I suppose for now i'll
settle for book-marking and adding your RSS feed to my Google account.
I look forward to new updates and will share this website with
my Facebook group. Chat soon!
to do blogging and site-building.
What could you suggest in regards to your submit that you just made a
few days in the past? Any certain?
i advise him/her to pay a quick visit this web site, Keep up the fastidious job.
ever run into any problems of plagorism or copyright violation? My website has a lot
of completely unique content I've either written myself or outsourced but it seems a lot of it is popping
it up all over the internet without my permission. Do you know any techniques
to help protect against content from being ripped off?
I'd really appreciate it.
web site, it consists of helpful Information.
piece of writing, in my view its actually amazing designed for me.
RSS feed for comments to this post