Creating a Dimension

Prerequisites

• You have subscribed to DataArts Insight.
• A project has been created by referring to Creating a Project.

• A data source has been connected by referring to Connecting to a Data Source.
• A dataset has been created by referring to Creating a Dataset.

Procedure

1. Click in the upper left corner to select a region.
2. In the lower left corner of the navigation pane, select an enterprise project from Enterprise Project.
3. In the project list on the console, click a project to go to the project page.
4. Choose Data Management > Datasets.
5. Click the dataset for which you want to create a dimension.
6. On the dataset editing page, click Create Dimension.

   Figure 1 Creating a dimension

   
   
7. After setting the parameters, click Confirm.
   1. Creation Method: Select Edit Formula. Data type: Select Numeric, Text, Date, or Date Time.
      1. For details about the parameters, see Table 1.
         Note

         • The brackets used in the expression must the ones available under the English input method.
         • The functions must be supported by the data sources.

         Table 1 Parameters

         Parameter	Description
         Click to reference a function.	Functions used to process data. You can set date, text, and numeric functions.
         Click the reference field	Dimension and metric fields of a dataset.
         Field expression	Field expression that helps you understand the data processing process.

         Table 2 Date functions

         Function	Usage	Description
         CURRENT_DATE	CURRENT_DATE()	Returns the current date.
         CURRENT_TIME	CURRENT_TIME()	Returns the current time.
         NOW	NOW()	Return system's current date and time.
         UNIX_TIMESTAMP	UNIX_TIMESTAMP()	Returns the current time as a UNIX timestamp.
         UNIX_TIMESTAMP	UNIX_TIMESTAMP(d)	Returns the time d as a UNIX timestamp.
         FROM_UNIXTIME	FROM_UNIXTIME(d)	Converts the time in the UNIX timestamp format to the time in the common format.
         MONTH	MONTH(d)	Returns the month value in the date d, ranging from 1 to 12.
         DAYOFWEEK	DAYOFWEEK(d)	Calculates the day of the week corresponding to date d.
         DAYOFYEAR	DAYOFYEAR(d)	Calculates the day of the year corresponding to date d.
         DAYOFMONTH	DAYOFMONTH(d)	Calculates the day of the month corresponding to date d.
         QUARTER	QUARTER(d)	Returns the season of date d as a value between 1 and 4.
         HOUR	HOUR(t)	Returns the hour value in t.
         MINUTE	MINUTE(t)	Returns the minute value in t.
         SECOND	SECOND(t)	Returns the second value in t.
         DATEDIFF	DATEDIFF(d1,d2)	Calculates the number of days between d1 and d2.
         ADDDATE	ADDDATE(d,n)	Calculates the date that is n days after the start date d.
         ADDDATE	ADDDATE(d, INTERVAL expr type)	Calculates the date that is the result of adding a time segment to the start date d.
         SUBDATE	SUBDATE(d,n)	The date n days before date d.
         SUBDATE	SUBDATE(d,INTERVAL expr type)	The date resulting from subtracting a time segment from date d.
         DATE_FORMAT	DATE_FORMAT(d,f)	Displays the date d as required by expression f.
         TIME_FORMAT	TIME_FORMAT(t,f)	Displays the time t as required by expression f.

         Table 3 Text functions

         Function	Usage	Description
         CHAR_LENGTH	CHAR_LENGTH(s)	Returns the number of characters in string s.
         LENGTH	LENGTH(s)	Returns the length of string s.
         CONCAT	CONCAT(s1,s2,...)	Combines multiple strings such as s1 and s2 into one string.
         CONCAT_WS	CONCAT_WS(x,s1,s2,...)	Uses the first parameter as the separator, which is associated with all following parameters.
         UPPER	UPPER(s)	Converts letters in string s into uppercase letters.
         LOWER	LOWER(s)	Converts letters in string s into lowercase letters.
         LEFT	LEFT(s,n)	Returns the first n characters of string s.
         RIGHT	RIGHT(s,n)	Returns the last n characters of string s.
         LPAD	LPAD(s1,len,s2)	Uses string s2 to fill the beginning of s1 so that the string length reaches len.
         RPAD	RPAD(s1,len,s2)	Uses string s2 to fill the end of s1 so that the string length reaches len.
         LTRIM	LTRIM(s)	Deletes the space at the beginning of the string s.
         RTRIM	RTRIM(s)	Deletes the space at the end of the string s.
         TRIM	TRIM(s1 FROM s)	Removes the string s and the string s1 at the end.
         REPEAT	REPEAT(s,n)	Repeats the string s for n times.
         REPLACE	REPLACE(s,s1,s2)	Replaces the string s1 in the string s with the string s2.
         SUBSTRING	SUBSTRING(s,n,len)	Obtains a string whose length is len from the nth position in the string s.
         LOCATE	LOCATE(s1,s)	Obtains the start position of s1 from the string s.
         INSTR	INSTR(s,s1)	Obtains the start position of s1 from the string s.
         REVERSE	REVERSE(s)	Reverses the sequence of the string s.
         MD5	MD5(str)	You can hash the string str to encrypt data that does not require decryption.

         Table 4 Numeric functions

         Function	Usage	Description
         ABS	ABS(x)	Returns the absolute value of x.
         CEIL	CEIL(x)	Returns the smallest integer greater than or equal to x.
         FLOOR	FLOOR(x)	Returns the largest integer less than or equal to x.
         RANDOM	RANDOM()	Returns a random number ranging from 0.0 to 1.0.
         SIGN	SIGN(x)	Returns the sign of x, which is either -1, 0, or 1 depending on whether x is negative, zero, or positive.
         PI	PI()	Returns pi.
         TRUNC	TRUNC(x, y)	Returns the value of x rounded to y decimal places.
         ROUND	ROUND(x)	Returns the integer closest to x.
         ROUND	ROUND(x, y)	Returns the value of x rounded to y decimal places, with any truncated part being rounded off.
         POWER	POWER(x,y)	Returns the value of x raised to the power of y.
         SQRT	SQRT(x)	Returns the square root of x.
         EXP	EXP(x)	Returns the value of e raised to the power of x.
         MOD	MOD(x,y)	Returns the remainder when x is divided by y.
         LOG	LOG(x)	In the ORA- or TD-compatible mode, this operator means the logarithm with 10 as the base. In the MySQL-compatible mode, this operator means the natural logarithm.
         RADIANS	RADIANS(x)	Converts the angle to a radian.
         DEGREES	DEGREES(x)	Converts the radian to an angle.
         SIN	SIN(x)	Calculates the sine value given in radians.
         ASIN	ASIN(x)	Calculates the arc sine value given in radians.
         COS	COS(x)	Calculates the cosine value given in radians.
         ACOS	ACOS(x)	Calculates the arc cosine value given in radians.
         TAN	TAN(x)	Calculates the tangent value given in radians.
         ATAN	ATAN(x)	Calculates the arc tangent value given in radians.
         COT	COT(x)	Calculates the cotangent value given in radians.

   2. Visual editing: To create group dimensions, you can only use one dimension. If you need to create more complex dimensions using multiple dimensions, use the formula editor.
      1. Select group fields.
      2. Select group field values.
      3. After setting the group, click Refresh Preview and click Confirm.