[Mondrian] Mondrian Digest, Vol 101, Issue 8

Murtaza Ghodawala murtaza.ghodawala at alshaya.com
Sun May 3 06:38:45 EDT 2015


Hi Matt,

We are trying  to use Cloudera 5.x IMPALA with Mondrian using Pentaho EE
5.x. There are two problems we are facing, 

1. Cloudera IMPALA drivers in Pentaho is not able to connect to specific
database in IMPALA. It is always connecting to "default" database. To
overcome this, we have created JNDI using our Cloudera Impala JDBCv3
drivers. Now we are able to see other databases in IMPALA and can create
star schema.

2. We can create Analysis report in Pentaho User Console using the IMPALA
datasource created above and all the dimensions and measures (Star Schema)
is showing perfectly fine. Data is coming appropriately in Pentaho Analysis
report.

3. When we try to access this Datasource as Catalogue using XML/A in Excel
file, it gives error on choosing any field from pivot table. On checking
Pentaho logs, there are errors in MDX queries of Mondrian. Below are some of
the errors from log files. Please suggest us how can we access Mondrian
cubes in Excel using XML/A.

2015/04/30 15:09:51 - ImpalaDefault - Creating database connection pool for
'ImpalaDefault'...
2015/04/30 15:09:51 - ImpalaDefault - Successfully created database
connection pool for 'ImpalaDefault'
15:12:33,048 ERROR [XmlaServlet] Errors when handling XML/A message
mondrian.xmla.XmlaException: Mondrian Error:XMLA MDX execute failed
	at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1734)
	at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:759)
	at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:674)
	at
mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java
:507)
	at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:318)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:290)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
	at
org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(Penta
hoWebContextFilter.java:185)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
	at
org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(P
entahoRequestContextFilter.java:87)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
	at
org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilt
er(FilterChainProxy.java:378)
	at
org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(
FilterSecurityInterceptor.java:109)
	at
org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilte
r(FilterSecurityInterceptor.java:83)
	at
org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilt
er(FilterChainProxy.java:390)
	at
org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(Exce
ptionTranslationFilter.java:101)
	at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurity
Filter.java:53)
	at
org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilt
er(FilterChainProxy.java:390)
	at
org.springframework.security.providers.anonymous.AnonymousProcessingFilter.d
oFilterHttp(AnonymousProcessingFilter.java:105)
	at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurity
Filter.java:53)
	at
org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilt
er(FilterChainProxy.java:390)
	at
org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.
doFilter(RequestParameterAuthenticationFilter.java:191)
	at
org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilt
er(FilterChainProxy.java:390)
	at
org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp
(BasicProcessingFilter.java:174)
	at
org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilter
Http(PentahoBasicProcessingFilter.java:115)
	at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurity
Filter.java:53)
	at
org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilt
er(FilterChainProxy.java:390)
	at
org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(Abstra
ctProcessingFilter.java:278)
	at com.pentaho.platform.security.a.doFilterHttp(SourceFile:62)
	at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurity
Filter.java:53)
	at
org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilt
er(FilterChainProxy.java:390)
	at
org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilte
r.java:89)
	at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurity
Filter.java:53)
	at
org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilt
er(FilterChainProxy.java:390)
	at
org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFil
ter(HttpSessionReuseDetectionFilter.java:133)
	at
org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilt
er(FilterChainProxy.java:390)
	at
org.springframework.security.context.HttpSessionContextIntegrationFilter.doF
ilterHttp(HttpSessionContextIntegrationFilter.java:235)
	at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurity
Filter.java:53)
	at
org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilt
er(FilterChainProxy.java:390)
	at
org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFi
lter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263)
	at
org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilt
er(FilterChainProxy.java:390)
	at
org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter
.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
	at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurity
Filter.java:53)
	at
org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilt
er(FilterChainProxy.java:390)
	at
org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy
.java:175)
	at
org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanPro
xy.java:99)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
	at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:87)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
	at
org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(Se
tCharacterEncodingFilter.java:114)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
	at
org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(We
bappRootForwardingFilter.java:70)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
	at
org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(Pen
tahoPathDecodingFilter.java:34)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:233)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
	at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase
.java:470)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127
)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103
)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:109)
	at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
	at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http
11Protocol.java:606)
	at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.olap4j.OlapException: mondrian gave exception while executing
query
	at
mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap
4jConnection.java:858)
	at
mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOla
p4jStatement.java:423)
	at
mondrian.olap4j.MondrianOlap4jPreparedStatement.executeQuery(MondrianOlap4jP
reparedStatement.java:72)
	at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1711)
	... 74 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error:
Error while executing query [select NON EMPTY
Hierarchize(AddCalculatedMembers({DrilldownLevel({[CUSTOMERS.CUSTOMERNAME].[
All CUSTOMERS.CUSTOMERNAMEs]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS
from [ImpalaDS]
]
	at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977)
	at mondrian.olap.Util.newInternal(Util.java:2404)
	at mondrian.olap.Util.newError(Util.java:2420)
	at
mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:707)
	at
mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52)
	at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:623)
	at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:622)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
	... 1 more
Caused by: mondrian.olap.MondrianException: Mondrian
Error:mondrian.olap.MondrianException: Mondrian Error:Failed to load segment
form SQL
	at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:240)
	at
mondrian.rolap.agg.SegmentLoader.access$000(SegmentLoader.java:51)
	at
mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:
166)
	at
mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:
140)
	... 4 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Failed to load
segment form SQL
	at
mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:643)
	at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:195)
	... 7 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error:
Error while loading segment; sql=[select sum(`ORDERFACT`.`ORDERLINENUMBER`)
as `m0` from `bigdata`.`ORDERFACT` `ORDERFACT`]
	at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977)
	at mondrian.olap.Util.newInternal(Util.java:2404)
	at mondrian.olap.Util.newError(Util.java:2420)
	at mondrian.rolap.SqlStatement.handle(SqlStatement.java:352)
	at mondrian.rolap.SqlStatement.execute(SqlStatement.java:252)
	at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:350)
	at
mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:625)
	... 8 more
Caused by: java.lang.IndexOutOfBoundsException: Index: 1, Size: 1
	at java.util.ArrayList.rangeCheck(Unknown Source)
	at java.util.ArrayList.get(Unknown Source)
	at mondrian.rolap.SqlStatement.guessTypes(SqlStatement.java:419)
	at mondrian.rolap.SqlStatement.execute(SqlStatement.java:241)
	... 10 more


Thanks and Regards,

Murtaza Ghodawala

Lead - Technology, R&D | eGroup
M.H. Alshaya Co. W.L.L.
Retail Division
P.O Box 181, Safat 13002, Kuwait
Phone: (+965) 2224 2063, Fax: (+965) 2224 2488, Mob: (+965) 97180549
www.alshaya.com

-----Original Message-----
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of mondrian-request at pentaho.org
Sent: Thursday, April 30, 2015 7:00 PM
To: mondrian at pentaho.org
Subject: Mondrian Digest, Vol 101, Issue 8

Send Mondrian mailing list submissions to
	mondrian at pentaho.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.pentaho.org/mailman/listinfo/mondrian
or, via email, send a message with subject or body 'help' to
	mondrian-request at pentaho.org

You can reach the person managing the list at
	mondrian-owner at pentaho.org

When replying, please edit your Subject line so it is more specific than
"Re: Contents of Mondrian digest..."


Today's Topics:

   1. Regarding Mondrian 3..9.x WAR file on Tomcat (Murtaza Ghodawala)
   2. Re: Regarding Mondrian 3..9.x WAR file on Tomcat (Matt Campbell)


----------------------------------------------------------------------

Message: 1
Date: Thu, 30 Apr 2015 08:50:15 +0300
From: Murtaza Ghodawala <murtaza.ghodawala at alshaya.com>
Subject: [Mondrian] Regarding Mondrian 3..9.x WAR file on Tomcat
To: <mondrian at pentaho.org>
Cc: <mondrian at pentaho.org>
Message-ID: <002f01d08309$8853c500$98fb4f00$@alshaya.com>
Content-Type: text/plain; charset="us-ascii"

Dear All,

 

Can anyone suggest me from where to get Mondrian 3.9.x WAR file, which I can
deploy it on Tomcat server. Currently only Mondrian.jar file is getting
downloaded from SourceForge website. We want to create OLAP cubes on BigData
and access this cubes in Excel over XML/A interface. Are we going into the
right direction?

 

Appreciate your quick response and support.

 

 

Thanks and Regards,

 

Murtaza Ghodawala

Lead - Technology, R&D | eGroup
M.H. Alshaya Co. W.L.L.
Retail Division
P.O Box 181, Safat 13002, Kuwait
Phone: (+965) 2224 2063, Fax: (+965) 2224 2488, Mob: (+965) 97180549
www.alshaya.com

 

============================================================================
================================================================
Alshaya Confidentiality Notice & Disclaimer This email and any attached or
transmitted files may contain confidential and/or privileged information and
are intended solely for the addressee(s) named. If you have received this
information in error, please notify the sender by return email, do not
redistribute this email message, delete it immediately and keep no copies of
it.  All opinions expressed in this email are solely those of the author and
do not necessarily represent those of Alshaya.  Neither this email nor any
attached or transmitted files constitute a binding commitment on behalf of
Alshaya.  Any purported commitment or purchase order is subject to final
approval in accordance with our internal procedures and subject to contract
in accordance with the relevant laws.  References to Alshaya include M.H.
Alshaya Co. W.L.L. and all its affiliated companies.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.pentaho.org/pipermail/mondrian/attachments/20150430/1073200b/at
tachment-0001.html 

------------------------------

Message: 2
Date: Thu, 30 Apr 2015 12:20:55 +0000
From: Matt Campbell <mcampbell at pentaho.com>
Subject: Re: [Mondrian] Regarding Mondrian 3..9.x WAR file on Tomcat
To: Mondrian developer mailing list <mondrian at pentaho.org>
Message-ID:
	
<BLUPR06MB692F70C8D1957404A30F092A9D60 at BLUPR06MB692.namprd06.prod.outlook.co
m>
	
Content-Type: text/plain; charset="us-ascii"


Unfortunately we haven't distributed a war file for a while.  The war file
was intended as a quick start sample and had dependence on some ancient
jpivot libraries, and we haven't gotten around to cleaning that up.  To get
started now we typically recommend trying out the pentaho ce distribution,
which allows running  over XMLA.

Regarding Excel over XMLA, that's not officially supported, but there is an
active project that I've heard good things about:
http://sourceforge.net/projects/xmlaconnect/

What is your datasource?


From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Murtaza Ghodawala
Sent: Thursday, April 30, 2015 1:50 AM
To: mondrian at pentaho.org
Cc: mondrian at pentaho.org
Subject: [Mondrian] Regarding Mondrian 3..9.x WAR file on Tomcat
Importance: High

Dear All,

Can anyone suggest me from where to get Mondrian 3.9.x WAR file, which I can
deploy it on Tomcat server. Currently only Mondrian.jar file is getting
downloaded from SourceForge website. We want to create OLAP cubes on BigData
and access this cubes in Excel over XML/A interface. Are we going into the
right direction?

Appreciate your quick response and support.


Thanks and Regards,

Murtaza Ghodawala

Lead - Technology, R&D | eGroup
M.H. Alshaya Co. W.L.L.
Retail Division
P.O Box 181, Safat 13002, Kuwait
Phone: (+965) 2224 2063, Fax: (+965) 2224 2488, Mob: (+965) 97180549
www.alshaya.com

________________________________
Alshaya Confidentiality Notice & Disclaimer This email and any attached or
transmitted files may contain confidential and/or privileged information and
are intended solely for the addressee(s) named. If you have received this
information in error, please notify the sender by return email, do not
redistribute this email message, delete it immediately and keep no copies of
it. All opinions expressed in this email are solely those of the author and
do not necessarily represent those of Alshaya. Neither this email nor any
attached or transmitted files constitute a binding commitment on behalf of
Alshaya. Any purported commitment or purchase order is subject to final
approval in accordance with our internal procedures and subject to contract
in accordance with the relevant laws. References to Alshaya include M.H.
Alshaya Co. W.L.L. and all its affiliated companies.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.pentaho.org/pipermail/mondrian/attachments/20150430/5a8bbaa9/at
tachment-0001.html 

------------------------------

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian


End of Mondrian Digest, Vol 101, Issue 8
****************************************



More information about the Mondrian mailing list