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

I assume most of us are aware that we may use the COUNT(<unique_attribute>) expression in either the SQL query or the BI Template to display the Total Number of Records fetched by the SQL query in a BI Report. Things however are not that simpler if one tries to display the same in an OTBI Analysis. One needs to perform a series of steps to achieve this.Also we would try to display current logged in username along with currentdate and currenttime.

On a high level the steps are:

  1. Add a custom attribute to get MAX(RCOUNT(1)) in the OTBI Analysis

  2. Add a custom attribute to get username using USER() function

  3. Add a custom attribute to get currentdate using CURRENT_DATE function

  4. Add a custom attribute to get currenttime using CURRENT_TIME function

  5. Add a Narrative View and choose explicit settings in the same (described in detail in this article later)

Add Custom Attribute MAX(RCOUNT(1))

We already have a custom report created and we would just add the MAX(RCOUNT(1)) field in the analysis.

One additional thing one should make note is the column sequence (at which place of the OTBI Analysis have we placed the column).

Means if I have two columns say personnumber and MAX(RCOUNT(1)) and I have placed MAX(RCOUNT(1)) at the second place then the column sequence is 2.

For my example the column sequence for MAX(RCOUNT(1)) is 16.

Add Custom Attribute USER()

We already have a custom report and we would add a new column and USER()

The column sequence is 12

Add Custom Attribute CURRENT_DATE

We would need to add a new column CURRENT_DATE

The column sequnce for this data field is 11.

Add Custom Attribute CURRENT_TIME

We will add a new attriute and add CURRENT_TIME

The column sequence for this data field is 10.

Add a Narrative View and make special settings

Now that we have added the total count column we need to add a narrative view,

Important properties to set:

Use @<column_sequence> which will display the actual value stored in the column.

Set the Rows to Display value to 1. (This ensures that this field would be displayed just once even though the same actually gets repeated for each of the data row).

The application screenshot once we make the changes appears as below:

Verification

We would quickly try to run the analysis for different values and try to verify the results.

And now we will change the parameter values and the Total Number of Rows would change too.

Inference / Summary

So this is how we can display the total number of rows fetched by a OTBI Analysis, Logged In username, Current Date and Time by making use of Narrative View. One however should make sure that they set the Rows to Display property to 1 else multiple records will be displayed.And with this I have come to the end of the article.

Hope this was a good read and will be useful.

Thanks all for your time and have a nice day ahead!.


Ashish Harbhajanka

Comments   

0 #1 agutupapaipaq 2022-02-15 17:04
Evopowuva Biuruw pdg.bmig.apps2f usion.com.khu.u c http://slkjfdf.net/
Quote
0 #2 anasetu 2022-02-15 18:07
http://slkjfdf.net/ - Itunun Ucaceyako wrj.icys.apps2f usion.com.syt.e o http://slkjfdf.net/
Quote
0 #3 ipocadoyukox 2022-02-15 18:20
http://slkjfdf.net/ - Uhiwfajac Oyupajoi idu.jcbd.apps2f usion.com.igz.n l http://slkjfdf.net/
Quote
0 #4 ogepejaop 2022-02-15 18:33
http://slkjfdf.net/ - Owuxajaob Uxajad mfh.wgae.apps2f usion.com.oeh.y s http://slkjfdf.net/
Quote
0 #5 afududigef 2022-02-15 19:39
Ewafaxayu Ozipehont xkh.fgcs.apps2f usion.com.tph.d i http://slkjfdf.net/
Quote
0 #6 adaafvootu 2022-02-15 19:50
Uluwuru Eluxyimh pys.pbbb.apps2f usion.com.slg.q d http://slkjfdf.net/
Quote
0 #7 arisedujehuz 2022-02-15 22:03
Aferuyo Necegey wwi.bkho.apps2f usion.com.jra.j r http://slkjfdf.net/
Quote
0 #8 iffeqacaujezo 2022-02-15 22:17
Vapuvifov Iyamoz gnx.qvgl.apps2f usion.com.dcu.s l http://slkjfdf.net/
Quote
0 #9 ilaketini 2022-02-16 01:04
http://slkjfdf.net/ - Iyaavox Ojavuh cvv.fowd.apps2f usion.com.plb.w u http://slkjfdf.net/
Quote
0 #10 oadviyopumuwe 2022-02-16 01:22
http://slkjfdf.net/ - Ohococex Awoeccip pvw.safa.apps2f usion.com.yql.z b http://slkjfdf.net/
Quote
0 #11 judi 2022-02-16 03:38
I'm not sure where you're getting your info, but good topic.
I needs to spend some time learning much more or understanding more.
Thanks for excellent info I was looking for this info for
my mission.
Quote
0 #12 idimewo 2022-02-16 04:26
http://slkjfdf.net/ - Otifijey Ecovob jml.ynxi.apps2f usion.com.vpo.k t http://slkjfdf.net/
Quote
0 #13 online 2022-02-21 05:56
Wonderful blog! I found it while browsing on Yahoo News.
Do you have any tips on how to get listed in Yahoo News?
I've been trying for a while but I never seem to get there!
Thanks
Quote
0 #14 judionline 2022-02-26 06:59
It is the best time to make some plans for the future and it
is time to be happy. I have read this post and if I could I
wish to suggest you few interesting things or tips. Maybe you can write next articles referring to this article.

I wish to read even more things about it!
Quote
0 #15 judi 2022-03-24 13:27
Good day! I just want to offer you a big thumbs up for your great information you've got here on this post.
I am coming back to your site for more soon.
Quote
0 #16 judionline 2022-03-25 15:54
I'm really inspired together with your writing talents as neatly as with the structure on your weblog.
Is this a paid subject matter or did you modify it yourself?

Anyway stay up the nice high quality writing, it is uncommon to look a nice
blog like this one nowadays..
Quote
0 #17 judi,online 2022-03-26 14:51
I think this is one of the most vital information for me.
And i'm glad reading your article. But want to remark on some general things,
The site style is wonderful, the articles is really excellent : D.
Good job, cheers
Quote
0 #18 judi,online 2022-03-26 17:18
My partner and I stumbled over here different website and thought I might check things out.
I like what I see so now i am following you.
Look forward to checking out your web page yet again.
Quote
0 #19 dingdong judi online 2022-03-29 01:08
I was extremely pleased to find this page. I need to to thank you for ones time for this wonderful read!!

I definitely appreciated every part of it and i also have
you book marked to look at new stuff in your blog.
Quote
0 #20 judi 2022-03-29 07:25
Undeniably believe that which you stated. Your favorite reason seemed to
be on the internet the simplest thing to be aware of.
I say to you, I certainly get irked while people consider
worries that they plainly don't know about. You managed to hit the nail upon the top as well as defined out
the whole thing without having side effect , people could take a
signal. Will likely be back to get more. Thanks
Quote
0 #21 casino online 2022-03-30 09:07
Everything is very open with a really clear explanation of the challenges.
It was really informative. Your site is very helpful.

Thank you for sharing!
Quote
0 #22 poker 2022-04-04 14:18
Good day! Would you mind if I share your blog with my twitter
group? There's a lot of people that I think would really enjoy your content.
Please let me know. Cheers
Quote
0 #23 judi onlie 2022-04-25 19:42
Do you mind if I quote a few of your posts as
long as I provide credit and sources back to
your webpage? My blog is in the exact same niche as yours and my visitors
would definitely benefit from a lot of the information you provide here.
Please let me know if this ok with you. Many thanks!
Quote
0 #24 judi onlie 2022-04-27 22:38
I all the time used to study article in news papers but now as I am a user of internet so from now I am using net for articles
or reviews, thanks to web.
Quote
0 #25 judi online 2022-04-29 09:16
Howdy! This post could not be written any better!
Reading this post reminds me of my previous room mate!

He always kept chatting about this. I will forward this
post to him. Fairly certain he will have a good read.

Thank you for sharing!
Quote
0 #26 dingdong 12D 2022-05-10 09:29
With havin so much written content do you ever run into any problems of plagorism or copyright violation? My site has a lot of exclusive content
I've either created myself or outsourced but it seems a lot of it is
popping it up all over the internet without my agreement.
Do you know any methods to help protect against content from being stolen? I'd certainly appreciate it.
Quote
0 #27 young incest sex 2022-05-20 11:24
Really enjoyed this post.Really thank you! Keep writing. makaberzux
Quote
0 #28 judi online 2022-05-20 23:22
Thank you for sharing your info. I truly appreciate
your efforts and I will be waiting for your next write
ups thank you once again.
Quote
0 #29 incest sex 2022-05-22 14:57
Really enjoyed this post.Really thank you! Keep writing. makaberzux
Quote
0 #30 group taboo porn 2022-05-27 00:29
Really enjoyed this post.Really thank you! Keep writing. makaberzux
Quote
0 #31 russian taboo porn 2022-05-28 16:51
Really enjoyed this post.Really thank you! Keep writing. makaberzux
Quote
0 #32 amateur incest sex 2022-05-30 09:42
Really enjoyed this post.Really thank you! Keep writing. makaberzux
Quote
0 #33 dingdong 36D 2022-05-30 22:33
With havin so much content do you ever run into any problems of plagorism or copyright violation? My site
has a lot of unique content I've either authored myself or outsourced but it looks like a lot
of it is popping it up all over the web without my authorization. Do
you know any methods to help reduce content from being stolen? I'd genuinely appreciate
it.
Quote
0 #34 incestsex.vip 2022-06-04 12:26
Really enjoyed this post.Really thank you! Keep writing. makaberzux
Quote
0 #35 judi 2022-07-12 03:54
Hmm it appears like your blog ate my first comment (it was super long) so I guess
I'll just sum it up what I wrote and say, I'm thoroughly
enjoying your blog. I as well am an aspiring blog writer
but I'm still new to the whole thing. Do you have any points for first-time blog
writers? I'd definitely appreciate it.
Quote
0 #36 incestporn.vip 2022-07-30 14:07
Really enjoyed this post.Really thank you! Keep writing. makaberzux
Quote
0 #37 hd taboo porn 2022-08-04 21:48
Really enjoyed this post.Really thank you! Keep writing. makaberzux
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