Problem solved with tutorial:  
<https://kylin.apache.org/docs/tutorial/quick_start_for_mdx.html> 
https://kylin.apache.org/docs/tutorial/quick_start_for_mdx.html

 

 

From: Łukasz Stefański SoSimple <[email protected]> 
Sent: Wednesday, April 12, 2023 4:07 PM
To: [email protected]
Subject: MDX interface for EXCEL from Docker image gets login failed 

 

Hi 

I am using docker kylin for now. But after buidling the cube I discovered that 
it is not possible to connect to CUBE from EXCEL or POWERBI. 

I am getting login failed for user ADMIN/KYLIN. 

 

Bellow logs shows login try from excel :

 

File mdx.log : 

 

2023-04-07 04:02:59,273 [WARN ] [Query f3f4b028-1bde-4c2d-e1a6-e1d0d219d3c1] 
i.k.m.i.s.f.MdxServiceFilter.doFilter - [MDX-04010001] please add auth info in 
your request.

2023-04-07 04:02:59,331 [INFO ] [Query 5202bd61-6de4-5925-12c9-c43ccb98a3a6] 
i.k.m.w.x.MdxXmlaServlet.prepareMondrianSchema - begin init datasource, 
username=ANALYST, project=learn_kylin

2023-04-07 04:02:59,331 [ERROR] [Query 5202bd61-6de4-5925-12c9-c43ccb98a3a6] 
i.k.m.i.s.f.MdxServiceFilter.doFilter - internal error

io.kylin.mdx.insight.common.SemanticException: The connection user information 
or password maybe empty or has been changed, please contact system admin to 
update in Configuration page under Management.

        at 
io.kylin.mdx.insight.core.support.SemanticFacade.getSemanticProjectByUser(SemanticFacade.java:62)
 ~[semantic-core-1.2.0.jar!/:?]

        at 
io.kylin.mdx.core.service.ModelManager.buildMondrianSchemaFromDataSet(ModelManager.java:70)
 ~[mdx-1.2.0.jar!/:?]

        at 
io.kylin.mdx.web.xmla.XmlaDatasource.loadMdnSchemas(XmlaDatasource.java:108) 
~[mdx-1.2.0.jar!/:?]

        at 
io.kylin.mdx.web.xmla.XmlaDatasource.initDatasource(XmlaDatasource.java:90) 
~[mdx-1.2.0.jar!/:?]

        at 
io.kylin.mdx.web.xmla.MdxXmlaServlet.prepareMondrianSchema(MdxXmlaServlet.java:216)
 ~[mdx-1.2.0.jar!/:?]

        at 
io.kylin.mdx.web.xmla.MdxXmlaServlet.process(MdxXmlaServlet.java:103) 
~[mdx-1.2.0.jar!/:?]

        at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:119) 
~[olap4j-xmlaserver-1.2.0.jar!/:?]

 

Can you please help to fix this docker setup ? 

 

Łukasz 

Reply via email to