Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Oracle Fusion HCM
  • 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

As mentioned in my previous article , there are two ways of creating reports in OTBI, one is using BI Composer and the other one is BI Answers. In today’s session, let’s see what the features of Analysis Editor are and how to create a report using BI Answers. When you click on the Browse catalog, it opens up a different window for you. Let me have this selected. So it is basically an Oracle BA tool. This tool offers are a rich set of features which are not available in the composite wizard. So this is where we have an option of going ahead and building a new OTBA report. In this tool, there is an option to create cross subject area analyses, which means you can create analyses that combine data from more than one subject area.

The Analysis editor is technically advanced compared to the BI Composer Wizard. The Analysis editor contains the following tabs:

Criteria tab — By using the Criteria Tab you build up a report. It lets you specify the criteria for an analysis, including columns and filters. You can specify the order in which the results should be returned, formatting (such as headings, number of decimal places, styles such as fonts and colors, and conditional formatting), and column formulas (such as adding a Rank or Percentile function).

Results tab —The Results tab is where you can view the results of the OTBA report based on the columns that were extracted onto the Criteria tab. It lets you create different views of the analysis results such as graphs, tickers, and pivot tables. You can also add or modify selection steps.

Prompts tab — The prompts tab is where you can build various kinds of prompts. This tab lets you create prompts that allow users to select values to filter an analysis or analyses on a dashboard. Prompts allow users to select values that dynamically filter all views within the analysis or analyses.

• Table prompts are something which appears on top of the report. So on top of the report, you have these prompts. You select those values.
• In addition to that, you can also have prompts using variables. These variables can be set. And these variables can be used across an application.
• You can have prompts using images. For instance, I mean, you can have a certain image, clicking on which, you can expect the system to take you to a certain location. So that is something which can be achieved.
• You can have currency prompts necessarily for currency conversions.
Advanced tab — This tab lets you edit XML code and examine the logical SQL statement that was generated for an analysis. You can use the existing SQL statement as the basis for creating a new analysis. Additional filters for the report can be added in the Advanced Tab. Using this tab, you can generate XML and save into the system. This particular XML can be used as a data source in BI Publisher Report and create complex report and further customization can be done in BI Publisher Report.

The following example demonstrates steps how to create a simple real-time analysis from one subject area.

1. In the Reports and Analytics work area, click Browse Catalog.

2. Click New and select Analysis.

3. In the Select Subject Area window, select the Workforce Management - Worker Assignment Real Time subject area.

4. In the Subject Area region of the Criteria tab, expand the Department folder.

5. Click Name, Location Name and drag it to the Selected Columns area.

6. Expand the Worker Assignment folder.
7. Click Head Count and drag it to the Selected Columns area to the right of the Department Name column.
8. Click the Results tab to see the results of the analysis.

9. Click the Criteria tab again to return to the analysis definition.
10. Click the Edit Button and enter Title Name - 'Headcount by Department'.

11. Click Save Analysis.
12. Save to My Folders, and enter Headcount by Department in the Name field, and enter a description for your analysis.


Jayashree Prakash

Comments   

0 #1 mozillabd.science 2021-07-11 20:26
Everything is very open with a clear explanation of the challenges.
It was truly informative. Your website is very useful.
Thanks for sharing!

Here is my web page :: mozillabd.scien ce: https://mozillabd.science/wiki/Treating_Aging_Skin
Quote
0 #2 aid ukraine 2022-06-07 08:14
Good day! Do you know if they make any plugins
to assist with Search Engine Optimization? I'm trying to get my blog to rank for some targeted keywords
but I'm not seeing very good results. If you know of any please share.
Thanks!
Quote
0 #3 save refuges 2022-06-07 17:41
Terrific article! That is the kind of info that are meant to be shared around the net.
Disgrace on Google for not positioning this submit upper!
Come on over and seek advice from my site . Thank you =) save
refuges: https://www.aid4ue.org/about/
Quote
0 #4 donate for ukraine 2022-06-07 17:45
Write more, thats all I have to say. Literally, it seems as though you relied on the
video to make your point. You clearly know what youre talking about, why throw away
your intelligence on just posting videos to your blog when you could be
giving us something enlightening to read?
donate for ukraine: https://www.aid4ue.org/about/
Quote
0 #5 help refuges 2022-06-07 17:49
What's up, I check your blogs on a regular basis.
Your humoristic style is awesome, keep it up! help refuges: https://www.aid4ue.org/articles/
Quote
0 #6 donate for ukraine 2022-06-07 18:28
For the reason that the admin of this site is working, no question very
quickly it will be well-known, due to its quality contents.
donate for ukraine: https://www.aid4ue.org/about/
Quote
0 #7 donate for ukraine 2022-06-07 18:33
Have you ever thought about adding a little bit more than just your articles?
I mean, what you say is important and everything. However just imagine if
you added some great images or video clips to give your posts more, "pop"!

Your content is excellent but with images and clips, this site could
certainly be one of the very best in its field. Terrific blog!
donate for ukraine: https://www.aid4ue.org/about/
Quote
0 #8 wordpress plugins 2022-09-20 09:47
When some one searches for his vital thing, thus he/she
wishes to be available that in detail, so that thing is maintained over
here.

wordpress themes: https://www.accademiahotel.com/?URL=https://www.blogexpander.com/
wp
plugins: http://malcolmr.net/__media__/js/netsoltrademark.php?d=www.blogexpander.com
Quote
0 #9 wp themes 2022-09-20 10:02
When someone writes an post he/she maintains the image of
a user in his/her brain that how a user can be aware of it.
Thus that's why this paragraph is amazing. Thanks!

wp plugins: http://olhanainternet.com/__media__/js/netsoltrademark.php?d=www.blogexpander.com
wordpress themes: http://parentspriveleges.info/__media__/js/netsoltrademark.php?d=www.blogexpander.com
Quote

Add comment


Security code
Refresh

About the Author

Jayashree Prakash

Jayashree Prakash

Jayashree is a Oracle Fusion HCM certified consultant who has over fifteen years' experience with Oracle. She has worked as a consultant with several of Alberta's energy companies. She lives in Edmonton and her interests include staying active in the warmer months and vacationing in the Caribbean in the winter

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

Related Items

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner