Intellicus Enterprise Reporting and Business Insights 19.1

Measure Properties

0 views June 28, 2020 0

The properties pop-up window shows and captures properties of selected item on the design area.

The following table lists the properties of measure in an Analytical Object.

Item Property Values Comments
Measure Name Type yourself You can see this name for this measure on the High Speed View and reports.
Function SUM,

AVERAGE,

COUNT,

MINIMUM,

MAXIMUM

DISTINCT COUNT

Semi-additive functions include:

First Child

Last Child

First Non Empty Child

Last Non Empty Child

Average Over Time

Select from the list as per need.

Refer the section underneath this table to learn more about Distinct Count measure.

 

 

 

Semi-additive functions work for “Time” type dimensions only.

“FirstChild”, “LastChild”, “FirstNonEmptyChild” and “LastNonEmptyChild” functions return zero in case of “Regular” type dimensions selected on the report.

“AverageOverTime” returns sum value in the above case.

Refer the section underneath this table to learn more about Semi-Additive Measures.

Field Select from the Query Object Fields The list of Query Object Fields appears here.
Format Format String

#,##0.00

This format will be applied on this measure on High Speed View and reports. To know more on Data Formats, please refer Data Formats under Common Help section
Unit Type yourself Used as a suffix for the measure value on High Speed View and reports.
Unit System Select from list This provides the option to display the numeric values in crosstab/chart/map with formatting as per the unit system. Currently Intellicus provides Indian, International and SI Units.
You can select Indian unit system to show values in Thousands, Lacs etc. International unit system can help specify USD currency suffixed with Million, Billion etc.
Specify SI unit system to show international numeric values in Giga,Tera etc.Below is an example of specifying Indian system unit and how it will appear on the High Speed Report (with unit system applied).

unit
unit1
Note: Unit system is supported when exporting HSV report to PDF

Visible Check/Uncheck Check – You can see this measure on viewer

Uncheck – You cannot see this measure. You can only use it to express another calculated measure.

Default Check/Uncheck Specifies if this is the default measure for this cube. You should have at least one default measure to create an analytical object.
Adjustment Check/Uncheck This is a waterfall type chart related property. If you check this property, then this measure becomes a floating bar on a waterfall type of chart.
Adjustment-Yes

Negative/

Positive

 

Negative/

Positive

If the adjustment property is checked, then you will see this property.

If you set as negative adjustment – the floating bar will be Red in color and will be drawn downwards from previous measure’s top.

 

If you set as positive adjustment – the floating bar will be Green in color and will be drawn upwards from previous measure’s top.

Expression Check/Uncheck Check – This is a calculated measure.

Uncheck – This is a field sourced measure.

Solve Order 0-N You can set any number from 0 to N.

The lower Solve Order Calculated Measures will be evaluated prior to higher Solve Order Calculated Measures.