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.
|Measure||Name||Type yourself||You can see this name for this measure on the High Speed View and reports.|
Semi-additive functions include:
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.|
|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).
|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.|
|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.