|
|
|
Use the compound layout view to assemble different
views for display on a dashboard.
On the Criteria tab, you can click the following
button to access the compound layout view.
|
|
Use the title view to add a title,
a subtitle, a logo, a link to a custom online help page, and timestamps to
the results.
|
|
Use the table view to show results in a standard
table. Users can navigate and drill down in the results. You can add totals,
customize headings, and change the formula or aggregation rule for a column.
You can also control the appearance of a column and its contents, and specify
formatting to apply only if the contents of the column meet certain
conditions.
On the Criteria tab, you can click the following button
to access the table view.
|
|
Use the chart view to drag and
drop columns to a layout chart. You can customize the title, legend location,
axis titles, and data labels. You can customize the size and scale of the
chart, and control colors using a style sheet.
Oracle BI Answers supports a
variety of standard chart types, including bar charts, column charts, line
charts, area charts, pie charts, and scatter charts. Custom chart subtypes
include two-and-three-dimensional, absolute, clustered, stacked, combination,
and custom.
On the Criteria tab, you can
click the following button to access the chart view.
|
|
Use the pivot table view to take row, column, and
section headings and swap them around to obtain different perspectives. You
can drag and drop headings to pivot results, preview them, and apply the
settings. Users can navigate through pivot tables and drill down into
information. Users can create complex pivot tables that show aggregate and
nonrelated totals next to the pivoted data, allowing for flexible analysis.
For an interactive result set, elements can be placed in pages, allowing
users to choose elements.
On the Criteria tab, you can click the following
button to access the pivot table view.
|
|
Use the gauge view to show
results as gauges, such as dial, bar, and bulb-style gauges.
|
|
Use the filters view to show the filters in effect
for a request. Filters allow you to constrain a request to obtain results
that answer a particular question.
|
|
Use the column selector view to
permit users to dynamically change which columns appear in results. This
allows users to analyze data along several dimensions. By changing the facts,
users can dynamically alter the content of the results.
|
|
Use the View Selector view to select a specific view
of the results from among the saved views. When placed on a dashboard, the
view selector appears as a drop-down list from which users can make a
selection.
|
|
Use the Legend view to document
the meaning of special formatting used in results, such as the meaning of
custom colors applied to gauges.
|
|
Use the funnel chart view to show a
three-dimensional chart that represents target and actual values using
volume, level, and color. It is useful for depicting target values that
decline over time, such as a sales pipeline.
|
|
Use the narrative view to show
the results as one or more paragraphs of text. You can type in a sentence
with placeholders for each column in the results, and specify how rows should
be separated.
|
|
Use the ticker view to show the results of the
request as a ticker or marquee, similar in style to the stock tickers that
run across many financial and news sites on the Internet. You can control
what information is presented and how it scrolls across the page.
|
|
Use the static text view to
include static text in the results. You can use HTML to add banners, tickers,
ActiveX objects, Java applets, links, instructions, descriptions, graphics,
and so on, in the results.
|
|
The no results view allows you to specify
explanatory text to appear if the request does not return any results.
|
|
Use the logical SQL view to
show the SQL generated for the request. This view is useful for trainers and
Oracle BI administrators, and is usually not included in results for typical
users.
You cannot modify this view,
except to delete it.
|
|
The create segment view is for users of the Oracle's
Siebel Marketing Version 7.7 (or higher) operational application. Use it to
display a Create Segment link in the results. Users can click this link to
create a segment in their Oracle Siebel Marketing operational application,
based on the results data.
|
|
The create target list view is
for users of Oracle's Siebel Life Sciences operational application integrated
with Oracle's Siebel Life Sciences Analytics applications. Use it to create a
Create Target List link in the results. Users can click this link to create a
target list, based on the results data, in their Oracle Siebel operational
application.
|
I have a requirement :
ReplyDeleteI need to display time of a day (say, 12:24:34) vs. dates in bar/line graph. Which is say, to display the logging off times of each day Vs. Dates, say last 7days. Trying to give one graphical view below:
Date
|
|_ _ _ Time
01-May-2014 |===============07:14 PM
02-May-2014 |======================09:20 PM
03-May-2014 |===================08:10 PM
04-May-2014 |=================07:30PM
Any help is highly appreciated. Thanks!
-Subrata Sarkar, Kolkata