Select the
Prompts
tab. Add prompt using data set column from data source. Set ‘Default Value’ from
the data set as needed.
Prompt
Data Set Column
Selected_Equipment
EQUIPMENT
Selected_Class
CLASS
Selected_Manufacturer
ASSETMANUFACTURERNAME
Select the
Filters
tab. Add condition data set column equal to prompt.
Keep Only Records
option to
Match All of the Followin
g.
Prompt
Data Set Column
Selected_Equipment
EQUIPMENT
Selected_Class
CLASS
Selected_Manufacturer
ASSETMANUFACTURERNAME
Select the
New
button and select the
Expression Editor.
Add expression:
stringToDate(concat(concat(concat(left(intToString(BREAKDOWNDATEYEARMONTH) ,4) ,"-")
,right(intToString(BREAKDOWNDATEYEARMONTH) ,2)) ,"-01"))
Manufacturer attribute needs following expression:
stringToDate(concat(concat(concat(left(intToString(YEARMONTH) ,4) ,"-")
,right(intToString(YEARMONTH) ,2)) ,"-01"))
Enter new field name ‘BREAKDOWNDATE’ in
Enter the Computed Field Name
and select
OK.
In the
Data Manipulation Editor
Window,
select field ‘BREAKDOWNDATE’ and set following column
values:
Order
= 1
, Key
= 1,
Type
= continuous.
No other fields should have
Order
column set to 1.
Set
Key
column to 1
Attribute
Fields
Key column
EQUIPMENT
EQUIPMENT, EQUIPMENTNAME
1
CLASS
CLASS, CLASSNAME
1
MANUFACTURER
ASSETMANUFACTURERNAME
1
Set field
Type
column to ‘continuous’
Attribute
Measure
Type column
EQUIPMENT
NMBROFACTUALMAINTOBJECTBRKDWNS
continuous
CLASS
NMBROFACTUALMAINTOBJECTBRKDWNS
continuous
MANUFACTURER
NMBROFREPORTEDMAINTOBJBRKDWNS
continuous
