pada node new dimension 0, muncul node table maka kita akan melakukan
select table yang akan dipilih.
table yang ada pada database itu sudah bisa muncul, tetapi tanda "x"
nya tdk mau hilang.
dan pada bagian bawah selalu ada bacaan "schema must be set" ,
"table is invalid", hirearcy is invalid" apakah ada settingan yang kurang
sehingga muncul tulisan seperti diatas.
--
Anda menerima pesan ini karena Anda telah terdaftar di Google
Groups "Pentaho User Group - Indonesia".
Untuk mengirim pesan ke grup ini, kirimkan email ke penta...@googlegroups.com
Untuk berhenti mendapatkan email dari grup ini,silahkan kirim email ke
pentaho-id+...@googlegroups.com
Untuk opsi lainnya, silahkan kunjungi http://groups.google.com/group/pentaho-id?hl=id.
Untuk artikel teknis Pentaho dari PHI-Integration.com, silahkan kunjungi http://pentaho.phi-integration.com.
Milis terkait : http://groups.google.com/group/indo-bi
Link knowledge base lainnya : http://www.belajarsql.com.
udah aku kasih nama ko schema nya... tapi tetep aja ada tanda x berwarna merahya dan masih invalid...
pake Mysql pak.... :)
pak bambang
kalo yang saya pas dihubungkan ke mdx query nya muncul bacaan
"mondrain connection could not be done for - schema2.xml"
Pada tanggal 25/07/11, Bambang sistriadianto
<bambang.si...@gmail.com> menulis:
di add table list dari table nya bisa keluar ko... saya bisa memilih
tabel dari DB yang saya koneksikan.
yang ga keluar tuh list dari attribute schema nya.. jadi mesti "must
be set schema" muncul aja bacaan itu.. terus pada saat menghubungkan
ke mdxquery muncul bacaan
"mondrain connection could not be done for - schema1.xml"
tapi ntr say coba yang versi terbaru dulu deh....
terimakasih :)
Pada tanggal 26/07/11, Bambang sistriadianto
org.apache.jasper.JasperException: An exception occurred processing JSP page /testpage.jsp at line 44 41: 42: 43: <%-- include query and title, so this jsp may be used with different queries --%> 44: 45: 46: 47: Stacktrace: at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:519) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:410) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:264) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: javax.servlet.ServletException: javax.servlet.jsp.JspException: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:mysql://localhost:/labif2; JdbcUser=sa; JdbcPassword=sa at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:861) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:794) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:246) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386) ... 19 more Caused by: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:mysql://localhost:/labif2; JdbcUser=sa; JdbcPassword=sa at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:536) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:410) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488) at com.tonbeller.wcf.utils.IncludeTag.doStartTag(IncludeTag.java:59) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005finclude_005f0(testpage_jsp.java:269) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:126) ... 22 more Caused by: javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:mysql://localhost:/labif2; JdbcUser=sa; JdbcPassword=sa at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:861) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:794) at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:85) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386) ... 33 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:mysql://localhost:/labif2; JdbcUser=sa; JdbcPassword=sa at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:841) at mondrian.olap.Util.newInternal(Util.java:1539) at mondrian.olap.Util.newError(Util.java:1555) at mondrian.rolap.RolapConnection.(RolapConnection.java:233) at mondrian.rolap.RolapSchema.(RolapSchema.java:184) at mondrian.rolap.RolapSchema.(RolapSchema.java:228) at mondrian.rolap.RolapSchema.(RolapSchema.java:54) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:986) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:783) at mondrian.rolap.RolapConnection.(RolapConnection.java:166) at mondrian.rolap.RolapConnection.(RolapConnection.java:95) 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.WEB_002dINF.queries.mondrian_jsp._jspx_meth_jp_005fmondrianQuery_005f0(mondrian_jsp.java:136) at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:69) ... 36 more Caused by: java.sql.SQLException: Must specify port after ':' in connection string at com.mysql.jdbc.NonRegisteringDriver.parseHostPortPair(NonRegisteringDriver.java:164) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2534) at com.mysql.jdbc.Connection.(Connection.java:1485) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:154) at mondrian.rolap.RolapConnection$DriverManagerDataSource.getConnection(RolapConnection.java:699) at mondrian.rolap.RolapConnection.(RolapConnection.java:213) ... 52 more
javax.servlet.ServletException: javax.servlet.jsp.JspException: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:mysql://localhost:/labif2; JdbcUser=sa; JdbcPassword=sa at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:861) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:794) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:246) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:264) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:mysql://localhost:/labif2; JdbcUser=sa; JdbcPassword=sa at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:536) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:410) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488) at com.tonbeller.wcf.utils.IncludeTag.doStartTag(IncludeTag.java:59) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005finclude_005f0(testpage_jsp.java:269) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:126) ... 22 more Caused by: javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:mysql://localhost:/labif2; JdbcUser=sa; JdbcPassword=sa at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:861) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:794) at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:85) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386) ... 33 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:mysql://localhost:/labif2; JdbcUser=sa; JdbcPassword=sa at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:841) at mondrian.olap.Util.newInternal(Util.java:1539) at mondrian.olap.Util.newError(Util.java:1555) at mondrian.rolap.RolapConnection.(RolapConnection.java:233) at mondrian.rolap.RolapSchema.(RolapSchema.java:184) at mondrian.rolap.RolapSchema.(RolapSchema.java:228) at mondrian.rolap.RolapSchema.(RolapSchema.java:54) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:986) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:783) at mondrian.rolap.RolapConnection.(RolapConnection.java:166) at mondrian.rolap.RolapConnection.(RolapConnection.java:95) 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.WEB_002dINF.queries.mondrian_jsp._jspx_meth_jp_005fmondrianQuery_005f0(mondrian_jsp.java:136) at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:69) ... 36 more Caused by: java.sql.SQLException: Must specify port after ':' in connection string at com.mysql.jdbc.NonRegisteringDriver.parseHostPortPair(NonRegisteringDriver.java:164) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2534) at com.mysql.jdbc.Connection.(Connection.java:1485) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:154) at mondrian.rolap.RolapConnection$DriverManagerDataSource.getConnection(RolapConnection.java:699) at mondrian.rolap.RolapConnection.(RolapConnection.java:213) ... 52 more
org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:mysql://localhost:/labif2; JdbcUser=sa; JdbcPassword=sa at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:536) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:410) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488) at com.tonbeller.wcf.utils.IncludeTag.doStartTag(IncludeTag.java:59) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005finclude_005f0(testpage_jsp.java:269) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:126) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:264) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:mysql://localhost:/labif2; JdbcUser=sa; JdbcPassword=sa at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:861) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:794) at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:85) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386) ... 33 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:mysql://localhost:/labif2; JdbcUser=sa; JdbcPassword=sa at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:841) at mondrian.olap.Util.newInternal(Util.java:1539) at mondrian.olap.Util.newError(Util.java:1555) at mondrian.rolap.RolapConnection.(RolapConnection.java:233) at mondrian.rolap.RolapSchema.(RolapSchema.java:184) at mondrian.rolap.RolapSchema.(RolapSchema.java:228) at mondrian.rolap.RolapSchema.(RolapSchema.java:54) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:986) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:783) at mondrian.rolap.RolapConnection.(RolapConnection.java:166) at mondrian.rolap.RolapConnection.(RolapConnection.java:95) 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.WEB_002dINF.queries.mondrian_jsp._jspx_meth_jp_005fmondrianQuery_005f0(mondrian_jsp.java:136) at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:69) ... 36 more Caused by: java.sql.SQLException: Must specify port after ':' in connection string at com.mysql.jdbc.NonRegisteringDriver.parseHostPortPair(NonRegisteringDriver.java:164) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2534) at com.mysql.jdbc.Connection.(Connection.java:1485) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:154) at mondrian.rolap.RolapConnection$DriverManagerDataSource.getConnection(RolapConnection.java:699) at mondrian.rolap.RolapConnection.(RolapConnection.java:213) ... 52 more
javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:mysql://localhost:/labif2; JdbcUser=sa; JdbcPassword=sa at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:861) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:794) at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:85) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488) at com.tonbeller.wcf.utils.IncludeTag.doStartTag(IncludeTag.java:59) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005finclude_005f0(testpage_jsp.java:269) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:126) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:264) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:mysql://localhost:/labif2; JdbcUser=sa; JdbcPassword=sa at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:841) at mondrian.olap.Util.newInternal(Util.java:1539) at mondrian.olap.Util.newError(Util.java:1555) at mondrian.rolap.RolapConnection.(RolapConnection.java:233) at mondrian.rolap.RolapSchema.(RolapSchema.java:184) at mondrian.rolap.RolapSchema.(RolapSchema.java:228) at mondrian.rolap.RolapSchema.(RolapSchema.java:54) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:986) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:783) at mondrian.rolap.RolapConnection.(RolapConnection.java:166) at mondrian.rolap.RolapConnection.(RolapConnection.java:95) 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.WEB_002dINF.queries.mondrian_jsp._jspx_meth_jp_005fmondrianQuery_005f0(mondrian_jsp.java:136) at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:69) ... 36 more Caused by: java.sql.SQLException: Must specify port after ':' in connection string at com.mysql.jdbc.NonRegisteringDriver.parseHostPortPair(NonRegisteringDriver.java:164) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2534) at com.mysql.jdbc.Connection.(Connection.java:1485) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:154) at mondrian.rolap.RolapConnection$DriverManagerDataSource.getConnection(RolapConnection.java:699) at mondrian.rolap.RolapConnection.(RolapConnection.java:213) ... 52 more
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:mysql://localhost:/labif2; JdbcUser=sa; JdbcPassword=sa at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:841) at mondrian.olap.Util.newInternal(Util.java:1539) at mondrian.olap.Util.newError(Util.java:1555) at mondrian.rolap.RolapConnection.(RolapConnection.java:233) at mondrian.rolap.RolapSchema.(RolapSchema.java:184) at mondrian.rolap.RolapSchema.(RolapSchema.java:228) at mondrian.rolap.RolapSchema.(RolapSchema.java:54) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:986) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:783) at mondrian.rolap.RolapConnection.(RolapConnection.java:166) at mondrian.rolap.RolapConnection.(RolapConnection.java:95) 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.WEB_002dINF.queries.mondrian_jsp._jspx_meth_jp_005fmondrianQuery_005f0(mondrian_jsp.java:136) at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:69) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488) at com.tonbeller.wcf.utils.IncludeTag.doStartTag(IncludeTag.java:59) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005finclude_005f0(testpage_jsp.java:269) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:126) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:264) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: java.sql.SQLException: Must specify port after ':' in connection string at com.mysql.jdbc.NonRegisteringDriver.parseHostPortPair(NonRegisteringDriver.java:164) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2534) at com.mysql.jdbc.Connection.(Connection.java:1485) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:154) at mondrian.rolap.RolapConnection$DriverManagerDataSource.getConnection(RolapConnection.java:699) at mondrian.rolap.RolapConnection.(RolapConnection.java:213) ... 52 more
java.sql.SQLException: Must specify port after ':' in connection string at com.mysql.jdbc.NonRegisteringDriver.parseHostPortPair(NonRegisteringDriver.java:164) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2534) at com.mysql.jdbc.Connection.(Connection.java:1485) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:154) at mondrian.rolap.RolapConnection$DriverManagerDataSource.getConnection(RolapConnection.java:699) at mondrian.rolap.RolapConnection.(RolapConnection.java:213) at mondrian.rolap.RolapSchema.(RolapSchema.java:184) at mondrian.rolap.RolapSchema.(RolapSchema.java:228) at mondrian.rolap.RolapSchema.(RolapSchema.java:54) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:986) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:783) at mondrian.rolap.RolapConnection.(RolapConnection.java:166) at mondrian.rolap.RolapConnection.(RolapConnection.java:95) 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.WEB_002dINF.queries.mondrian_jsp._jspx_meth_jp_005fmondrianQuery_005f0(mondrian_jsp.java:136) at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:69) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488) at com.tonbeller.wcf.utils.IncludeTag.doStartTag(IncludeTag.java:59) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005finclude_005f0(testpage_jsp.java:269) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:126) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:264) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662)pemecahan masalahnya bagaimana ya?
2011/8/1, Fanni Zoraya <zoraya...@gmail.com>:
> aku pernah baca tentang eror mondrain yang di kirim pak Bambang...
> aku juga punya masalah nih pas klik JPivot pivot
> table<http://localhost:8080/mondrian/testpage.jsp?query=mondrian>ketemu
Jdbc=jdbc:mysql://localhost:/labif2; JdbcUser=sa; JdbcPassword=sa
select NON EMPTY {[Measures].[Tahun
Ajaran],[Measures].[Matakuliah],[Measures].[Asisten]} ON COLUMNS,
NON EMPTY Crossjoin (hierarchize({[D_Asisten].[All
Asisten],[D_Jadual].[All Jadual],[D_Matkul].[All
Matkuk],[D_Jabatan].[All Jabatan],[D_Mahasiswa].[All Mahasiswa]})) ON
ROWS
FROM [akademik]
kesalahan yang muncul
Mondrian Error:MDX object '[Jadual].[All Jadual]' not found in cube 'Akademik'
bisa mnta tolong jelaskan apa yang salah.. saya bener" ga ngerti :(
terimakasih
Pada tanggal 10/08/11, Fanni Zoraya <zoraya...@gmail.com> menulis:
>> Mondrian Error:Syntax error at line 2, column 22, token '{'
ini syntax nya
select NON EMPTY {[Measures].[Tahun Ajaran],[Measures].[Golongan]} ON COLUMNS,
NON EMPTY Crossjoin
{(hierarchize([Asisten].[Asisten],[Jadual].[Jadual],[Matkul].[Matkul],[Jabatan].[Jabatan])})
ON ROWS
FROM [Akademik]
yang salah apanya ya??
mohon bantuannya... ^^
terimakasih :)
Pada tanggal 11/08/11, indra pradana <indr...@gmail.com> menulis:
Mondrian Error:No function matches signature '(<Member>, <Level>,
<Level>, <Level>)'
ini querynya
select NON EMPTY {[Measures].[Tahun Ajaran]} ON COLUMNS,
NON EMPTY {([Asisten].[All
Asisten],[Jadual].[Jadual],[Matkul].[Matkul],[Jabatan].[Jabatan])} ON
ROWS
FROM [Akademik]
saya belum ngerti mdx querynya.. tabel dimensi,level dan member harus
ditaro dimana sehingga logikanya dapet dan mana yang akan di eksekusi
sehingga tidak error..
mohon bantuannya.....saya ingin cepet sidang tugas akhir..pak Bambang,
Pak Indra, Pak Feris... huhuhu.......:)
Terimakasih
Pada tanggal 12/08/11, Bambang sistriadianto
<bambang.si...@gmail.com> menulis:
atau
dimensi : tahunajaran
hirarki : detiltahunajaran
level 1 : semester
level 2 : namatahunajaran
semoga dengan analogi tsb bisa membantu
->> kalo pda measure kita bisa menghitung rata" ga?
misalnya ingin tau persentase mahasiswa yang mendapat nilai A,B,C,D,E
misalnya (jumlah matakuliah x jumlah mahasiswa yang mendapat nilai A) / 100 = (hasil persantase untuk nilai measure A)
bisa ga ya? ntr saya nyimpen rumus nya dmn ya?
Pada tanggal 16/09/11, Feris Thia <fe...@phi-integration.com> menulis:
Pak Feris yang kemaren saya masih bingun mohon lampiran saya dibaca
terimakasih :)
IPK <=2 >= 3 IPK >= 3 jadi kalo mahasiswa yang ipk nya kurang dari 2 maka masuk ke measure IPK <= 2 dan seterusnya.. tapi pengen berbentuk persentase.Saya sudah buat seperti ini : With Member [Measures].[IPK kurang dari 2] as IIF (([Measures].[Jumlah Mahasiswa] < [Measures].[Bobot Nilai]),([Measures].[Bobot Nilai]/[Measures].[Jumlah Mahasiswa]),([Measures].[Jumlah Mahasiswa]/[Measures].[Bobot Nilai])), FORMAT_STRING = '0.00%' select {[Measures].[Jumlah Mahasiswa],[Measures].[IPK kurang dari 2],[Measures].[IPK 2 sampai 3],[Measures].[IPK lebih dari 3]} ON COLUMNS, { ([Matkul].[All Matkul],[mahasiswa].[All Mahasiswa],[dosen].[All dosen],[Nilai].[All Nilai])} ON ROWS FROM [KRS] |
Ada yang aneh nih di measurenya:
Kalau nilai IPK nya 2 atau 3 masuk yang mana?
Best Regards,
Andreas
Rekan-rekan semua, saya ingin membuat statistik sederhana mengenai
jumlah mahasiswa per tahun angkatan.
tabel saya:
==================+
| pk_fact | nim | tahun |
+=================+
kemudian saya membuat cube dengan schema workbench, sebagai berikut:
<Schema name="Statistik Mahasiswa UM">
<Dimension type="StandardDimension" foreignKey="tahun" name="Angkatan">
</Dimension>
<Cube name="Statistik" cache="true" enabled="true">
<Table name="factmahasiswa" schema="dtum">
</Table>
<DimensionUsage source="Angkatan" name="Angkatan">
</DimensionUsage>
<Measure name="Jumlah" column="nim" aggregator="distinct
count" visible="true">
</Measure>
</Cube>
</Schema>
pertanyaannya
1. Apakah desain cube saya sudah benar?
2. Bagaimana MDX query-nya untuk menampilkannya melalui mondrian. Saya
ingin menampilkan jumlah semua angkatan, kemudian bisa juga
masing-masing angkatan
Berikut saya sertakan screenshoot dari SWB.
Salam,
Umar Faisol
Pusat TIK Universitas Negeri Malang
IPK >=2 <= 3 IPK > 3 |
IPK < 2
(IPK >= 2) && (IPK <= 3)
IPK > 3
^_^
On 9/22/11, Fanni Zoraya <zoraya...@gmail.com> wrote:
> harusnya gimna donk?
> gini ya
> misalnya ada 3 measure IPK < 2
> IPK >=2 <= 3
> IPK > 3
> bener ga pak? :D
>
> Pada 22 September 2011 15:14, Tjong, Andreas
> <Andrea...@avrist.com>menulis:
>
>> ******
>>
>> ****Ada**** yang aneh nih di measurenya: ****
>>
>> Kalau nilai IPK nya 2 atau 3 masuk yang mana?****
>>
>> ** **
>>
>> Best Regards,****
>>
>> Andreas****
>>
>> ** **
>> ------------------------------
>>
>> *From:* penta...@googlegroups.com [mailto:penta...@googlegroups.com]
>> *On
>> Behalf Of *Fanni Zoraya
>> *Sent:* Thursday, September 22, 2011 2:50 PM
>> *To:* penta...@googlegroups.com
>> *Subject:* Re: [pentaho-id] Re: schema workbench****
>>
>> ** **
>>
>> Pak Feris fanni dah berhasil yang kasus kemaren :)
>> terimakasih
>>
>> Kalo kasusnya kayak gni.. berarti ada 3 calculated member nya? atau cuma
>> 1?
>> pemanggilan calculated membernya di MDX querynya?
>>
>> misalnya ada 3 measure IPK <= 2****
>>
>> IPK <=2 >= 3
>> IPK >= 3
>>
>> jadi kalo mahasiswa yang ipk nya kurang dari 2 maka masuk ke measure IPK
>> <= 2 dan seterusnya.. tapi pengen berbentuk persentase.Saya sudah buat
>> seperti ini :
>>
>>
>> *With Member [Measures].[IPK kurang dari 2] as IIF (([Measures].[Jumlah
>> Mahasiswa] < [Measures].[Bobot Nilai]),([Measures].[Bobot
>> Nilai]/[Measures].[Jumlah Mahasiswa]),([Measures].[Jumlah
>> Mahasiswa]/[Measures].[Bobot Nilai])),
>> FORMAT_STRING = '0.00%'
>>
>> select {[Measures].[Jumlah Mahasiswa],[Measures].[IPK kurang dari
>> 2],[Measures].[IPK 2 sampai 3],[Measures].[IPK lebih dari 3]} ON COLUMNS,
>> { ([Matkul].[All Matkul],[mahasiswa].[All Mahasiswa],[dosen].[All
>> dosen],[Nilai].[All Nilai])} ON ROWS
>> FROM [KRS]*
>>
>> ****
>>
>> tapi yang keisi berarti hanya measure *[IPK kurang dari 2] *nya aja...
>>
>> terimakasih****
>>
>> Pada 22 September 2011 13:16, Feris Thia <fe...@phi-integration.com>
>> menulis:****
>>
>> Bu Fanni,****
>>
>> ** **
>>
>> Wah.. maaf email ini baru saya baca. Untuk calculated member saya sertakan
>> screenshot ya.****
>>
>> ** **
>>
>> ** **
>>
>> 2011/9/20 Fanni Zoraya <zoraya...@gmail.com>****
>>
>> Pak Feris yang kemaren saya masih bingun mohon lampiran saya dibaca
>> terimakasih :)****
>>
>>
>>
>> ****
>>
>> ** **
>>
>> -- ****
>>
>> 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
>> http://sqlserver-tips.phi-integration.com****
>>
>> ** **
>>
>> ****
>>
>> ** **
>>
>> -- ****
>>
>> Anda menerima pesan ini karena Anda telah terdaftar di Google
>> Groups "Pentaho User Group - ****Indonesia****".
>> Untuk mengirim pesan ke grup ini, kirimkan email ke
>> penta...@googlegroups.com
>> Untuk berhenti mendapatkan email dari grup ini,silahkan kirim email ke
>> pentaho-id+...@googlegroups.com
>> Untuk opsi lainnya, silahkan kunjungi
>> http://groups.google.com/group/pentaho-id?hl=id.
>> Untuk artikel teknis Pentaho dari PHI-Integration.com, silahkan kunjungi
>> http://pentaho.phi-integration.com.
>> Milis terkait : http://groups.google.com/group/indo-bi
>> Link knowledge base lainnya : http://www.belajarsql.com.****
>>
>> ** **
>>
>> --
>> Anda menerima pesan ini karena Anda telah terdaftar di Google
>> Groups "Pentaho User Group - ****Indonesia****".
>> Untuk mengirim pesan ke grup ini, kirimkan email ke
>> penta...@googlegroups.com
>> Untuk berhenti mendapatkan email dari grup ini,silahkan kirim email ke
>> pentaho-id+...@googlegroups.com
>> Untuk opsi lainnya, silahkan kunjungi
>> http://groups.google.com/group/pentaho-id?hl=id.
>> Untuk artikel teknis Pentaho dari PHI-Integration.com, silahkan kunjungi
>> http://pentaho.phi-integration.com.
>> Milis terkait : http://groups.google.com/group/indo-bi
>> Link knowledge base lainnya : http://www.belajarsql.com.****
>>
>> ------------------------------
Kalau menurut saya sih biar fair begini:
IPK < 2 à Range antara 0.00 – 1.99
2 <= IPK < 3 à Range antara 2.00 – 2.99
3 <= IPK à Range antara 3.00 – 4.00
Tapi kalau mau yang seperti di bawah juga nggak salah kok.
Suka-suka designer nya.
pak feris , saya mengalami hal serupa dengan bu fanny, tapi lebih serius list table di db tidak muncul.. kira2 permasalahn dimana ya..
--
--
Anda menerima pesan ini karena Anda telah terdaftar di Google
Groups "Pentaho User Group - Indonesia".
Untuk mengirim pesan ke grup ini, kirimkan email ke penta...@googlegroups.com
Untuk berhenti mendapatkan email dari grup ini,silahkan kirim email ke
pentaho-id+...@googlegroups.com
Untuk opsi lainnya, silahkan kunjungi http://groups.google.com/group/pentaho-id?hl=id.
Untuk artikel teknis Pentaho dari PHI-Integration.com, silahkan kunjungi http://pentaho.phi-integration.com.
Milis terkait : http://groups.google.com/group/indo-bi
Link knowledge base lainnya : http://www.belajarsql.com.
---
Anda menerima pesan ini karena berlangganan grup "Pentaho User Group Indonesia" di Google Grup.
Untuk berhenti berlangganan dan berhenti menerima email dari grup ini, kirim email ke pentaho-id+...@googlegroups.com.
Untuk opsi lebih lanjut, kunjungi https://groups.google.com/d/optout.