Introduction
By now we all are aware of what a OTBI Analysis is and how the same needs to be created. In case you haven’t no issues you may refer to some of the articles below:
In this article we would try to demonstrate some advanced techniques which involves referring one analysis to meet a specific filter condition.
The Business Requirement is to create a OTBI Analysis which would display the details of a Work Relationship Record which has the latest start date.
This requirement is basically having two parts:
Part1: A simple Work Relationship OTBI Analysis
Part2: A filter criteria applied on the above report.
So now let us try to develop the analysis. We would have to create a analysis first which would act as a filter criteria and then we would proceed with applying this analysis on the main analysis to get desired results.
Creating Analysis to fetch the Record with Maximum Start Date
As a first step we need to login to the application and reach to BI Catalog and select the new Analysis. Navigator> Tools> Reports and Analytics
Click on the Reports and Analytics and this will open a new page where you should select the 'Browse Catalog' option (Open Book Page icon).
Next click on New>Analysis
Next, select the Subject Area “Workforce Management – WorkRelationship Real Time” and pick the attribute ‘Start Date’ from the folder Work Relationship Details as shown:
Now we need to use a formula column to ensure that we get the Maximum start date, This is accomplished by using the formula column as shown below:
Use the MAX aggregate function. Insert Function> Max
The final formula would appear
Save this analysis and give an appropriate name (we have named it max_start_date_analysis for this example)
Now we will create the Main analysis
We would need to create a Work Relationship Analysis and it would have following attributes
But now let-us try to add the filter criteria. This would be done by using the filter criteria option on the start date column and select filter clause:
Once applied the Analysis Criteria screen would appear
And then the results
So we can see how we can use one analysis to act as a filter-criteria for another analysis. This is a just a prototype shown for example purpose and more complex filters maybe used to meet specific business needs.
Hopefully this article was helpful and would be referenced in real implementation projects too.
Do give a try and share your findings and observations.
Thank You for your time and have a nice day!!
Good Bye……
Comments
I've learn this post and if I may I desire to recommend you some attention-grabb ing things or
suggestions. Maybe you could write subsequent articles regarding
this article. I desire to read even more things approximately it!
knowledge on the topic of unexpected feelings.
are simply too magnificent. I actually like what you've acquired here, certainly like what you're stating and the way in which by which you are saying it.
You make it entertaining and you still care for
to keep it smart. I can't wait to learn far more
from you. That is actually a tremendous website.
Thanks!
up very fast! What web host are you the usage of? Can I am getting your affiliate hyperlink in your host?
I wish my web site loaded up as quickly as yours lol
I put things off a whole lot and don't manage to get anything
done.
Reading this post reminds me of my previous room mate!
He always kept chatting about this. I will forward this article to him.
Pretty sure he will have a good read. Thanks for sharing!
other web page which presents such stuff in quality?
fast! What host are you using? Can I get your affiliate link to your host?
I wish my site loaded up as fast as yours lol
I think every one is getting more from this web page, and your views are
pleasant for new users.
by accident, while I was looking on Digg for something else, Anyhow I am here now and would just like to say thanks a lot
for a tremendous post and a all round enjoyable blog (I also love the theme/design),
I don't have time to browse it all at the minute but I have bookmarked it and
also added your RSS feeds, so when I have time I will be back to read much
more, Please do keep up the fantastic work.
and design. Superb choice of colors!
concerning unexpected feelings.
but it has pretty much the same layout and design. Excellent choice of colors!
It absolutely helpful and it has helped me out loads.
I hope to contribute & aid different customers like its helped me.
Good job.
I must spend some time finding out more or understanding more.
Thank you for fantastic info I was on the lookout for this info for my mission.
website who has shared this great piece of writing at here.
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 blogger
but I'm still new to everything. Do you have any suggestions for novice blog writers?
I'd definitely appreciate it.
It will always be useful to read through articles from other authors and use something from their
sites.
Is it tough to set up your own blog? I'm not very techincal but I can figure things out pretty fast.
I'm thinking about creating my own but I'm not sure where to
begin. Do you have any ideas or suggestions? Thanks
post is in fact fruitful designed for me, keep up posting
these types of articles or reviews.
keep up the good work!
know if you knew of any user discussion forums that
cover the same topics talked about here? I'd really love to be a part of
online community where I can get opinions from other experienced people that share the same interest.
If you have any suggestions, please let me know. Appreciate it!
You have some really great articles and I think I would be a good asset.
If you ever want to take some of the load off, I'd really like
to write some content for your blog in exchange for
a link back to mine. Please send me an email if interested.
Kudos!
of useful data, thanks for providing these kinds of information.
have found something that helped me. Thank you!
through Google, and found that it is truly informative.
I'm gonna watch out for brussels. I will be grateful if you continue
this in future. A lot of people will be benefited from your writing.
Cheers!
situation; we have created some nice procedures and we are
looking to exchange solutions with other folks, please shoot me an e-mail if interested.
coming yet again to read more news.
Look complicated to more added agreeable
from you! However, how can we be in contact?
similar one and i was just wondering if you get a lot of spam comments?
If so how do you prevent it, any plugin or anything you can suggest?
I get so much lately it's driving me crazy so any assistance is very much
appreciated.
topic, however, you sound like you know what you're talking about!
Thanks
Is that this a paid subject matter or did you customize
it yourself? Anyway keep up the excellent quality writing, it's uncommon to look a nice weblog like
this one nowadays..
at this webpage, I have read all that, so at this
time me also commenting here.
thanks.
post was great. I don't know who you are but certainly you're going to a
famous blogger if you are not already ;) Cheers!
I am experiencing issues with your RSS. I don't know the reason why I cannot join it.
Is there anybody having the same RSS issues? Anyone
that knows the solution will you kindly respond? Thanx!!
favor”.I'm trying to find things to enhance my site!I suppose its ok to use some of your ideas!!
revisiting. I surprise how a lot attempt you place to
make this sort of great informative website.
visitors? Is gonna be again often to check out new
posts
familiar with afterward you can write otherwise it is difficult to write.
keep it up.
have found It positively helpful and it has helped me out loads.
I am hoping to give a contribution & help different users like its aided me.
Good job.
I am having problems with your RSS. I don't understand the reason why I can't subscribe to it.
Is there anybody getting similar RSS problems? Anyone that knows the solution can you kindly
respond? Thanks!!
truly fastidious.
I really hope to see the same high-grade
content from you later on as well. In fact, your creative writing abilities has inspired me to
get my very own blog now ;)
similar to this take a great deal of work? I've absolutely no understanding of programming but I had been hoping
to start my own blog in the near future. Anyways, if you have any ideas or tips for new blog owners please share.
I know this is off subject however I just wanted to ask.
Thanks a lot!
for this wonderful read!! I definitely liked every little bit of it and I have you book marked to see new stuff in your blog.
Your site offered us with valuable info to work on. You have done a formidable job and our
whole community will be thankful to you.
at this web page is really nice.
blogger, and I was wanting to know your situation; many of us
have created some nice procedures and we are looking to exchange
techniques with others, why not shoot me an e-mail if interested.
posted at this web page is actually good.
It's good to come across a blog every once in a while that isn't
the same old rehashed information. Fantastic read! I've bookmarked
your site and I'm including your RSS feeds to my Google account.
visitors, who are wishing in favor of blogging.
work and coverage! Keep up the very good works guys I've incorporated you guys to my blogroll.
in detail, thus that thing is maintained over here.
and find nearly all of your post's to be precisely what I'm looking for.
Does one offer guest writers to write content for you personally?
I wouldn't mind publishing a post or elaborating on some of the subjects you write with regards to
here. Again, awesome blog!
not sure whether this post is written by him as no one else know such detailed about my problem.
You're wonderful! Thanks!
page are in fact remarkable for people knowledge, well, keep up the nice work
fellows.
is sharing data, that's actually excellent, keep up writing.
web site? The account helped me a acceptable deal. I had been a little bit acquainted of this your broadcast provided bright
clear concept
out and say I truly enjoy reading your blog posts.
Can you recommend any other blogs/websites/ forums that
cover the same topics? Thanks a lot!
I'm planning to start my own blog soon but I'm having a tough time choosing between BlogEngine/Word press/B2evoluti on and Drupal.
The reason I ask is because your design seems different then most blogs and I'm looking for something
completely unique. P.S Apologies for getting off-topic but I had to ask!
quality contents, thanks
Keep up the wonderful works guys I've included you guys to my personal blogroll.
Thank you!
but this website presents quality based writing.
assist, so here it happens.
internet. I will recommend this website!
We are a group of volunteers and starting a new project in a community in the same niche.
Your blog provided us beneficial information to work on. You have done a
outstanding job!
I think that you could do with a few pics to drive the message home a bit, but
other than that, this is great blog. A fantastic read. I will
definitely be back.
thanks to web.
clicked submit my comment didn't appear. Grrrr...
well I'm not writing all that over again. Anyways, just wanted to
say great blog!
He used to be entirely right. This submit actually made my
day. You cann't imagine simply how so much time I had spent for this information! Thank you!
through this post reminds me of my old room mate!
He always kept talking about this. I will forward this post to
him. Fairly certain he will have a good read. Many thanks for sharing!
amend your web site, how can i subscribe for a blog web site?
The account aided me a acceptable deal. I had been a little bit acquainted of this your broadcast offered bright clear idea
accident (stumbleupon). I've bookmarked it for later!
this subject, but you sound like you know what you're talking about!
Thanks
Keep on posting!
you suggest about your submit that you simply made some
days ago? Any sure?
Your web site provided us with useful information to work on. You have performed a formidable process and our
whole group will likely be thankful to you.
this this web site conations really good funny material too.
came to check it out. I'm definitely loving the information. I'm bookmarking and will be
tweeting this to my followers! Outstanding blog
and amazing design.
It's always useful to read through content from other writers and use a little something from
their web sites.
here at web, except I know I am getting know-how all
the time by reading thes pleasant articles.
I'll bookmark your weblog and check again here
regularly. I am quite sure I will learn lots of
new stuff right here! Good luck for the next!
with? I'm looking to start my own blog in the near future but
I'm having a difficult time deciding between BlogEngine/Word press/B2evoluti on and Drupal.
The reason I ask is because your design and style seems
different then most blogs and I'm looking for something unique.
P.S Sorry for getting off-topic but I had to ask!
this helpful information with us. Please stay
us informed like this. Thanks for sharing.
is truly fruitful in support of me, keep up posting such articles.
I do believe that you ought to write more about this
topic, it may not be a taboo subject but usually people
do not speak about such subjects. To the next! All the best!!
to your weblog. Is this a paid subject or did you modify it your self?
Anyway keep up the excellent quality writing, it is rare
to look a nice blog like this one today..
I seriously appreciate individuals like you! Take care!!
Your site provided us with useful info to work on. You have done an impressive job and our entire group will be thankful to you.
A design like yours with a few simple tweeks would really make my blog stand out.
Please let me know where you got your theme. Thanks
hackers? My last blog (wordpress) was hacked and I ended up losing
months of hard work due to no backup. Do you have any solutions to stop hackers?
I'm new to the blog world but I'm trying to get started and set
up my own. Do you require any html coding knowledge to make your own blog?
Any help would be greatly appreciated!
spam feedback? If so how do you reduce it, any plugin or anything you can advise?
I get so much lately it's driving me mad so any help is very much appreciated.
loading properly. I'm not sure why but I think its a linking issue.
I've tried it in two different internet browsers and both
show the same results.
I have joined your feed and sit up for in search of more of your great post.
Additionally, I have shared your site in my social networks
to see this web site every day as it offers
feature contents, thanks
you, However I am having problems with your RSS. I don't understand why I
cannot join it. Is there anybody having identical RSS problems?
Anyone who knows the answer can you kindly respond?
Thanx!!
I'm planning to start my own blog soon but I'm a little lost on everything.
Would you recommend starting with a free platform like Wordpress or
go for a paid option? There are so many choices out there that I'm totally confused
.. Any suggestions? Thanks!
I guess 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 talk about this blog with
my Facebook group. Talk soon!
more details.
in academy.
however, you seem like you know what you're talking about!
Thanks
excellent and i could assume you're an expert on this subject.
Fine with your permission let me to grab your feed
to keep up to date with forthcoming post. Thanks a million and please keep up the rewarding work.
I'll bookmark your weblog and check again right here regularly.
I am quite certain I'll be informed lots of new stuff proper right
here! Best of luck for the following!
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 mad so any assistance is very much
appreciated.
I mean, what you say is important and everything.
However think about if you added some great photos or video clips to give your posts more, "pop"!
Your content is excellent but with images and video clips,
this website could definitely be one of the greatest in its field.
Amazing blog!
The sector hopes for even more passionate
writers like you who are not afraid to mention how they believe.
At all times go after your heart.
this, such as you wrote the e-book in it or something.
I believe that you simply could do with some percent to power the message house a
bit, however other than that, that is great blog. An excellent read.
I will definitely be back.
I'm trying to get my blog to rank for some targeted keywords but I'm not seeing
very good success. If you know of any please share.
Thank you!
in my view its in fact awesome designed for me.
Between your wit and your videos, I was almost moved to start
my own blog (well, almost...HaHa!) Fantastic job. I really enjoyed what you had to say, and more than that, how you presented it.
Too cool!
blog. Im really impressed by it.
Hello there, You've performed a great job.
I'll definitely digg it and in my opinion recommend to my friends.
I'm confident they'll be benefited from this web site.
Keep writing!
Keep up the amazing effort.
ask. Would you be interested in exchanging links or maybe guest writing a blog post or vice-versa?
My site goes over a lot of the same topics as yours and I believe we could greatly benefit from each other.
If you happen to be interested feel free to shoot me an e-mail.
I look forward to hearing from you! Awesome blog by
the way!
I will bookmark your blog and keep checking for new details about once per week.
I opted in for your RSS feed as well.
also happy to share my knowledge here with colleagues.
with? I've loaded your blog in 3 completely different internet browsers and I must say this blog loads a lot faster then most.
Can you recommend a good hosting provider at a reasonable price?
Many thanks, I appreciate it!
in favor of his website, because here every information is quality based stuff.
matter to be really one thing which I believe I might never
understand. It seems too complicated and very large for me.
I'm looking ahead on your subsequent put up, I will try to get the hold of it!
its really really good article on building up new web
site.
of your posts. Several of them are rife with spelling problems and I to find
it very bothersome to inform the reality on the other hand I'll definitely come again again.
for me, keep up posting such content.
RSS feed for comments to this post