Para utilizar las funciones de modelado en los informes móviles debemos utilizar las funciones siguientes en las tablas, básicamente dándole formato al nombre de la tabla y poniendo la función.
Según el manual tenemos las siguientes opciones:
Este blog tratara de reflejar mis experiencias, perspectivas y reflexiones sobre el mundo del software y hardware en general.
Mostrando entradas con la etiqueta Business Objects. Mostrar todas las entradas
Mostrando entradas con la etiqueta Business Objects. Mostrar todas las entradas
miércoles, 15 de mayo de 2013
jueves, 9 de mayo de 2013
ERR WIS 30270 en Business Objects 4 Windows 2008
La instalación de BO4, tiene un Bug, para solucionarlo debemos tener en cuenta estos puntos:
Con Esto parece resuelto.
- Es recomendable en el servidor tener dos unidades de disco, una para el SO y otra para la instalación de la plataforma.
- El sistema operativo tiene que tener el "Regional Settings" en INGLES
- UAC y Firewall desactivado. Ejecuta siempre los instaladores con botón derecho “run as a administrator.”
- Cuando hayas instalado la plataforma empiezas
con el SP y luego con el patch, bien antes de arrancar cada instalador (run as
a administrator) SAP recomienda: Patch installation on WindowsYou
must have Administrator privileges on your Windows system to run a SAP
BusinessObjects Patch installation.
In order to free resources on the machine on which you are installing this Patch, it is recommended
that you use the Central Management Console (CMC) to stop all of the BI platform servers on the
machine before installing the Patch, with the following exceptions:
• Server Intelligence Agent (SIA)
• Central Management Server (CMS)
• Input and Output File Repository Servers (FRS)
• CMS system database
These services and servers must be running for the installation - SI aun así da problemas, arrancar el servicio con un usuario personalizado , con "regional settings" English.
Con Esto parece resuelto.
miércoles, 14 de marzo de 2012
Business Objetcs 4 en Ipad Vs. Android
Las diferencias mas destacables, se pueden ver en este cuadro comparativo:
extraído de A Test of IPad and Android Tablets with BusinessObjects 4.0 Tools
extraído de A Test of IPad and Android Tablets with BusinessObjects 4.0 Tools
lunes, 27 de febrero de 2012
Temas Resueltos en Fix 12 de Business Objects 4
ADAPT01543794
When rescheduling a recurring schedule with the start time being later than current timestamp creates a new
instance immediately
The new instance is created only at the next scheduled time
Limitations:
New Behavior:
Description:
ADAPT01577972
Using an OLAP MSAS Unx(ODBO mode), WebI shows incorrect and inconsistent results for values over 2
decimal places (for measures)
WebI displays correct decimal values.
Limitations:
New Behavior:
Description:
ADAPT01580632
"Open Document: ERROR INF" is displayed when opening in Viewing mode WebIntelligence reports migrated
from XI 3.x to BI 4.0 using Upgrade Management Tool/
This problem is resolved
Limitations:
New Behavior:
Description:
ADAPT01593059
After importing recurring schedules from Crystal Reports Server 2008 to Crystal Reports 2011, recurring
schedules failed with the error "File fb46d065b195f0.rpt not found on File Repository Server."
The problem is resolved.
Limitations:
New Behavior:
Description:
ADAPT01596275
Refreshing a WebIntelligence report based on BICS access fails with error message similar to "while trying to
invoke the method com.sap.ip.bi.base.application.service.rfcproxy.IRfcFunction.getImportingParameters() of an
object loaded from local variable".
This problem occurs periodically with SAP BusinessObjects Enterprise platform deployment.
Problem is fixed.
Limitations:
New Behavior:
Description:
ADAPT01596686
Dynamic recipients list empty if Web Intelligence Refresh on open active
New Behavior:
Description:
Problem is resolved
Limitations:Problem is resolved
Limitations:
ADAPT01603028
Impossible to place a dimension in the WebIntelligence Filter Bar once the dimension has been removed from its
hierarchy class in Universe Design Tool.
The issue is resolved.
Limitations:
New Behavior:
Description:
ADAPT01603798
Feature Change Source in a webi reports generates an error message "expected element name 'Query' and not
'DP'"
This problem is resolved
Limitations:
New Behavior:
Description:
ADAPT01603883
When trying to run queries that use prompts with the same prompting message, you get the error:.."Cannot build
the query or generate the report. (WIS 30351) (WIS 30351)"
This problem is solved
Limitations:
New Behavior:
Description:
ADAPT01604098
Reports based on an OLAP connection with a fixed user/password are not being shared. This results in higher
resource consumption on BOE as well as on SAP BW.
The problem is resolved.
In order to benefit from the improvement the OLAP connection(s) created prior to SP2 patch 12 needs to be saved
again (just edit and press ‘save’)
Limitations:
New Behavior:
Description:
ADAPT01604100
Performance of viewing live data reports based on an OLAP connection (i.e. SAP BW) degrades as the number of
users concurrently opening the same Crystal Report increases.
The problem is resolved.
Limitations:
New Behavior:
Description:
ADAPT01606511
WSDL Unable to load Url - qaawsWsdl.zip mechanism does not work.
This problem is resolved.
No limitations.
Limitations:
New Behavior:
Description:
ADAPT01606833
Not able to drag and drop objects into the report
The issue is solved
Limitations:
New Behavior:
Description:
ADAPT01607069
In WebIntelligence, Member selector does does not show any members hierachy value when doing a member
selection on Hierrachy on a BICS query
In WebIntelligence, Member selector does shows any members hierachy value when doing a member selection
on Hierrachy on a BICS query
Limitations:
New Behavior:
Description:
ADAPT01607798
Allow user to open saved workspace with node selection retained.
All nodes are persisted in serialized workspace instead of only the last node selected in the prompt.
Limitations:
New Behavior:
Description:
ADAPT01607921
Saved workspaces refreshes with data when opened.
SAP variables are persisted in serialized workspace and data is refreshed in crosstab.
Limitations:
New Behavior:
Description:
ADAPT01608248
An error may occur when opening in WebIntelligence a converted Desktop Intelligence document.
The issue is resolved.
Limitations:
New Behavior:
Description:
ADAPT01608442
WebIntelligence document with charts lable hidden created with XIR3 are not properly opened in BI 4
This issue is fixed
N/A
Limitations:
New Behavior:
Description:
ADAPT01608952
ConnectionServer32 (CS32) is not crashing when running Web Intelligence reports based on UNV built on OLAP
data sources
New Behavior:
Description:
the CS was crashing before this issue is fixed, now on create,refresh or schedule webi document from OLAP
datasource .unv, cs is not crashing and works fine
Limitations:
ADAPT01609462
Decimal places are displayed as zero (0) in WebI report when they are coming from a calculated member which
is defined as 'Percent' in MSAS 2008
Decimal values are correctly displayed in the report.
Limitations:
New Behavior:
Description:
ADAPT01609491
In WebIntelligence, changing a prompt answer on BICS query dimension does not change the related values in
the report
In WebIntelligence, changing a prompt answer on BICS query dimension changes the related values in the report
Limitations:
New Behavior:
Description:
ADAPT01609822
After a session timeout has happened then we are getting an Error message in the Login page.
The issue is Fixed
Limitations:
New Behavior:
Description:
ADAPT01610477
In Crystal Report For Enterprise after changing the Hierarchy Selection value sor the prompt does not change the
result in the report side
In Crystal Report For Enterprise after changing the Hierarchy Selection value sor the prompt changes directly the
result in the report side
Limitations:
New Behavior:
Description:
ADAPT01610507
It is possible to define a Memory Maximum Threshold limit for the WebIntelligenceProcessingServer. If the
WebIntelligenceProcessingServer reaches this limit, it will restart. In some case the
WebIntelligenceProcessingServer crashed during this restart process.
Now the WebIntelligenceProcessingServer will restart without any crash.
Limitations:
New Behavior:
Description:
ADAPT01612189
After the user selected a value for a factorized prompt (different from the default value), an empty LOV is
proposed to the query filter.
This issue is solved
Limitations:
New Behavior:
Description:
ADAPT01612512
When more than 40 users are viewing a Crystal Report concurently (based on SAPBW data source), about 4% of
the requests to view the first page of the report fail.
This happens only when the jobs are shared in the processing server and there are variable think times between
the actions executed by the users.
This issue is completely resolved.
Limitations:
New Behavior:
Description:
ADAPT01613673
NULL errors are produced when attempting to click on table body or header after merging columns in Web
Intelligence editors
This issue is solved.
When rescheduling a recurring schedule with the start time being later than current timestamp creates a new
instance immediately
The new instance is created only at the next scheduled time
Limitations:
New Behavior:
Description:
ADAPT01577972
Using an OLAP MSAS Unx(ODBO mode), WebI shows incorrect and inconsistent results for values over 2
decimal places (for measures)
WebI displays correct decimal values.
Limitations:
New Behavior:
Description:
ADAPT01580632
"Open Document: ERROR INF" is displayed when opening in Viewing mode WebIntelligence reports migrated
from XI 3.x to BI 4.0 using Upgrade Management Tool/
This problem is resolved
Limitations:
New Behavior:
Description:
ADAPT01593059
After importing recurring schedules from Crystal Reports Server 2008 to Crystal Reports 2011, recurring
schedules failed with the error "File fb46d065b195f0.rpt not found on File Repository Server."
The problem is resolved.
Limitations:
New Behavior:
Description:
ADAPT01596275
Refreshing a WebIntelligence report based on BICS access fails with error message similar to "while trying to
invoke the method com.sap.ip.bi.base.application.service.rfcproxy.IRfcFunction.getImportingParameters() of an
object loaded from local variable".
This problem occurs periodically with SAP BusinessObjects Enterprise platform deployment.
Problem is fixed.
Limitations:
New Behavior:
Description:
ADAPT01596686
Dynamic recipients list empty if Web Intelligence Refresh on open active
New Behavior:
Description:
Problem is resolved
Limitations:Problem is resolved
Limitations:
ADAPT01603028
Impossible to place a dimension in the WebIntelligence Filter Bar once the dimension has been removed from its
hierarchy class in Universe Design Tool.
The issue is resolved.
Limitations:
New Behavior:
Description:
ADAPT01603798
Feature Change Source in a webi reports generates an error message "expected element name 'Query' and not
'DP'"
This problem is resolved
Limitations:
New Behavior:
Description:
ADAPT01603883
When trying to run queries that use prompts with the same prompting message, you get the error:.."Cannot build
the query or generate the report. (WIS 30351) (WIS 30351)"
This problem is solved
Limitations:
New Behavior:
Description:
ADAPT01604098
Reports based on an OLAP connection with a fixed user/password are not being shared. This results in higher
resource consumption on BOE as well as on SAP BW.
The problem is resolved.
In order to benefit from the improvement the OLAP connection(s) created prior to SP2 patch 12 needs to be saved
again (just edit and press ‘save’)
Limitations:
New Behavior:
Description:
ADAPT01604100
Performance of viewing live data reports based on an OLAP connection (i.e. SAP BW) degrades as the number of
users concurrently opening the same Crystal Report increases.
The problem is resolved.
Limitations:
New Behavior:
Description:
ADAPT01606511
WSDL Unable to load Url - qaawsWsdl.zip mechanism does not work.
This problem is resolved.
No limitations.
Limitations:
New Behavior:
Description:
ADAPT01606833
Not able to drag and drop objects into the report
The issue is solved
Limitations:
New Behavior:
Description:
ADAPT01607069
In WebIntelligence, Member selector does does not show any members hierachy value when doing a member
selection on Hierrachy on a BICS query
In WebIntelligence, Member selector does shows any members hierachy value when doing a member selection
on Hierrachy on a BICS query
Limitations:
New Behavior:
Description:
ADAPT01607798
Allow user to open saved workspace with node selection retained.
All nodes are persisted in serialized workspace instead of only the last node selected in the prompt.
Limitations:
New Behavior:
Description:
ADAPT01607921
Saved workspaces refreshes with data when opened.
SAP variables are persisted in serialized workspace and data is refreshed in crosstab.
Limitations:
New Behavior:
Description:
ADAPT01608248
An error may occur when opening in WebIntelligence a converted Desktop Intelligence document.
The issue is resolved.
Limitations:
New Behavior:
Description:
ADAPT01608442
WebIntelligence document with charts lable hidden created with XIR3 are not properly opened in BI 4
This issue is fixed
N/A
Limitations:
New Behavior:
Description:
ADAPT01608952
ConnectionServer32 (CS32) is not crashing when running Web Intelligence reports based on UNV built on OLAP
data sources
New Behavior:
Description:
the CS was crashing before this issue is fixed, now on create,refresh or schedule webi document from OLAP
datasource .unv, cs is not crashing and works fine
Limitations:
ADAPT01609462
Decimal places are displayed as zero (0) in WebI report when they are coming from a calculated member which
is defined as 'Percent' in MSAS 2008
Decimal values are correctly displayed in the report.
Limitations:
New Behavior:
Description:
ADAPT01609491
In WebIntelligence, changing a prompt answer on BICS query dimension does not change the related values in
the report
In WebIntelligence, changing a prompt answer on BICS query dimension changes the related values in the report
Limitations:
New Behavior:
Description:
ADAPT01609822
After a session timeout has happened then we are getting an Error message in the Login page.
The issue is Fixed
Limitations:
New Behavior:
Description:
ADAPT01610477
In Crystal Report For Enterprise after changing the Hierarchy Selection value sor the prompt does not change the
result in the report side
In Crystal Report For Enterprise after changing the Hierarchy Selection value sor the prompt changes directly the
result in the report side
Limitations:
New Behavior:
Description:
ADAPT01610507
It is possible to define a Memory Maximum Threshold limit for the WebIntelligenceProcessingServer. If the
WebIntelligenceProcessingServer reaches this limit, it will restart. In some case the
WebIntelligenceProcessingServer crashed during this restart process.
Now the WebIntelligenceProcessingServer will restart without any crash.
Limitations:
New Behavior:
Description:
ADAPT01612189
After the user selected a value for a factorized prompt (different from the default value), an empty LOV is
proposed to the query filter.
This issue is solved
Limitations:
New Behavior:
Description:
ADAPT01612512
When more than 40 users are viewing a Crystal Report concurently (based on SAPBW data source), about 4% of
the requests to view the first page of the report fail.
This happens only when the jobs are shared in the processing server and there are variable think times between
the actions executed by the users.
This issue is completely resolved.
Limitations:
New Behavior:
Description:
ADAPT01613673
NULL errors are produced when attempting to click on table body or header after merging columns in Web
Intelligence editors
This issue is solved.
miércoles, 19 de octubre de 2011
Integración Business Objects XI 3.1 con Ipad
Recientemente en el App Store, se ha publicado la aplicación SAP Mobile BI, esta aplicación esta diseñada especialmente para el entorno de Business Objects 4.0. Pero si en nuestra arquitectura disponemos de la versión 3.1, podemos hacerlo funcionar, siguiendo los siguientes pasos:
- Realizar Backup de nuestro servidor a nivel imagen o sanpshot.
- Instalar el Service pack 4 de BO XI Edje 3.1 Server components , disponible en el MarketPlace.
- Instalar el Service pack 4 de BO XI Edje 3.1 Client components , disponible en el MarketPlace.
- Instalar el Service pack 4 de BO XI Edje 3.1 Mobile , disponible en el MarketPlace.
- Configurar el Tomcat con el servicio Mobile.
- Una vez realizados los puntos anteriores, dentro de BO debemos asignar a los informes que deseamos utilizar la categoría de mobile.
- Instalar la app SAP Mobile BI en el Ipad disponible en el appStore y acceder a nuestro BO.
- Se tendrán que realizar cambios en los informes, pero tranquilos son poco laboriosos. Sobretodo de diseño.
Como conclusión podemos decir, que además de implementar el servidor Mobile en BO, tenemos que modificar los documentos en Webi según el modelo de dispositivo que vamos a utilizar, en gran medida podremos “reutilizar” algunos informes.
Como dato importante, decir que los informes de Xcelsius tampoco se verán con esta actualización, lo que sí permite es ver informes Webi que actualmente se quedan colgados o no realizan las funciones adecuadamente, si se entra modo Safari en el iPad.
Para los informes de Xcelsius, según los propios foros de Sap se recomienda el uso de Roambi .
Un ejemplo de BO mobile BI, funcionando en un Ipad.
martes, 9 de agosto de 2011
SAP BW y Busisness Objects
Recientemente he estado trabajando con las herramientas de SAP Datawarehouse 7.0 y Business Objects Versión 3.1. Mi experiencia es que la interacción desde Business Objects y SAP BW tiene muchas lagunas a mejorar.
Según he estado leyendo y he visto en demos, la versión 4.0 de BO mejora muchas prestaciones, de las cuales destaco las siguientes:
- La interacción no es total, ya que depende de querys de BI.
- Xcelsius falla mucho a la hora de publicar informes , solamente funciona medianamente bien a partir del service pack 3.
- Las estructuras se pierden al hacer actualizaciones de universos, etc.
- Las jerarquías en veo no son posibles , a la vez que en el entrono de BI si lo son.
Según he estado leyendo y he visto en demos, la versión 4.0 de BO mejora muchas prestaciones, de las cuales destaco las siguientes:
- Querys directamente a cubo, desde Business Objects.
- Webi con HML 5, mucha mejora en el entorno
- Permite la generación de informes para Ipad.
Suscribirse a:
Entradas (Atom)