Formatos de Fecha BO

In Webi there are multiple way in which you can change the format of the displayed date and time field according to requirement . There are some date format which are available in Webi . Please note that it is case sensitive so it will make a difference if you write Ddd and DDD. Please see the below usage of Format for more understanding :
  Input date String date format formula output
25/09/2013 d FormatDate(datefield(); "d" )
25 25/09/2014 dd FormatDate(datefield(); "dd" )
25 25/09/2015 Ddd FormatDate(datefield(); "Ddd" ) Wed
25/09/2016 DDD FormatDate(datefield(); "DDD" ) WED
25/09/2017 Dddd FormatDate(datefield(); "Dddd" ) Wednesday
25/09/2018 DDDD FormatDate(datefield(); "DDDD" ) WEDNESDAY
25/09/2019 Dddd dd FormatDate(datefield(); "Dddd dd" ) Wednesday
25 25/09/2020 M FormatDate(datefield(); "M" )
9 25/09/2021 MM FormatDate(datefield(); "MM" )
09 25/09/2022 Mmm FormatDate(datefield(); "Mmm" ) Sep
25/09/2023 Mmmm FormatDate(datefield(); "Mmmm" ) September
25/09/2024 yy FormatDate(datefield(); "yy" )
13 25/09/2025 yyyy FormatDate(datefield(); "yyyy" )
2013 25/09/2026 Dddd dd Mmmm yyyy FormatDate(datefield(); "Dddd dd Mmmm yyyy" ) Wednesday 25 september 2013 25/09/2027 h:mm:ss FormatDate(datefield(); "h:mm:ss" ) 11:09:08 25/09/2028 hh:mm FormatDate(datefield(); "hh:mm" ) 11:09 25/09/2029 hh:mm:ss FormatDate(datefield(); "hh:mm:ss" ) 11:09:08 25/09/2030 dd/mm/yyyy hh:mm:ss FormatDate(datefield(); "dd/mm/yyyy hh:mm:ss" ) 25/09/2013 11:09:08 These are some standard formula which we can use to get the desire format. Apart form this we may have date and time functions in formula editor which we can use according to usage to achieve desire format. like in formula editor you will find in "Year" which will return year in a Date , "MonthNumberOfYear" it will return the number in a date , "DayNumberOfYear" returns the day number in a year etc. Problem statement : I have requirement to provide to provide the report in up-loadable date and time format . That mean date in yyyymmdd format and time in hhmmss format. To achieve the requirement of date format we can use the following formula in Webi : FormatNumber(Year(Date field()); "0000")+FormatNumber(MonthNumberOfYear([Planned Call Date]);"00" )+FormatNumber(DayNumberOfYear([Planned Call Date]); "00") . so the for the input date for eg :"25/09/2013" the formula gives the output as "20130925". Now to for the time format i went on the logic to convert it to date using function "ToDate" and then use "FormatDate" function. Below is the output which i got : 1st filed is the time field , 2nd is after applying formula to convert to date field and the 3rd one is after formatting of date field : formating of time.PNG So formula will throw error for the time 15:25:23 , because it is unable to convert it to date format. For the other time its working fine and formatting is done accordingly. Now if you see the time filed format (HH:MM:SS) and require format of time (HHMMSS) , we can achieve this by removing the colon(:) from the time field. There is function in BO formula editor called "Replace" which replaces the part of string with another string. so fromula = Replace([Time field] ; ":";"" ) will replace the ":" with blank . There are so many functions in the formula editor to make the job easy , we have to be aware of working and functionality of formula.

NIF empleado

=Right([L01 Empregado (s) Nº ID (Chave)];Length([L01 Empregado (s) Nº ID (Chave)])-Pos([L01 Empregado (s) Nº ID (Chave)];"/"))

Reset a selector like combo box or radio button

1. Bind labels of the selector (eg. B2:B5)
2. Set Insertion type and destination (eg. C2)
3. Set the selected item type on Dynamic on the behaviour tab of the selector
4. Bind the item to a cell (eg F2)
5. Bind source cell of Push button (eg. E2)
6. Bind destination cell of Push button (eg. F2, same as selected item of combo!)
7. Add formula in source cell push =if(F2=”x”,B2,”x”)
8. Add “x” value in destion cell F2

Comes in handy when you want to reset only certain parts of the dashboard and not resetting it to its initial state (as you do with the reset button).

Multiple Select List Box

http://dl.dropbox.com/u/40240633/4.-%20Indicadores%20de%20Gest%C3%A3o%20v_4.xlf

Access to BO

To be able to View, Refresh and 'Edit' reports in public folder for further analysis but at the same times they should not be able to save the report in the same public folder-->


At the FOLDER level for view/refresh without the ability to save, set the following for Web Intelligence reports:
Save as CSV
Save as PDF
Use Lists of Values
Download files associated with the object
Export the report's data
Refresh the report's data
Save as excel
Refresh List of Values

The Users who will be developing and saving should have additional rights to save to the folder, which is also granted at the FOLDER level.

To give users the ability to do analysis on webi reports, apply the following at the APPLICATION level for Web Intelligence, depending on your user requirements:
Deny the access - "Add objects to the folders" to users
Enable Java Report Panel
Data Tracking: Enable for users
Interactive: General - Edit 'My Preferences'
Interactive: General - Ability to hide / show toolbars
Interactive: Reporting - Create and edit sort
Interactive: Reporting - Insert and remove report, table, chart and cell
Interactive: Left pane - Enable available objects, tables and charts
Enable interactive HTML viewing (if license permits)
Interactive: Left pane - Enable data summary
Interactive: Reporting - Apply and remove existing alerters
Interactive: Reporting - Create and edit report filter
Interactive: Left pane - Enable document summary
Interactive: Reporting - Create and edit predefined calculation
Interactive: Formatting - Enable toolbar and menus
Enable formula and variable creation
Enable Query - HTML
Interactive: General - Enable right click menu
Enable drill mode
Web Intelligence Rich Client: Print a document
Interactive: Left pane - Enable document structure and filters
Web Intelligence Rich Client: Enable a client to use it
Data Tracking: Enable format display changes by users
Interactive: Reporting - Create and edit break

Customizing BO Infoview

Logon CMC.
Area 'Manage'
Escoger 'Aplicativos'
Escoger 'Infoview'


Opciones:
Header and Style
Hola de estilos: default.css

Logo:
Do Not Display Logo: No logo is displayed and the colors selected for the header are displayed.

Display Business Objects Logo
This is the default setting and the image can be located at /BusinessObjects Enterprise 11/Web Content/Enterprise11/InfoView/images/banner_logo.gif.

Display Custom Logo
Specify the URL where the custom logo is located. Ensure that this URL is mapped to the web server.

Use Custom Header Colors
Change the default colors on the header.

Style Sheet
Found at /BusinessObjects Enterprise 11/Web Content/Enterprise11/InfoView/default.css, this style sheet can be replaced with your own or the default can be modified. The style sheet can be used to change such items as font, color, and size. Each entry in the style sheet is documented; however, make a backup copy of the default before making changes.





Display
This section hides or displays certain features, as described in Table 24.9.

Table 24.9. Global Display Features of InfoView Option
Description

Show Preferences Button
If checked, this displays the Preferences icon. If this is not displayed, users will have no control over setting their preferences.

Show Type Drop-Down List
Removes the ability to filter the page by object type and all objects are displayed.

Show Filters Tab on the Schedule Tab
Administrators might not want users applying filters to reports. The filters section gives the user the ability to rewrite the filter or SQL WHERE clause, and this is recommended only for advanced users.

Default Navigation View
Administrator can select either Category or Folder as an initial view of the navigation section.

Maximum Number of Pages of Objects to Show
Pages of objects are created by the number of objects the user chooses to display on a page. If more objects are available than are displayed on the page, additional page numbers are shown.




SAP Note 1414285 that will give you some pointers, here are the details of the Note:

Customizing the InfoView logon screen:
- Go to folder: C:\Program Files\BusinessObjects\Tomcat55\webapps\InfoViewApp\res\schema.blue\
- Rename the file: login_banner_center.gif to login_banner_center_OLD.gif
- Save the new logo file as login_banner_center.gif
- Restart the Tomcat server and open the InfoView.
- After opening the InfoView you will find the new logo
- Customizing the InfoView top banner logo:

After login to InfoView you want to change the logo that appears above the Menu
- Go to folder: C:\Program Files\BusinessObjects\Tomcat55\webapps\InfoViewApp\res\schema.blue\
- Rename the file: IV_left_topbanner.gif to IV_left_topbanner_OLD.gif
- Save the new left logo file as IV_left_topbanner.gif
- Rename the file: IV_right_topbanner.gif to IV_ right_topbanner_OLD.gif
- Save the new right logo file as IV_ right_topbanner.gif
- Take the backup of the file default.css as default_OLD.css
- Open the file default.css and adjust the following parameters in the “/* InfoView banners */” session as appropriated
.bannerCustomLeft
.bannerCustomRight
.bannerLogo
.bannerLeft
.bannerUserName
.bannerCenter
.bannerRight

- You may want to change the background-color and the banner height and width
- Save and close the file
- Restart the Tomcat server
- Open the InfoView and log in
- Check if the logo is according with your needs.





1. Log into CMC
2. Click BusinessObjects Enterprise Applications
3. Once inside, click Infoview
4. Click properties in infoview. In the section Header and Style you can put customer logo.

Please note: you should have rights to do the view/change etc in CMC.

Agregación Running SUM

Dos ratios:
*Ventas
*Ventas n-1

Derivado:
*Acumulado por mes... =RunningSum([Vendas]; ([L01 Período contábil]))
*Aculumado por year =RunningSum([Vendas]; ([L01 Exercício]))
*Acumulado por mes n-1... =RunningSum([Vendas n-1]; ([L01 Período contábil]))
*Aculumado por year n-1 =RunningSum([Vendas n-1]; ([L01 Exercício]))


*%Var del mes y del year
=If (((RunningSum([Vendas]; ([L01 Período contábil]))/RunningSum([Vendas n-1]; ([L01 Período contábil]))))-1)=(-1) Then "N.A." Else ((RunningSum([Vendas]; ([L01 Período contábil]))/RunningSum([Vendas n-1]; ([L01 Período contábil])))-1)

=If (((RunningSum([Vendas]; ([L01 Exercício]))/RunningSum([Vendas n-1]; ([L01 Exercício]))))-1)=(-1) Then "N.A." Else ((RunningSum([Vendas]; ([L01 Exercício]))/RunningSum([Vendas n-1]; ([L01 Exercício])))-1)

Previous Amount

Running SUM

=If ((RunningSum([Vendas]; ([L01 Período contábil]))/RunningSum([Vendas ano n-1]; ([L01 Período contábil]))))<0 Then "N.A." Else ((RunningSum([Vendas]; ([L01 Período contábil]))/RunningSum([Vendas ano n-1]; ([L01 Período contábil])))-1)


=If (((RunningSum([Vendas]; ([L01 Exercício]))/RunningSum([Vendas ano n-1]; ([L01 Exercício]))))-1)=(-1) Then "N.A." Else ((RunningSum([Vendas]; ([L01 Exercício]))/RunningSum([Vendas ano n-1]; ([L01 Exercício])))-1)



(RunningSum([Vendas]; ([L01 Período contábil]))/RunningSum([Vendas ano n-1]; ([L01 Período contábil])))

Filtro valores mayores que... / Restantes

Filtro de Ventas:(>=200) // SUM(ventas)
Ignorar el filtro: Nofilter ((>=200)) // Nofilter(SUM(sales))

Ej:
Suma de todas las ventas mayores de 200 euros: SUM((>=200))
Suma del resto: Nofilter ((>=200))
Suma de todo: SUM(ventas)

Ordem Meses y Dias --> Configuración regional de Panel Control de Windows

Operadores contextuales

Tenemos:
•in
•Foreach
•Forall
•in Body
•in Block
•in Report
•currentpage

Ejemplos:
Min( In (,)) In
Min( foreach )
Min( forall )
Min( In Report

Obtener %'s sobre el resultado Total

En BEX era muy facil obtener el %sobre el resultado y el resultado total (%CT y %GT).
En BO no es tan directo.
Si tenemos el un importe en euros y quedemos ver el % que cada año supone en el total:
Importe %
2008 100 10
2009 500 50
2010 300 30
Total 1000 100%

Para obtener el %: =/Sum() ForAll
Si con esto navegaramos a otra dimensión, por ej, trimestre, o producto:
%: =/Sum() ForAll
El % se "descuajeringaria".

Lo correcto seria:
= In Body /Sum() In Report

Obtener el año a partir de una fecha y restar 2 años

Coger la fecha de un prompt y restarle para conseguir en año n-2:

FormatNumber((Year(ToDate(UserResponse("Data fixada");""))-2);"####")

A partir del mes-año del prompt y restarle para conseguir en año n-2:

FormatNumber(ToNumber(Right(UserResponse("Mes analise (MMYYYY)");4))-2;"####")