[Tanya] Error pada BI Server

[Reggie Destayoga]

Selamat siang Pak Feris dan rekan-rekan PUG Indonesia.

saya sedang mengalami masalah nih, saya ingin memindahkan Pivot Table yang sudah berhasil saya buat di Mondrian, untuk ditampilkan pada BI Server,

kemudian saya melakukan langkah-langkah yang diajarkan oleh Pak Feris sewaktu training dulu.

sudah saya copy index.xml, index.properties, dan sudah diubah description dan name-nya...

bagian context.xml sudah diubah..

mondrian.jsp sudah sesuai driver dll-nya...

sudah di-copy analysis_customers.analysisview.properties dan analysis_customers.analysisview.xaction

dan diubah namanya menjadi analysis_target_revenue.analysisview.xaction dan analysis_ce.analysisview.properties

spesifikasi dalamnya pun juga sudah diubah

<name>analysis_target_revenue.xaction</name>

<author>M-Stars</author>

<model><![CDATA[MStars/target_revenue.xml]]></model> ... <- relative to pentaho-solutions directory

this is for define cube

<jndi>MStars</jndi> 

<query><![CDATA[select {[Measures].[count_traffic]} on 0,

{[Status].[Semua Status]} on 1

from target_revenue></query> ... <- copy from mondrian.jsp

lalu dijalankan pada BI User Console

Kemudian muncul error seperti ini:

Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.platform.engine.services.solution.SolutionEngine)

Debug: Starting execute of Report//analysis_Target_Cost.analysisview.xaction (org.pentaho.platform.engine.services.solution.SolutionEngine)
Debug: Getting runtime context and data (org.pentaho.platform.engine.services.solution.SolutionEngine)
Debug: Loading action sequence definition file (org.pentaho.platform.engine.services.solution.SolutionEngine)
Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.platform.engine.services.solution.SolutionEngine)

  Server Version: Pentaho Platform Engine Core 3.5.0.RC1.38905

[Feris Thia]

Hi Reggie,

Wah... kayanya sudah mau live neh ;)

Btw.... ini copy-paste dari .xaction nya kan ya Reggie ? Sepertinya kurang tag CDATA nya.

2009/11/6 Reggie Destayoga <dest...@gmail.com>

<query><![CDATA[select {[Measures].[count_traffic]} on 0,

{[Status].[Semua Status]} on 1

from target_revenue></query>

Harusnya:

<query><![CDATA[select {[Measures].[count_traffic]} on 0,

{[Status].[Semua Status]} on 1

from target_revenue]]></query>

Mungkin ini penyebabnya. Bisa dicoba dan kasih feedback lagi ke user group ini apakah berhasil atau ga ?

--
Thanks & Best Regards,

Feris Thia
Business Intelligence Consultant
PT. Putera Handal Indotama
Phone  : +6221-30119353
Fax      : +6221-5513483
Mobile : +628176-474-525
http://www.phi-integration.com
http://pentaho.phi-integration.com

[Feris Thia]

O ya... jangan lupa refresh repository di BI Server ya.

2009/11/6 Feris Thia <fe...@phi-integration.com>

Harusnya:

<query><![CDATA[select {[Measures].[count_traffic]} on 0,

{[Status].[Semua Status]} on 1

from target_revenue]]></query>

[Feris Thia]

Hi Reggie,

Apakah masalahnya sudah terpecahkan ?

2009/11/6 Reggie Destayoga <dest...@gmail.com>

Server Version: Pentaho Platform Engine Core 3.5.0.RC1.38905

[Reggie Destayoga]

pak Feris, setelah saya coba perbaiki yang mungkin salah, yaitu
"]"....kemudian muncul error seperti ini :

2009-11-12 15:45:06,363 WARN
[org.apache.axis2.description.AxisService] Unable to generate EPR for
the transport : http
2009-11-12 15:45:07,804 WARN
[org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We
don't support method overloading. Ignoring [public boolean
deleteConnection
(org.pentaho.platform.dataaccess.datasource.IConnection) throws
org.pentaho.platform.dataaccess.datasource.wizard.service.ConnectionServiceException]
2009-11-12 15:45:07,835 WARN
[org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We
don't support method overloading. Ignoring [public boolean
deleteConnection
(org.pentaho.platform.dataaccess.datasource.IConnection) throws
org.pentaho.platform.dataaccess.datasource.wizard.service.ConnectionServiceException]
2009-11-12 15:45:07,886 WARN
[org.apache.axis2.description.AxisService] Unable to generate EPR for
the transport : http
2009-11-12 15:45:08,141 WARN
[org.apache.axis2.description.AxisService] Unable to generate EPR for
the transport : http
2009-11-12 15:45:08,324 WARN
[org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We
don't support method overloading. Ignoring [public boolean
deleteConnection
(org.pentaho.platform.dataaccess.datasource.IConnection) throws
org.pentaho.platform.dataaccess.datasource.wizard.service.ConnectionServiceException]
2009-11-12 15:45:08,350 WARN
[org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We
don't support method overloading. Ignoring [public boolean
deleteConnection
(org.pentaho.platform.dataaccess.datasource.IConnection) throws
org.pentaho.platform.dataaccess.datasource.wizard.service.ConnectionServiceException]
2009-11-12 15:45:08,402 WARN
[org.apache.axis2.description.AxisService] Unable to generate EPR for
the transport : http
2009-11-12 15:45:48,142 ERROR
[com.tonbeller.jpivot.tags.OlapModelTag]
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error
while creating SQL connection: Anonymous data
source=org.apache.commons.dbcp.BasicDataSource@fa3b39
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:
811)
at mondrian.olap.Util.newInternal(Util.java:1472)
at mondrian.olap.Util.newError(Util.java:1488)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:241)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:189)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:221)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:72)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:959)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:769)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:183)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:106)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:110)
at com.tonbeller.jpivot.mondrian.MondrianModel.initialize
(MondrianModel.java:518)
at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize
(OlapModelDecorator.java:132)
at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize
(OlapModelProxy.java:77)
at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow
(StackStateManager.java:76)
at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow
(OlapModelProxy.java:160)
at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:
81)
at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:838)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service
(JspServletWrapper.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile
(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:188)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:265)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke
(FilterSecurityInterceptor.java:107)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter
(FilterSecurityInterceptor.java:72)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:275)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter
(ExceptionTranslationFilter.java:124)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:275)
at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter
(SwitchUserProcessingFilter.java:341)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:275)
at
org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter
(SecurityStartupFilter.java:85)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:275)
at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter
(AnonymousProcessingFilter.java:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:275)
at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter
(RememberMeProcessingFilter.java:142)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:275)
at
org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter
(RequestParameterAuthenticationFilter.java:169)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:275)
at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter
(BasicProcessingFilter.java:174)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:275)
at org.acegisecurity.ui.AbstractProcessingFilter.doFilter
(AbstractProcessingFilter.java:271)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:275)
at org.acegisecurity.ui.logout.LogoutFilter.doFilter
(LogoutFilter.java:110)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:275)
at
org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter
(HttpSessionReuseDetectionFilter.java:134)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:275)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter
(HttpSessionContextIntegrationFilter.java:249)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:275)
at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter
(SecurityContextHolderAwareRequestFilter.java:81)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:275)
at org.acegisecurity.util.FilterChainProxy.doFilter
(FilterChainProxy.java:149)
at org.acegisecurity.util.FilterToBeanProxy.doFilter
(FilterToBeanProxy.java:98)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:188)
at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter
(SystemStatusFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:188)
at
org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter
(SetCharacterEncodingFilter.java:113)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke
(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service
(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:
665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Unrecognized SQL escape '' at line position
8.)
at org.apache.commons.dbcp.BasicDataSource.createDataSource
(BasicDataSource.java:855)
at org.apache.commons.dbcp.BasicDataSource.getConnection
(BasicDataSource.java:540)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:222)
... 74 more
Caused by: java.sql.SQLException: Unrecognized SQL escape '' at line
position 8.
at net.sourceforge.jtds.jdbc.SQLParser.escape(SQLParser.java:957)
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:1063)
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:156)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery
(JtdsStatement.java:1291)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery
(DelegatingStatement.java:205)
at
org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection
(PoolableConnectionFactory.java:328)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory
(BasicDataSource.java:879)
at org.apache.commons.dbcp.BasicDataSource.createDataSource
(BasicDataSource.java:851)
... 76 more

maksudnya apa ya pak?terima kasih...

On 7 Nov, 22:26, Feris Thia <fe...@phi-integration.com> wrote:
> Hi Reggie,
>
> Apakah masalahnya sudah terpecahkan ?
>

> 2009/11/6 Reggie Destayoga <destay...@gmail.com>

[lisiana]

saya 1 grup dengan reggie dan rovi....
saya ingin bertanya bagaimana membuat virtual cube...
untuk membandingkan antara cube target revenue dengan actual
revenue...
coding virtual cube-nya ditaruh pada .xml yang mana?target revenue
atau actual revenue?
terima kasih...

>         at...
>
> baca lainnya »

[Feris Thia]

Hi Lisiana,

Untuk cube target & actual tetap dibuat masing2, kalau jumlah dan jenis dimensinya berbeda. Tapi kalau sama disatukan fact tablenya.

Kalau memang dipisah dan digabungkan baru menggunakan virtual cube. Buatnya di paling bawah dari skema Mondrian. Berikut adalah potongan konfigurasinya :

=========================================================================================

  <VirtualCube enabled="true" name="Penjualan Aktual vs Target">

    <CubeUsages>

      <CubeUsage cubeName="Penjualan" ignoreUnrelatedDimensions="true">

      </CubeUsage>

      <CubeUsage cubeName="Target" ignoreUnrelatedDimensions="false">

      </CubeUsage>

    </CubeUsages>

    <VirtualCubeDimension name="Produk">

    </VirtualCubeDimension>

    <VirtualCubeDimension name="Waktu">

    </VirtualCubeDimension>

    <VirtualCubeDimension name="Cabang">

    </VirtualCubeDimension>

    <VirtualCubeMeasure cubeName="Penjualan" name="[Measures].[Nilai Penjualan]" visible="true">

    </VirtualCubeMeasure>

    <VirtualCubeMeasure cubeName="Target" name="[Measures].[Nilai Target]" visible="true">

    </VirtualCubeMeasure>

    <CalculatedMember name="Selisih" formula="[Measures].[Nilai Penjualan]-[Measures].[Nilai Target]" dimension="Measures" visible="true">

    </CalculatedMember>

  </VirtualCube>

=========================================================================================

Semoga membantu...

Regards,

Feris

On Thu, Nov 12, 2009 at 5:57 PM, lisiana <lisiana...@gmail.com> wrote:

saya 1 grup dengan reggie dan rovi....
saya ingin bertanya bagaimana membuat virtual cube...
untuk membandingkan antara cube target revenue dengan actual
revenue...
coding virtual cube-nya ditaruh pada .xml yang mana?target revenue
atau actual revenue?
terima kasih...

--
Thanks & Best Regards,

Feris Thia
Business Intelligence Consultant
PT. Putera Handal Indotama
Phone  : +6221-30119353
Fax      : +6221-5513483

[lisiana darmawan]

hi Pak Feris
baru mulai lagi nih, setelah UTS..hehe...
Maksudnya skema mondrian itu yang mana ya, pak?
bukannya yang muncul pada mondrian adalah file .xml yang telah dibuat dari skema workbench? saya buat masing2 untuk target dan actualnya pak..menjadi targetCost.xml dan actualCost.xml.....
kemudian potongan konfigurasi virtual cube-nya ditaruh dimana ya?apakah targetCost.xml atau actualCost.xml. Terima kasih

2009/11/13 Feris Thia <fe...@phi-integration.com>

[Feris Thia]

Hi Lisiana,

Wah... jangan dipisah skemanya. Jadi buat 2 cube dari Schema Workbench. Setelah itu 2 cube itu disatukan dari virtual cube. Dicoba dulu ya.... Tapi perbaiki dulu skemanya.

Regards,

Feris

2009/11/25 lisiana darmawan <lisiana...@gmail.com>

hi Pak Feris
baru mulai lagi nih, setelah UTS..hehe...
Maksudnya skema mondrian itu yang mana ya, pak?
bukannya yang muncul pada mondrian adalah file .xml yang telah dibuat dari skema workbench? saya buat masing2 untuk target dan actualnya pak..menjadi targetCost.xml dan actualCost.xml.....
kemudian potongan konfigurasi virtual cube-nya ditaruh dimana ya?apakah targetCost.xml atau actualCost.xml. Terima kasih