Thursday, July 28
XSLT - Remove Special Characters Function
Wednesday, July 27
Calculated Fields and Types
Calculated Fields and Types
Calculated fields can be categorized into 2 ways:
2. Report specific calculated fields
They are created as part of one report and usage is specific to that report only. They are not reusable by other reports.
Also check - Reports / Tasks Associated:
Tuesday, July 26
XSLT - Calculate Week Number based on date
Calculate Week Number based on date
<xsl:param name="year"/>
<xsl:param name="month"/>
<xsl:param name="day"/>
<xsl:variable name="j-day">
<xsl:call-template name="calculate-julian-day">
<xsl:with-param name="year" select="$year"/>
<xsl:with-param name="month" select="$month"/>
<xsl:with-param name="day" select="$day"/>
</xsl:call-template>
</xsl:variable>
<xsl:variable name="d4"
select="($j-day + 31741 - ($j-day mod 7))
mod 146097 mod 36524 mod 1461"/>
<xsl:variable name="L" select="floor($d4 div 1460)"/>
<xsl:variable name="d1" select="(($d4 - $L) mod 365) + $L"/>
<xsl:value-of select="floor($d1 div 7) + 1"/>
</xsl:template>
Monday, July 25
XSLT Functions with Examples
XSLT Functions with Examples
Wednesday, July 20
MIME
Multipurpose Internet Mail Extensions
MIME is the acronym of Multipurpose Internet Mail Extensions. MIME type is an optional field on your integrations.
Instead of you defining your extension along with your File name, you may choose among the listed extension types for the output file. This option doesn't change the actual file format. To change the file format you need to select an alternate output format in Get Data or modify your transformation in Transformation Data tabs.
Friday, July 8
Calculated Fields - Acronyms
Calculated Fields - Acronyms
There are around 34 functions that you can use to create any calculated fields for any desired available BO.
When trying to create a Calculated Field using one the available functions, while searching for desired function (in task Create Calculated Field ) you can simply type the acronym to find it.
Also notice the input field type (i.e. source field) and the Ouput Field type from each Calc Function below.
Calculated
Field Function |
Acronym |
Input
Field Type(s) |
Output
Field Type |
Aggregate
Related Instances |
ARI |
Multi
Instance |
Multi
Instance |
Arithmetic
Calculation |
AC |
Numeric
or Currency |
Numeric |
Build
Date |
BD |
Date
or Numeric |
Date |
Concatenate
Text |
CT |
Single
Instance or Text |
Text |
Convert
Currency |
CC |
Currency |
Currency |
Convert
Text to Number |
CTN |
Text |
Number |
Count
Related Instances |
CRI |
Multi
Instance |
Number |
Date
Constant |
DC |
*Free
Date Format |
Date |
Date
Difference |
DD |
Date |
Numeric |
Evaluate
Expression |
EE |
Any |
Any |
Evaluate
Expression Band |
EEB |
Text |
Single
Instance |
Extract
Multi Instance |
EMI |
Multi
Instance or Single Instance |
Multi
Instance |
Extract
Single Instance |
ESI |
Multi
Instance |
Single
Instance |
Format
Date |
FD |
Date |
Text |
Format
Number |
FN |
Number
or Currency |
Text |
Format
Text |
FT |
Text
or Single Instance |
Text |
Increment
or Decrement Date |
IDD |
Date |
Date |
Lookup
Date Rollup |
LDR |
Date |
Single
Instance |
Lookup
Hierarchy |
LH |
Single
Instance |
Single
Instance |
Lookup
Hierarchy Rollup |
LHR |
Single
Instance |
Single
Instance |
Lookup
Organization |
LO |
N/A |
Single
Instance / Multi Instance |
Lookup
Organization Roles |
LOR |
N/A |
Single
Instance / Multi Instance |
Lookup
Range Band |
LRB |
Numeric
or Currency |
Single
Instance |
Lookup
Related Value |
LRV |
Single
Instance |
Any |
Lookup
Translated Value |
LTV |
Text |
Text |
Lookup
Value as of Date |
LVD |
Any |
Matches
Input Value Type |
Numeric
Constant |
NC |
*Free
Number Format |
Numeric |
Prompt
for Value |
PV |
Any |
Matches
Input Value Type |
Substring
Text |
ST |
Text
or Single Instance |
Text |
Sum
Related Instances |
SRI |
Single
Instance or Multi Instance |
Numeric |
Text
Constant |
TC |
*Free
Text Format |
Text |
Text
Length |
TL |
Text
or Single Instance |
Numeric |
True/False
Condition |
TF |
Any |
Boolean |