Introduction
In one of the previous article (linkhere) we have seen how to display total no of rows fetched by an OTBI Analysis, Display Logged In User’s Application User-Name, Current Date and Time. But just to remind that these are not the only functions available to be used.
There are a whole gamut of functions categorized under:
Aggregate
Running Aggregate
String
Math
Calendar/Date
Conversion
System
Expressions
DB Functions
Time Series Calculations
One may find the list if one navigates to any of the Data Fields used in Analysis and then click on “Edit Formula”. A new popup window opens up and there is a Button Titled “f()..’ . Once we click on the same the following screen opens up:
Most of the functions perform some specific operations on the actual data rendered by the Analysis, however there are few functions which might be common to many analysis couple of example being displaying the Day Name, Day of Year, Day of Quarter, Username, Day of Month….etc etc
At this point one obvious question which might arise to many users would be what is the actual benefit / value-addition a business used will have if he/she is aware of these delivered functions. And while there could be many reasons for the same my answer is as below:
OTBI was originally designed for use by business users.
As such any business user at any point of time should be aware of the delivered functions.
Couple of advantages (with sepcific reference to the delivered function follows):
1. Logged in User Name
For an OTBI Analysis the data rendered is dependent on the logged in user(who runs the report). So while UserA may get 10 Purchase Order related details (for example), UserB will get 20 Purchase Orders. So the data rendered doesn't make any sense unless the logged in user details are provided.
2. Current Date
Unlike BI Report an OTBI Analysis always gives Current Date data. So Current Date should always be printed in an OTBI Report . Hence being aware of this function helps.
3. Current Year, Current Month, Current Quarter
These functions can be of importance while creating financial reports. Being aware of the function helps
And many more...
For this example we would use a couple of these functions and display them in a Narrative View.
Details of the functions below:
Attribute Name |
Attribute Value (Function Used) |
Subject Area |
DATABASE() |
Logged In User |
USER() |
Current Date |
CURRENT_DATE |
Current Time |
CURRENT_TIME |
Current Timestamp |
CURRENT_TIMESTAMP |
Day of Quarter |
DAY_OF_QUARTER(CURRENT_DATE) |
Day Name |
DAYNAME(CURRENT_DATE) |
Day of Month |
DAYOFMONTH(CURRENT_DATE) |
Day of Week |
DAYOFWEEK(CURRENT_DATE) |
Day of Year |
DAYOFYEAR(CURRENT_DATE) |
Current Month |
MONTH(CURRENT_DATE) |
Month of Quarter |
MONTH_OF_QUARTER(CURRENT_DATE) |
Month Name |
MONTHNAME(CURRENT_DATE) |
Week of Year |
WEEK_OF_YEAR(CURRENT_DATE) |
Year |
YEAR(CURRENT_DATE) |
Week of Quarter |
WEEK_OF_QUARTER(CURRENT_DATE) |
Quarter of Year |
QUARTER_OF_YEAR(CURRENT_DATE) |
Once these details have been populated we would get the requisite data in the “Results” tab. We would need to create a new “Narrative View” and Navigation is View ->New View (using )
Screenshot below:
Next we need to choose Other Views -> Narrative View as shown
Once we do that we need to design the Narrative View. The details used are in the table below:
Attribute Name |
Attribute Value |
Prefix |
******** Start of Report ********************[br/] [br/] Delivered Date Time and System Functions[br/][br/] **********************************************[br/][br/] |
Narrative |
[b]Subject Area :[/b] @1[br/] [b]Logged In User :[/b] @2[br/] [b]Current Date :[/b] @3[br/] [b]Current Time :[/b] @4[br/] [b]Current Timestamp :[/b] @5[br/] [b]Day of Quarter :[/b] @6[br/] [b]Day Name :[/b] @7[br/] [b]Day of Month :[/b] @8[br/] [b]Day of Week :[/b] @9[br/] [b]Day of Year :[/b] @10[br/] [b]Current Month :[/b] @11[br/] [b]Month of Quarter :[/b] @12[br/] [b]Month Name :[/b] @13[br/] [b]Week of Year :[/b] @14[br/] [b]Year :[/b] @15[br/] [b]Week of Quarter :[/b] @16[br/] [b]Quarter of Year :[/b] @17[br/] |
Row separator |
|
Rows to Display |
|
Postfix |
[br/]*************End of Report******************[br/] |
These details when populated in the application would appear as shown below:
We can now save the analysis. Remove the Title and Table views. Add this Narrative View and the results would appear as below:
Inference / Summary
So this is how one may use the delivered functions in a OBI Analysis. While I have used Narrative View here one may choose any of the other available ones too. Also apart from the functions used here there are multiple other functions which can be used.
That’s it from my side , have a nice day!
Hopefully the content was useful
Comments
Money and freedom is the best way to change, may you be rich and continue to help others.
dailly and get good facts from here daily.
out more details.
estoy segura de que si seguís leyendo os vamos a sorprender con las versiones
que en Uniendoficiante hacemos de esta preciosa ceremonia.
Además también puedes hacernos sugerencias, por ejemplo
si tienes alguna preferencia en cuanto al color del fondo para que
contraste con el color de la pared en la que lo vas a colgar, si quieres alguna burbuja con un mensaje personal… Para eso
hemos inventado esta ceremonia mixta donde añadimos las arras al
recipiente de las arenas o bien las dejamos al rededor del bote central si las
tenéis que devolver. Es una forma preciosa
de involucrarlos aún más en la ceremonia puesto que ya
sois una familia. Algunos utilizan un recipiente en forma de corazón para verter
su combinado en la arena. 12 La ceremonia de inauguración ha sido la más costosa de la historia del olimpismo, superando a la de Atenas en 2004.
Sin embargo, el interés para que Beijing luciera el nuevo rostro de China rebasa
más allá la ceremonia inaugural, pues incluyó la construcción de
los complejos deportivos, un nuevo ordenamiento urbano -incluyendo la construcción de una línea de metro-, la preparación de la logística del evento por más de siete años y el cierre de fábricas y el retiro de
la circulación de dos millones de vehículos
en forma previa a la inauguración con la intención de tener
un cielo más limpio.
drop, just so she can be a youtube sensation. My iPad is now destroyed and she has 83 views.
I know this is completely off topic but I had to share it with someone!
І wilⅼ be sure to bookmark it and come back to гead more օf
yⲟur uѕeful infⲟrmation. Τhanks fоr tһe post.
I'll dеfinitely return.
Ѕtop by my site ... Printable Calendar: http://tc.browin.net.cn/home.php?mod=space&uid=545924&do=profile&from=space
with the format for your blog. Is that this a paid theme or did you customize it your self?
Anyway keep up the excellent quality writing,
it's uncommon to see a nice weblog like this one nowadays..
this web site is in fact fabulous.
Feel free to visit my website: may 7th calendar: http://savethekeys.org/__media__/js/netsoltrademark.php?d=www.inploid.com%2Fl%2F%3Furl%3Dhttps%3A%2F%2Fwww.pinterest.com%2F7calendar%2F
I'm going to take a note of your blog and keep checking for new details about once per calendar
week 7 2022: http://Ridebear.bike/__media__/js/netsoltrademark.php?d=fjq.itsasmallworld.net%2F__media__%2Fjs%2Fnetsoltrademark.php%3Fd%3Dwww.pinterest.com%252F7calendar%252F. I subscribed to your Feed too.
I'd state. This is the very first time I frequented your web page and thus
far? I amazed with the research you made to make
this particular publish amazing. Wonderful activity!
gives quality based articles.
me to come here and visit more often. Did you hire out a developer to create your theme?
Fantastic work!
Please reply back as I'm hoping to create my own personal site and want to find out where you got
this from or exactly what the theme is called. Cheers!
Thank you so much and I'm taking a look ahead to contact you.
Will you please drop me a mail?
be pay a visit this web page and be up to date everyday.
at a few of the articles I realized it's new to me.
Anyhow, I'm definitely delighted I found it and I'll be book-marking it and checking back often!
regalos originales el rey del regalo. Copiamos al óleo sobre lienzo, todos los detalles con exactitud:
pinceladas, colores y texturas; en retratos, paisajes, fotos personales y pinturas que
no estén disponibles en la tienda. La montura está fabricada
en TR90 que dota a las gafas de una gran ligereza, flexibilidad y resistencia.
El equipo de AutentiKits te ofrece DESAYUNOS A DOMICILIO, REGALOS PARA FECHAS ESPECIALES,
REGALOS PARA BEBES, PEQUEÑOS DETALLES, REGALOS PERSONALIZADOS, REGALOS PARA EL HOGAR, REGALOS PARA
BARACOAS y una gran variedad de REGALOS CON BEBIDAS ALCOHOLICAS.
Una gran variedad de invitaciones para que puedas invitar a tus amigos y familiares de la
forma más original que puedas. Si no sabes cómo pedirle a tus familiares y amigos
que asistan a tu boda en calidad de testigos o damas de honor, no
hay manera más original de pedírselo que obligándoles a romperse
la cabeza para armar un puzzle que, además, podrán enmarcar y quedárselo de recuerdo.
Sin embargo, esta de Gillete tiene un diseño que recuerda a las antiguas barberías (que no te engañe
porque tiene tecnología Braun).
it's remarkable article.
I clicked submit my comment didn't appear. Grrrr...
well I'm not writing all that over again. Regardless,
just wanted to say superb blog!
reading this great educational piece of writing here at my residence.
assists new net users, who are wishing for blogging.
to produce a very good article… but what can I say… I procrastinate a whole lot and never manage to get nearly anything done.
understanding something completely, except this paragraph presents pleasant understanding yet.
which blog platform are you using for this website?
I'm getting tired of Wordpress because I've had problems with
hackers and I'm looking at options for another platform.
I would be great if you could point me in the direction of a good platform.
must be pay a visit this web page and be up to date all the time.
website by chance (stumbleupon). I have bookmarked it
for later!
Keep up the superb works guys I've you guys to
my own blogroll.
I came tߋ take a ⅼook. I'm definitely loving the infօrmation. I'm book-marking аnd will be tweeting this to my followers!
Superb blog and great design.
Mү page - astro planner: https://t.me/s/printable_calendar
this post reminds me of my old room mate! He always kept talking about this.
I will forward this page to him. Pretty sure he will have a good read.
Thank you for sharing!
In any case I'll be subscribing to your feed and I'm hoping you write again very soon!
I was interested to know how you center yourself and clear
your mind prior to writing. I've had difficulty clearing
my mind in getting my thoughts out there. I truly do enjoy writing
but it just seems like the first 10 to 15 minutes are generally
wasted just trying to figure out how to begin. Any recommendations or hints?
Kudos!
posts and additional data, is there any other website which provides these kinds of data in quality?
when i read this piece of writing i thought i
could also create comment due to this sensible paragraph.
Did you make this website yourself? Please reply back as I'm looking to create my
own personal website and want to know where you got this
from or just what the theme is called. Thanks!
Stop by my blog post :: RUAY: https://www.dualmonitorbackgrounds.com/ruayshuay
Your web site offered us with helpful information to work on. You
have done a formidable activity and our whole community might be thankful to you.
I'll bookmark your weblog and check again here frequently.
I'm quite sure I will learn many new stuff right here!
Best of luck for the next!
My website :: RUAY: https://www.microsoftpartnercommunity.com/t5/user/viewprofilepage/user-id/68180
like you wrote the ebook in it or something. I feel that you just
can do with some % to power the message house a little bit, but instead of
that, that is fantastic blog. A great read. I'll certainly be
back.
para esa persona a la que quieres enamorar. Encontrarás
una gran variedad de artículos que te aportarán miles de ideas acerca de qué regalar
a amigos o familiares. También son días y meses en los que
no tendrán tiempo ni para comer bien, así que otro de los regalos originales para parejas es disfrutar de
una buena cena en un prestigioso restaurante con Estrella Michelin. Crear
una boda mágica es una cuestión en la que deben ponerse los
cinco sentidos y toda nuestra buena energía e imaginación,
para conseguir los mejores resultados que tengan, tanto a los novios como a los invitados, enamorados de la
celebración todo el tiempo que dure. Deja de buscar en páginas extranjeras con productos de dudosa calidad y
larguísimo tiempo de entrega, en Regalos Originales y Baratos te enviamos justo el
producto que has visto en nuestra página en 24/48 horas, para
que lleguen a tiempo en caso de que te corran prisa.
content, except this web site provides quality based posts.
courage to go ahead and give you a shout out
from Humble Tx! Just wanted to tell you keep up
the excellent work!
I'm starting ɑ blog sooon but have no codіng experience
ѕo I waznted tߋ ցet advicce frⲟm some᧐ne wiith experience.
Ꭺny help woulԀ be greatly appreciated!
my homepaցe: caⅼendário mensal: http://mindfulnessacademy.org/en/component/k2/item/60
What host are you using? Can I get your associate hyperlink
for your host? I wish my site loaded up as quickly as yours lol
They're really convincing and will certainly work.
Nonetheless, the posts are very brief for starters.
May you please extend them a little from subsequent time?
Thank you for the post.
commented here, I am really enjoying by these.
http://cleantalkorg2.ru/article?frptp
contents, thanks
up to other visitors that they will assist, so here it occurs.
authoring on other blogs? I have a blog centered on the same ideas you discuss and
would really like to have you share some stories/informa tion. I know my viewers would enjoy your work.
If you're even remotely interested, feel free to send me an e mail.
regarding tgis poece of writing, in my view its
actuallkʏ remarкable designed for me.
Ꮋere iss my ste - calendário em branco: http://info.ertelecom.ru/?campid=2444&machine=nn&ourl=http://yuri.s55.xrea.com/top/cgi/bbs_2/apeboard_plus.cgi?command
this paragraph, in my view its truly remarkable in favor of
me.
the points you have made.
This is the first time I frequented your web page and thus far?
I surprised with the analysis you made to make this actual put up incredible.
Magnificent task!
whether this post is wrotten by him as no one else know such
detailed abgout my trouble. Yoou are wonderful! Thanks!
Feel fdee to vosit my homepage: 광주유흥: https://Ilovebamdomin.com/
your views are pleasant designed for new users.
mу newest twitter updateѕ. I've been looking fοr a pluց-in like thiѕ for
quite some time and wаѕ hoping maybe you ѡould haνe some experiencе witһ something lіke this.
Please let me know if you run into ɑnything.
I truly enjoy гeading your Ьlg and I look forward to your new updates.
My web blog - calendário de julho: http://clients1.google.com.ua/url?q=https://www.fisiopilateseestetica.com.br/2019/10/15/fisio-pilates-e-estetica-realiza-cursos-de-primeiros-socorros/
for? you made running a bloog looҝ easy. The overall look of
your site is great, as smartly as the content!
my webрage ... calendário de junho: http://www.bigztube.com/te3/out.php?l=thumbs&u=https://leekdrill99.doodlekit.com/blog/entry/20112693/three-scary-proxy-servers-concepts
Annd i am glad reading yiur article. But want to remark on some general things, The
web site style is perfect, thee articles is rrally great : D.
Good job, cheers
Here is mʏ web-site; calendário 2023: http://www.meyerequipment.com/__media__/js/netsoltrademark.php?d=darohagps.com%2Findex.php%2Fcomponent%2Fk2%2Fitem%2F9-qui-nunc-nobis-videntur-parum-clari-fiant-sollemnes-in-futurum-mutationem.html
whether this post is written by him as no
one else know such detailed about my problem.
You're incredible! Thanks!
presentation however I in finding this topic too be really one thing that
I think I mkght never understand. It sort oof feells too complex and very vast for me.
I'm taking a look forward to ylur subsequent post, I wikll attempt tto get the
hang of it!
Feel free to surf to my blog post - 아이러브밤: https://Ilovebamdomin.com/
I lioke what I see so i am just following you. Look forward to goinng over your web page yyet again.
Feel free to visit my page - 아이러브밤: https://ilovebamdomin.com/
You've ended my 4 day lengthy hunt! God Bless you man. Have a great day.
Bye
all at one place.
know-how, so it's fastidious to read this web site, and I
used to pay a visit this website everyday.
I really like the information you present here and can't wait to take
a look when I get home. I'm amazed at how quick your blog loaded on my cell phone ..
I'm not even using WIFI, just 3G .. Anyhow, fantastic blog!
my blog post; บทความทั่วไป: http://auroealis.pbworks.com/w/page/147983703/FrontPage
unexpected emotions.
Check out my webb blog: 아이러브밤: https://ilovebamdomin.com/
and personally recommend to my friends. I'm confident they'll be benefited
from this website.
Exactly where are your contact details though?
I needs to spend some time finding out much more or working out more.
Thanks for magnificent information I used to be in search of this information for my mission.
renowned, due to its feature contents.
from now on each time a comment is added I recieve four emails with the exact same
comment. Perhaps there is an easy method you are able to remove me from that service?
Cheers!
support you.
Feel free to visit my page - 광주유흥: https://Ilovebamdomin.com/
I appreciate you spending some time and energy to put this
article together. I once again find myself personally spending way too much time both reading
and posting comments. But so what, it was still worth it!
Also visit my webpage сборка
кухни питер: https://yapl.ru/ru/sborium.ru/
of a user in his/her mind that how a user can understand it.
Therefore that's why this paragraph is perfect. Thanks!
Extremely helpful info specially the final section :) I
deal with such info much. I was looking for this certain information for a
very lengthy time. Thank you and best of luck.
of things from it about blogging. thanks.
if blogs use WYSIWYG editors or if you have to manually code with HTML.
I'm starting a blog soon but have no coding know-how so I wanted to
get guidance from someone with experience. Any help would be greatly appreciated!
Would you be interested in trading links or maybe guest writing a
blog article or vice-versa? My site addresses a lot of the same subjects as yours
and I think we could greatly benefit from each other.
If you might be interested feel free to send me an e-mail.
I look forward to hearing from you! Terrific blog by the way!
Keep up the good works guys I've you guys to blogroll.
Keep up the good works guys I've added you guys to blogroll.
forty foot drop, just so she can be a youtube sensation. My iPad is now broken and she has 83 views.
I know this is completely off topic but I had to share it with someone!
educative and engaging, and let me tell you,
you've hit the nail on the head. The issue is something not enough folks are speaking intelligently about.
I'm very happy that I found this during my search for something relating to this.
blog world but I'm trying to get started and set up my own. Do you require any coding knowledge to make
your own blog? Any help would be greatly appreciated!
thus I just use world wide web for that purpose, and get
the most up-to-date news.
and additional data, is there any other web
site which presents these data in quality?
a little comment to support you.
interesting article like yours. It is pretty
worth enough for me. In my opinion, if all site owners
and bloggers made good content as you did, the net will be a lot more useful than ever before.|
I could not resist commenting.
Perfectly written!|
I will right away take hold of your rss feed as I can not to find your e-mail subscription link or newsletter service.
Do you've any? Please allow me recognize so that I could subscribe.
Thanks. |
It's perfect time to make some plans for the future and it is
time to be happy. I've read this post and if I could I want to suggest
you some interesting things or advice. Perhaps you can write next articles referring to this article.
all concerning that.
I wanted to write a little comment to support you.
What would you recommend in regards to your publish that you simply made a few days in the past?
Any positive?
long) so I guess I'll just sum it up what I had written and say, I'm thoroughly enjoying your blog.
I as well am an aspiring blog writer but I'm still new to everything.
Do you have any recommendations for inexperienced blog writers?
I'd really appreciate it.
Feell freee to surf to mmy web-site ... Brigitte: https://zemaox.bloggin-ads.com/35078861/best-online-slots-to-play-for-actual-funds-major-high-payout-slot-sites-for-2022
RSS feed for comments to this post