Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Fusion PayRoll
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

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:

 

https://<host:port>/analytics/saw.dll?bipublisherEntry&Action=schedule&itemType=.xdo&bipPath=%2FCustom%2FPractice%20Samples%2FEmployee%20Basic%20Detail%20Report.xdo&path=%2Fshared%2FCustom%2FPractice%20Samples%2FEmployee%20Basic%20Detail%20Report.xdo

 

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.

 


Ashish Harbhajanka

Comments   

0 #1 link osg777 online 2022-02-18 05:31
If you desire to improve your knowledge simply keep visiting
this site and be updated with the newest information posted here.
Quote
0 #2 osg 777 2022-02-26 08:33
Yes! Finally someone writes about osg777.
Quote
0 #3 osg 777 2022-02-26 17:51
I am not sure where you're getting your information, but great topic.
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.
Quote
0 #4 osg 777 2022-02-28 18:19
My brother suggested I might like this website. He was totally right.
This post actually made my day. You can not imagine simply how much time I had spent for this info!
Thanks!
Quote
0 #5 osg 777 2022-02-28 19:21
I do not know whether it's just me or if perhaps everyone else experiencing issues with your website.
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
Quote
0 #6 osg777 2022-03-11 02:43
When I originally commented I appear to have clicked on the -Notify me
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!
Quote
0 #7 alternatif osg777 2022-03-11 05:33
Magnificent beat ! I wish to apprentice whilst you amend your web site, how
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
Quote
0 #8 osg777 2022-03-12 03:24
We absolutely love your blog and find the majority of your
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!
Quote
0 #9 osg 777 2022-03-16 12:54
I am really enjoying the theme/design of your weblog.

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?
Quote
0 #10 osg777 2022-03-16 18:35
Great items from you, man. I have keep in mind your stuff
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.
Quote
0 #11 osg777 2022-03-19 12:05
Link exchange is nothing else but it is only placing the other person's
web site link on your page at proper place and other person will also
do same in support of you.
Quote
0 #12 osg 777 2022-03-19 13:28
Heya i am for the first time here. I found this board and I find It truly useful & it helped me out much.
I hope to give something back and help others like
you aided me.
Quote
0 #13 osg777 2022-03-24 03:01
I was recommended this blog by my cousin. I'm not sure
whether this post is written by him as nobody else know such
detailed about my problem. You are wonderful! Thanks!
Quote
0 #14 osg777 apk 2022-03-24 04:27
If you are going for best contents like myself, simply pay a
visit this web page all the time for the reason that it presents quality contents,
thanks
Quote
0 #15 osg 777 2022-03-24 04:47
It's a shame you don't have a donate button! I'd certainly donate to this
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!
Quote
0 #16 osg 777 2022-03-24 07:57
Hello to every body, it's my first pay a quick visit of this
weblog; this website consists of remarkable and genuinely excellent material for
visitors.
Quote
0 #17 osg777 2022-03-24 08:14
Undeniably imagine that that you stated. Your favourite reason seemed to be on the net the easiest factor to keep in mind of.
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
Quote
0 #18 osg 777 2022-03-24 08:53
A person essentially help to make critically articles I would state.
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!
Quote
0 #19 osg 777 2022-03-24 09:56
If you want to improve your know-how simply keep visiting this
web page and be updated with the newest information posted here.
Quote
0 #20 osg777 2022-03-24 10:03
If some one desires expert view concerning blogging and site-building then i suggest
him/her to pay a visit this blog, Keep up the fastidious work.
Quote
0 #21 osg777 2022-03-24 14:39
This web site really has all of the information I needed concerning
this subject and didn't know who to ask.
Quote
0 #22 osg777 2022-03-24 19:32
Fantastic web site. A lot of useful info here.
I am sending it to a few pals ans also sharing in delicious.
And of course, thanks to your effort!
Quote
0 #23 osg777 2022-03-25 05:07
I know this if off topic but I'm looking into starting my own weblog and was curious what all is required to
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
Quote
0 #24 osg777 2022-03-25 12:58
A motivating discussion is worth comment. I think that you need to write more on this subject, it may not be a taboo matter but typically
folks don't speak about these subjects. To the next! Best wishes!!
Quote
0 #25 osg777 2022-03-25 13:30
Does your blog have a contact page? I'm having problems locating it but,
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.
Quote
0 #26 osg 777 2022-03-25 16:24
What i don't understood is in truth how you're not actually much more neatly-favored
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!
Quote
0 #27 osg777 2022-03-25 16:27
Hey! I understand this is kind of off-topic but I had to ask.
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!
Quote
0 #28 live chat osg777 2022-03-25 17:59
magnificent publish, very informative. I wonder why the opposite
experts of this sector don't understand this.
You must proceed your writing. I am confident, you've a huge readers' base already!
Quote
0 #29 osg 777 2022-03-26 13:09
Thanks for sharing your thoughts about Oracle Fusion Financials.
Regards
Quote
0 #30 osg 777 2022-03-26 14:10
Appreciating the time and energy you put into your website and in depth information you present.

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.
Quote
0 #31 osg777 2022-03-26 17:29
What's up mates, how is everything, and what you want to say about this paragraph,
in my view its truly awesome for me.
Quote
0 #32 link taruhan osg777 2022-03-27 01:14
Hi! I just would like to offer you a big thumbs up for the great information you have here on this post.
I'll be returning to your blog for more soon.
Quote
0 #33 bandar osg777 2022-03-29 02:07
It's appropriate time to make some plans for the future and
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!
Quote
0 #34 osg777.net 2022-03-29 13:15
It's a shame you don't have a donate button! I'd certainly
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!
Quote
0 #35 live chat osg777 2022-03-30 03:10
This paragraph offers clear idea for the new users of blogging, that in fact how
to do blogging and site-building.
Quote
0 #36 osg 777 2022-04-02 04:55
magnificent points altogether, you just won a brand new reader.
What could you suggest in regards to your submit that you just made a
few days in the past? Any certain?
Quote
0 #37 osg 777 2022-04-27 01:10
If some one desires expert view concerning blogging and site-building afterward
i advise him/her to pay a quick visit this web site, Keep up the fastidious job.
Quote
0 #38 osg777 2022-05-11 20:00
With havin so much written content do you
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.
Quote
0 #39 osg777 2022-06-05 02:56
Hi to every single one, it's genuinely a nice for me to pay a visit this
web site, it consists of helpful Information.
Quote
0 #40 osg 777 2022-06-17 05:51
What's up mates, how is the whole thing, and what you want to say on the topic of this
piece of writing, in my view its actually amazing designed for me.
Quote

Add comment


Security code
Refresh

About the Author

Ashish Harbhajanka

 

Oracle Fusion HCM Techno Functional Consultant with overall 10 years of Experience in software industry with 5 years in EBS HRMS and rest 5 in Fusion HCM.

My areas of intesrest in Fusion HCM include :

a) Inbound Outbound Integration using FBL/HDL or BIP/HCM Extracts.

b) Fast Formula

c) BIP Reports

d) OTBI Reports

e) RESTFUL API / Web Service Call

f) Functional Setup

g) End to End Testing

h) Regression Testing

i) Preparing COnfiguration Workbooks

j) Creating Speed Solutions

k) Preparing User Guides

l) UPK

........

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Mar 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8  910
11121314151617
18192021222324
25262728293031

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner