Properties

 Properties of report:

Column Heading Override:

Before change:

After change:

Format: Only Numeric field having format option.

If you want apply decimal proper format then we can use use Format option.

After changes:

Options:currency, sum functions, max and min values,

e.g:currency

before:

After changes:

Options:

E.g.:Gender

Creating

Create analytic indicator: Global level

  Create analytic indicator for report: Local level

Default:

Our final indicator:

After run:

Group Column Headings:

These headings are will helpful in integrations. 

When click on Enable service XML files will generate on back ground.

When we fetch Primary business object data there is no issues.

When we fetch  related data business object there is  issues that when click on Enabled service.

These headings are not impact in our output. It will helpful in XML headings.

After run:

When we call in integration that it will take errors:

Sort:

Basically  our output default sort option: ascending employee ID.

Creating Sort:

Output:

Sublevel:

We need to RBO by order:

Output:

Filter:

Requirement: Business asked me only US employee:

Output:

Note:In the selection list(all setup data in the system)