Functions Function Output Syntax Sample Result
嚜獨ebi Report Function Overview
Below are the lists of available Webi 3.1 report functions and will describe each & every functions along with example.
Webi 4.0 reports are also having some functions with some additional futures.
Functions
Abs
Asc
Average
Block Name
Ceil
Function Output
Syntax
Returns the Absolute value of a
Number
ASCII value of a Character. Only
one Character it will define the
ASCII value, even if you add
more than one Character.
Average of the Measure values.
Average function mostly useful
when you do average on a total
of table measures. Average
would provide the average
where total Measures divided
by no of rows of the table
Num Abs(number)
Returns the Table Name where
this Block Name function is
used.
Rounds a Number up to the
nearest Integer
97324
54354
77
65
Num
Average(Measure[;In
clude Empty])
=Average([Amount
])
String BlockName()
=BlockName()
Desc
Amount
A
2540
B
3210
C
1243
D
5214
E
8003
F
98721
Sum
118931
Average 19821.83
Master Table 每 Name
of the table
Num Ceil(Number)
=Ceil(1234.51)
=Ceil(1234.49)
=Ceil(-1234.1)
=Char(100)
=Char(77)
=Char(42)
Int Asc(Character)
Character Associated with ASCII String
code
Char(ascii_code)
Column
Number
Displays the column Number
where this function used in a
table
Concatenation
Join 2 strings and make it single
Connection
The parameters of the
database connection used by a
data provider. Data Provider
name must enclosed in square
bracket.
Cosine of an angle
Count
Number of Values / rows in a
dimensions or Measures.
Includes distinct values only
(default for dimensions) or all
values (default for measures) in
the calculation
Result
=Abs(-97324)
=Abs(54354)
=Asc(※M§)
=Asc(※A§)
Char
Cos
Sample
Int ColumnNumber()
C
N
=ColumnNumber()
String Concatenation =Concatenation("S
(first_string;Second_s AP";" Business
tring)
Objects")
String
=Connection([Quer
Connection(dp)
y 1])
Num Cos(angle)
int
Count(obj[;IncludeE
mpty] [;Distinct|All])
=Cos(360)
=Cos(200)
=Count([Desc])
=Count([Amount])
1235
1235
-1234
d
M
*
3 每 Column Number
function used in 3rd
column of that table
SAP Business Objects
DB Layer: "Oracle
OCI". DB Type: "Oracle
11".
-0.28
0.49
Desc
A
B
C
C
E
F
Amount
2540
3210
1243
5214
8003
98721
Display the Current Date
formatted according to the
regional Settings in your server
Display the Current Time
formatted according to the
regional Settings in your server
Logon of the Current User
Name of the Data provider
containing a report Object
Date CurrentDate()
=CurrentDate()
Count
Dim
Count
Measure
12/24/13
Time CurrentTime()
=CurrentTime()
2:05:54 PM
String CurrentUser()
String
DataProvider(obj)
=CurrentUser()
=DataProvider([Co
untry])
Key Date of the Data Provider.
Data Provider name must
enclosed in square bracket.
Key Date Caption of the Data
Provider. Data Provider name
must enclosed in square
bracket.
Date
DataProviderKeyDate
(dp)
Stri8ng
DataProviderKeyDate
Caption(dp)
=DataProviderKeyD
ate([dp])
devuser
Query 1 每 this is
Default Data provider
name
24 December 2013
Data Provider
SQL
SQL Query generated by the
Data Provider
Data provider
Type
Type of a Data Provider 每what
kind of sources used for that
report 每 Example - Universe,
Free hand SQL, etc.,
Day Name in the Date. The
input date must be a variable.
You cannot specify the date
directly, as in
DayName("12/24/2013").
Return the Day number of that
month
String
DataProviderSQL([dp
])
String
DataProviderType([d
p])
Current Date
Current Time
Current User
Data Provider
Data Provider
key Date
Data Provider
key Date
Caption
Day Name
Day Number
Of Month
Day Number
Of Week
Day Number
Of Year
Return the Day number of that
week. Example 6/16/2010 is
Wednesday and Webi report
would consider Monday as
Start of the Week. So Day
Number for that week is 3.
Return the Day number of that
Year
5
6
=DataProviderKeyD
ateCaption([dp])
Returns "Current
calendar date" if the
keydate caption
in the dp data
provider is "Current
calendar date".
=DataProviderSQL([ Select object1 from
dp1])
table#
=DataProviderType
([dp1])
Universe
String
DayName(date)
= =DayName([Sales
Date])
Sales Date
6/16/2010
6/21/2010
6/23/2010
6/25/2010
6/26/2010
Day Name
Wednesday
Monday
Wednesday
Friday
Saturday
Int
DayNumberOfMonth
(date)
=DayNumberOfMo
nth([Sales Date])
Sales Date
6/16/2010
6/21/2010
6/23/2010
6/25/2010
6/26/2010
Day Number
16
21
23
25
26
Int
DayNumberOfWeek()
=
DayNumberOfWee
k([Sales Date])
Sales Date
Week
Number
6/16/2010
6/21/2010
6/23/2010
6/25/2010
6/26/2010
3
1
3
5
6
Int
DayNumberOfYear(d
ate)
=DayNumberOfYea
r([Sales Date])
Sales Date
4/5/2010
4/7/2010
4/8/2010
4/12/2010
4/13/2010
Day of Year
95
97
98
102
103
Days Between
Number of Days between 2
dates
Document
Author
Document
Creation Date
Logon of the Document Creator
Document
Creation Time
Time on which a document was
created
Document
Date
Document
Name
Document
Owner
Date on which a document was
last saved
Name of the document / report
Document
Partially
Refreshed
Date on which a document was
created
Logon user name of the owner
of the document (the last
person who saved the
document)
Will tell you whether the report
is fully or partially refreshed.
Int
DaysBetween(first_d
ate;last_date)
=DaysBetween([Sal
es
Date];CurrentDate(
))
;
3/12/2010
3/16/2010
3/17/2010
3/22/2010
3/23/2010
Days
Between
1383
1379
1378
1373
1372
*Current Date 每
12/24/13
devuser
String
DocumentAuthor()
Date
DocumnetCreationDa
te()
Time
DocumnetCreationTi
me()
Date
DocumnetDate()
String
DocumnetName()
String
DocumentOwner()
=DocumentAuthor(
)
=
DocumnetCreation
Date()
=
DocumnetCreation
Time()
= DocumnetDate()
=DocumentOwner(
)
devuser
Bool
DocumentPartiallyRe
freshed()
=DocumentPartiall
yRefreshed()
Returns 1 & 0. 0 每
Means Fully refreshed.
1 每 Means partially
refreshed. You can use
these values in IF
function to display
TRUE / FALSE
4:25:39 PM
12/10/13
2:55:59 PM
12/10/13
= DocumnetName() Sample Webi Report
Document
Time
Drill Filter
Time on which a document was
last saved
Drill Filters applied to a report
or an Object in drill mode
Time
DocumnetTime()
String DrillFilters([Obj
|Separator])
= DocumnetTime()
Euro Convert
From
Converts a Euro amount to
another currency. The currency
code must be the code of one
of the 12 EU currencies whose
values were fixed in relation to
the Euro prior to their abolition
in January 2002. If it is not, the
function returns #ERROR. The
currencies are:
Code Currency Desc
BEF
Belgian franc
num
EuroConvertFrom(eu
ro_amount;curr_cod
e;round_level)
=EuroConvertFrom
(1000;"FRF";2)
=DrillFilters()
Consider report has
drill on Country and
Year. If the DrillFilter
return US 每 means
Drill Filter applied on
Country. US 2013 每
Means Drill filter
Applied on County &
year.
6559.57
=EuroConvertFrom
(1000;"GRD";1)
340,750.1
=EuroConvertFrom
(1000;"ITL";0)
1,936,270
DEM
GRD
ESP
FRF
IEP
ITL
LUF
NLG
ATS
PTS
FIM
Euro Convert
To
Euro From
Round Error
Euro To Round
Error
Even
Exp
Fact
Fill
First
German mark
Greek drachma
Spanish peseta
French franc
Irish punt
Italian lira
Luxembourg franc
Dutch guilder
Austrian schilling
Portuguese escudo
Finnish mark
Converts an amount to Euros.
Currency code can be used as
mentioned in the above table
num
EuroConvertTo(none
uro_amount;curr_co
de;round_level)
Returns the Rounding decimal
place amount in the
conversion. Example,
EuroConvertFrom(1000;"FRF";1
) return 6559.60 whereas
without rounding this would be
6559.57, the difference is 0.03.
The difference amount 0.03
will be returned when you use
EuroFromRoundError(1000;"FR
F";1).
Returns the Rounding decimal
place amount in the
conversion. Same as above.
num
EuroFromRoundError
(euro_amount;curr_c
ode;round_level)
Exponential (e raised to a
power). An exponential is the
constant e (2.718...) raised to a
power.
Factorial of an Integer.
Factorial of number is multiple
of all the integers from 1 to
number. If FACT(4) then it
would calculate 1*2*3*4= 24
an FACT(6) is
1*2*3*4*5*6=720
Concatenate the string by
repeating N times.
Num Exp(Number)
num
EuroToRoundError(n
oneuro_amount;curr
_code;round_level)
Determines the Number is Even Bool Even(number)
or not
Returns the first value in a data
=EuroConvertTo(65
59.57;"FRF";2)
1000
=EuroConvertTo(65 3,353.85
59.57;"DEM";2)
=EuroFromRoundEr 0.03
ror(1000;"FRF";1)
=EuroFromRoundEr 0 每 means there is no
ror(1000;"GRD";1) difference in rounding
the decimal places.
=EuroFromRoundEr -0.01 每> 2,203.71
ror(1000;"NLG";1)
when you round this
amount 2,203.7 and
the difference is -0.01
=EuroToRoundErro -0.05 ->152.45 while
r(1000;"FRF";1)
rounding it would be
152.4 and the
difference is -0.05
=Even(10)
1 每 This is even
Number
=Even(11)
0 每 Not an even
Number
=Exp(2)
7.39
=Exp(3)
20.09
Num Fact(number)
=Fact(4)
=Fact(6)
24
720
String
Fill(repeating_string;
num_repeats)
=Fill("Business
Objects ";3)
Business Objects
Business Objects
Business Objects
=Fill("SAP ";5)
=First([Country])
SAP SAP SAP SAP SAP
USA 每 First value of
Input_type
Floor
Force Merge
set (dimension or Measure
Objects). Used in a break
footer, First returns the first
value in the in the break.
Used in a section footer, First
returns the first value in the
section.
Used in a table footer,
First([Sales]) returns the first
value of [Sales] in the table.
Round the Number down to
the Nearest integer
ForceMerge is the equivalent
of the BO Desktop Intelligence
Multicube function. Includes
synchronized dimensions in
measure calculations when the
dimensions are not in the
measure's Calculation context /
Data Provider.
First(dimension|mea
sure)
Int Floor(number)
=First([Sales])
Country Object.
102364.55 每 first value
of the Sales Measure
based on your Query
data set.
=Floor(1234.61)
=Floor(-1234.61)
=ForceMerge([Sale
s])
1234
-1235
104342.50
2013/24/12
String
GetContentLocale()
=FormatDate(Curre
ntDate();"yyyy/dd/
MM")
=FormatDate(Curre
ntDate();"MM/yyyy
")
=FormatNumber([S
ales];"#,##0")
=FormatNumber([S
ales];"#,##0.00")
=GetContentLocale
()
String
GetDominantPreferr
edViewingLocale()
=GetDominantPref
erredViewingLocal
e()
en_US
Num
ForceMerge(number)
When you have more than one
data provider and one DP does
not have a synchronized
dimension and you need to
merge that DP measure with
other DP, ForceMerge would
help you to get the Measure
amount in single Object.
Format Date
Format
Number
Get Content
Locale
Get Dominant
Preferred
Viewing
ForceMerge([Sales]) returns
the value of [Revenue], taking
into account any synchronized
Dimensions that do not appear
in the same block as the [Sales]
measure.
Formats a date according to
the Specified format
Formats a Number according to
the Specified format
Returns the Local (Desktop 每
where you are accessing the
report) Language of your report
Data content
Returns the dominant locale in
the user's Preferred Viewing
Locale group. The Translation
string
FormatDate(date;for
mat_string)
string
FormatNumber(num
ber;format_string)
12/2013
12,358,210
12,358,210.56
en
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- the essential functions of r
- r reference card
- functions function output syntax sample result
- c reference card ansi constants flow of control program
- r language definition
- python cheat sheet
- using keystrokes to write equations in microsoft office
- syntax becomes rstudio
- 059 30 a clever demonstration of the sas substr function
- three ways to add texts to graphics in proc sgplot sas
Related searches
- eb result development officer 2018
- eb exam result development 2018
- o l result 2018
- output of function calculator
- functions and function notation
- function syntax matlab
- javascript function syntax es6
- sample function in r
- input and output function math
- excel function syntax list
- powershell output result to file
- functions and function notation calculator