Scheduling a Report

Scheduling a Report

Today we will see some of the tabs present in the Scheduling page of a Report.

To schedule a report, in Analytics Home page go to 

New > Report Job  or select the report > more > Schedule

First tab on this page is General Tab

First option is Report, here you can see the path of the report or you can select a report using search icon.

Second important in this page is Parameters, if your report has parameters it will be shown here. you can enter values for those parameters or can have default values.

Next tab is Output 

Output tab is where output formats, destinations like FTP, Email can be mentioned.

First check box is Use Bursting Definition to Determine Output & Delivery Destination. This option is automatically populated if your report has bursting query defined already. 

Next is Save Date for Republishing. This option is used for printing output from Report Jobs History in required formats.

Next important part is Output, here you specify different types of output based on different combinations of layouts, formats, locale.

Save Output option here is a check box which is used to see output from Report Jobs History page.

Last is Destination, where we can define delivery location, path, file name at destination or email ids based on the type of the destination

Next will be continued in the next post..

OTBI - Filters Vs. Selection Steps

 OTBI - Filters Vs. Selection Steps

Hi Everyone,

This is a small post explaining differences between Selection steps and Filters in OTBI Reports.

OTBI stands for Oracle Transactional Business Intelligence, an analysis tool and low code approach to develop reports for real time data.

It provides us with numerous options, today we will discuss one of those:

Filters:

Filters are used to limit data based on the requirement like we want to see particular item data or particular state and so on..

We can compare Filter to Where Clause so first filters are considered then query will be fired.

Selection Steps:

Selection Steps are different from Filters.

We can compare Selection Steps to Having Clause.

They affect only field but not values.

And Selection steps can be applied to Dimensional Data like Attributes, Hierarchical Columns, Groups and Calculations but not Measures.

Data appear in the order they are selected in Selection List.