Bisiesto

clear: mes, year, dia, yearmes.
year = COMM_STRUCTURE-CALMONTH(4).
year = year + 1.
mes = COMM_STRUCTURE-CALMONTH+4(2).
dia = COMM_STRUCTURE-CALDAY+6(2).

if mes eq '02'.
concatenate year mes into yearmes.
PERFORM CALCULATE_ULTIMO
USING yearmes
RECORD_NO
RECORD_ALL
SOURCE_SYSTEM
CHANGING RESULT
RETURNCODE.
else.
concatenate year mes dia into RESULT.
endif.

Cuando se copia un mandante respecto a otro se pueden copiar:
 Datos
 Customizing
 Usuarios

Todo lo que es workbench es independiente de mandante.
Si machacamos los usuarios, se borran todos los usuarios no coincidentes que estaban en mandante destino y no en el mandante origen
Si los roles de los usuarios eran diferentes se pierde todo lo que tenían en el mandante destino y pasan a tener todo lo que tenían en el mandante origen.

0HR_PY_1 extractor is not runnig with delta mode

Actually, there are difference when the 0HR_PY_1 extractor is run in
init/delta mode or FULL mode. Please refer to the information provided
from our developer:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
In full mode, the status of this payroll records, which is maintained
for each payroll area in transaction PA03, is NOT considered at all.
This is different in init/delta runs. In this case, we the extractor
needs to decide, whether payroll results can be considered to be
final and are not being overwritten by new payroll runs for the
same period.
This means, as long as a certain payroll period is not closed for
a given payroll area, results which are already on the database
for this period are not getting extracted, as there is the
possibility, that they are getting overwritten again by
a payroll run for the same period.
Once the payroll period is closed in PA03, the results for that
period are considered to be final, and thus extraction will
extract them. You will need to check the status of the payroll
areas in PA03.

Note 1534315 - How to analyse Generic BI data extraction errors

Nº de dados por dimension

No dimensions will contain 30% or more entries compared to the
number of records in the fact tables.
In order to obtain this information:
- Call transaction RSRV.
- Choose "All Elementary Tests" - "Database."
- Double-click the line "Database Information about InfoProvider Tables."
- In the window on the right, choose "Database Information about InfoProvider Tables."
- Enter the InfoCube name and choose "Execute Tests."
- After the analysis finishes, choose "Display Messages" and open the analysis tree with the correct time stamp.

Fechas

=FormatDate([Date];"ddth Mmm yyyy")
=FormatDate(ToDate([Date];"dd/MM/yyyy");"ddth Mmm yyyy")

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