Hitachi Vantara Pentaho Community Forums
Results 1 to 14 of 14

Thread: Pentaho User Group Italia proposal

  1. #1
    Join Date
    Jan 2006
    Posts
    245

    Default Pentaho User Group Italia proposal

    Ciao a tutti,

    mi sono fatto promotore di un'iniziativa per la formazione di un Pentaho User Group italiano. La proposta è stata fatta sull'omomnimo gruppo di linkedin (ecco il link http://tinyurl.com/39xl4uj). Vi aspetto numerosi con idee, commmenti, suggerimenti. Doug si è già reso disponibile ad aiutarci a fare partire il gruppo e questo è molto positivo.

    Per chi non fosse presente sul social LinkedIn ecco il testo integrale del mio post:

    Following the initiative of our colleagues from England I would like to copy this nice idea and propose the creation of a Pentaho Usergroup also in Italy. The italian section of Pentaho forum is a bit sleeping but I think there are a lot of people interested in sharing opinions, ideas, experiences or other things related to our preferred Open Source BI tool. The proposal could to to organize a website for our group and organize some meetings on a regular base using web collaboration tools or by person for a beer and stay together. Because this is for italian people I post the same also in italian and I suggest to answer in italian

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

    Facendo seguito all'idea dei nostri amici e colleghi inglesi mi permetto di proporre, allo stesso modo, la formazione di uno Usergroup italiano su Pentaho. L'iniziativa mi sembra interessante e ritengo che nonostante la poca attività nel forum di Pentaho in lingua italiana ci sia un discreto numero di persone che sono interessate a conoscersi, scambiarsi idee, esperienze ed opinioni riguardanti il nostro tool di BI preferito. Potremmo approntare un sito web apposito per il nostro usergroup ed organizzare una serie di incontri con cadenza regolare sfruttando tool di collaborazione o incontrandoci di persona (spero sia maggiormentem percorribile questa opzione) per una birra o semplicemente stare insieme. Non so quanti di voi saranno a Lisbona ma un primo meeting potrebbe essere per illustrare agli assenti un resoconto della due giorni di incontro della community.

    Ciao a tutti.
    Follow Me on Twitter: sramazzina
    My Skype account: sramazzina
    My Blog
    View my profile on LinkedIn: http://www.linkedin.com/in/sramazzina
    Author of Pentaho Data Integration Kitchen How-To and Pentaho Business Analytics Cookbook

    Join us on IRC server Freenode.net, channel ##pentaho ##saiku

  2. #2
    Join Date
    Feb 2011
    Posts
    240

    Default

    ciao, sono nuova di questo forum, quindi non so se questo è il posto giusto per la mia domanda.

    Ho da pochissimo iniziato ad utilizzare pentaho, e ho deciso di iniziare con il modulo report designer (non so se facendo bene o meno).
    Il mio problema è che non riesco a creare le query utilizzando un database oracle (con mysql nessun problema).
    Qualcuno mi può aiutare? ve ne sarei veramente grata
    Ciao Mariarita

  3. #3
    Join Date
    Jan 2006
    Posts
    245

    Default

    I drivers li hai messi? E soprattutto li hai messi al posto giusto?
    In caso i due punti sopra fossero smarcati con successo puoi postare un log con l'errore?
    Ciao

    S.
    Follow Me on Twitter: sramazzina
    My Skype account: sramazzina
    My Blog
    View my profile on LinkedIn: http://www.linkedin.com/in/sramazzina
    Author of Pentaho Data Integration Kitchen How-To and Pentaho Business Analytics Cookbook

    Join us on IRC server Freenode.net, channel ##pentaho ##saiku

  4. #4

    Default

    ciao,
    quindi, hijack del thread a parte, cosa si è deciso? ;-)
    carloz

  5. #5
    Join Date
    Mar 2011
    Posts
    15

    Default

    Ciao a tutti! Anche io lavoro con Pentaho per uno stage/tesi in azienda. Non è da molto tempo che me ne occupo ma sono riuscito con successo a configurare la piattaforma per funzionare su oracle e autenticarsi con Ldap.

  6. #6
    Join Date
    Apr 2011
    Posts
    1

    Default

    Salve, sono nuovo del forum, da poco con la mia societa, abbiamo iniziato uno studio su pentaho, l'idea dell'user group la trovo interessante, se ci sono sviluppi, mi piacerebbe partecipare

  7. #7

    Default

    sergio, sergio, sergio!
    facci sapere qualcosa :-))

    ciao
    carloz

  8. #8
    Join Date
    Feb 2011
    Posts
    240

    Default

    Grazie mille

  9. #9
    Join Date
    Feb 2011
    Posts
    240

    Default

    Ciao, avrei bisogno del vostro aiuto.

    Sto usando il tool schema workbench per crearmi un cubo da utilizzare per realizzare un'analisi, e fin qui tutto ok.
    Quando mi collego alla console pentaho clicco su new->Analysis view, seleziono il mio schema e creo la mia "analisi", impostando colonne, righe e filtri.
    Il problema si verifica quando salvo l'analisi. Ho notato che praticamente per vedere il risultato devo andare a reimpostare il filtro. Come posso fare per risolvere questo problema?
    Grazie mille

    Ciao mariarita

  10. #10
    Join Date
    Feb 2011
    Posts
    240

    Default

    Ciao,

    questa è la situazione in cui mi trovo:
    sto utilizzando il tool schema workbench per creare un cubo e pubblicarlo come schema su Pentaho CE.
    Nello schema workbench non ci sono errori, ma quando apro una nuova analisi nella console pentaho, selezionando lo schema, mi appare questo errore:

    'An error occurred while rendering Pivot.jsp. Please see the log for details.'

    Il log è:

    Mondrian Error: no function matches signature ' <<Member>, <Level>>'.......

  11. #11
    Join Date
    Jan 2006
    Posts
    245

    Default

    Mariarita,

    apriamo argomenti nuovi in thread nuovi. Per quanto riguarda invece il tuo problema il pezzo di log che attacchi nn dice nulla di interessante. Attacca il log completo e ci buttiamo un occhio

    S.
    Follow Me on Twitter: sramazzina
    My Skype account: sramazzina
    My Blog
    View my profile on LinkedIn: http://www.linkedin.com/in/sramazzina
    Author of Pentaho Data Integration Kitchen How-To and Pentaho Business Analytics Cookbook

    Join us on IRC server Freenode.net, channel ##pentaho ##saiku

  12. #12
    Join Date
    Feb 2011
    Posts
    240

    Default

    ok, scusami ho automaticamente cliccato su reply.

    Il log è questo:

    12:00:23,968 ERROR [OlapModelTag]
    com.tonbeller.jpivot.olap.model.OlapException: Mondrian Error:No function matche
    s signature '(<Member>, <Level>, <Member>)'
    at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.
    java:550)
    at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapMod
    elDecorator.java:132)
    at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModel
    Proxy.java:77)
    at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackSt
    ateManager.java:76)
    at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelP
    roxy.java:160)
    at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81)

    at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:889)
    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:377)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
    13)
    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(Appl
    icationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:206)
    at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilte
    r(PentahoWebContextFilter.java:77)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:206)
    at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doF
    ilter(PentahoRequestContextFilter.java:84)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:206)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:378)
    at org.springframework.security.intercept.web.FilterSecurityInterceptor.
    invoke(FilterSecurityInterceptor.java:109)
    at org.springframework.security.intercept.web.FilterSecurityInterceptor.
    doFilter(FilterSecurityInterceptor.java:83)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHt
    tp(ExceptionTranslationFilter.java:101)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
    ecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter
    (SecurityStartupFilter.java:103)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.springframework.security.providers.anonymous.AnonymousProcessingF
    ilter.doFilterHttp(AnonymousProcessingFilter.java:105)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
    ecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.RequestParameterAuthentication
    Filter.doFilter(RequestParameterAuthenticationFilter.java:169)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFil
    terHttp(BasicProcessingFilter.java:174)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
    ecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp
    (AbstractProcessingFilter.java:278)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
    ecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(Logo
    utFilter.java:89)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
    ecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilte
    r.doFilter(HttpSessionReuseDetectionFilter.java:134)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.springframework.security.context.HttpSessionContextIntegrationFil
    ter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
    ecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.springframework.security.wrapper.SecurityContextHolderAwareReques
    tFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
    ecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.springframework.security.util.FilterChainProxy.doFilter(FilterCha
    inProxy.java:175)
    at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterTo
    BeanProxy.java:99)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:206)
    at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(Sys
    temStatusFilter.java:60)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:206)
    at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFi
    lter(SetCharacterEncodingFilter.java:113)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
    alve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
    alve.java:191)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
    torBase.java:470)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
    ava:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
    ava:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
    ve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
    a:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
    :857)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
    ss(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:48
    9)
    at java.lang.Thread.run(Thread.java:619)
    javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: M
    ondrian Error:No function matches signature '(<Member>, <Level>, <Member>)'
    at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:86)

    at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:889)
    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:377)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
    13)
    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(Appl
    icationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:206)
    at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilte
    r(PentahoWebContextFilter.java:77)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:206)
    at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doF
    ilter(PentahoRequestContextFilter.java:84)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:206)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:378)
    at org.springframework.security.intercept.web.FilterSecurityInterceptor.
    invoke(FilterSecurityInterceptor.java:109)
    at org.springframework.security.intercept.web.FilterSecurityInterceptor.
    doFilter(FilterSecurityInterceptor.java:83)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHt
    tp(ExceptionTranslationFilter.java:101)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
    ecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter
    (SecurityStartupFilter.java:103)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.springframework.security.providers.anonymous.AnonymousProcessingF
    ilter.doFilterHttp(AnonymousProcessingFilter.java:105)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
    ecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.RequestParameterAuthentication
    Filter.doFilter(RequestParameterAuthenticationFilter.java:169)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFil
    terHttp(BasicProcessingFilter.java:174)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
    ecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp
    (AbstractProcessingFilter.java:278)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
    ecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(Logo
    utFilter.java:89)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
    ecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilte
    r.doFilter(HttpSessionReuseDetectionFilter.java:134)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.springframework.security.context.HttpSessionContextIntegrationFil
    ter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
    ecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.springframework.security.wrapper.SecurityContextHolderAwareReques
    tFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
    ecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
    .doFilter(FilterChainProxy.java:390)
    at org.springframework.security.util.FilterChainProxy.doFilter(FilterCha
    inProxy.java:175)
    at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterTo
    BeanProxy.java:99)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:206)
    at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(Sys
    temStatusFilter.java:60)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:206)
    at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFi
    lter(SetCharacterEncodingFilter.java:113)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
    alve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
    alve.java:191)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
    torBase.java:470)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
    ava:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
    ava:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
    ve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
    a:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
    :857)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
    ss(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:48
    9)
    at java.lang.Thread.run(Thread.java:619)
    Caused by: com.tonbeller.jpivot.olap.model.OlapException: Mondrian Error:No func
    tion matches signature '(<Member>, <Level>, <Member>)'
    at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.
    java:550)
    at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapMod
    elDecorator.java:132)
    at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModel
    Proxy.java:77)
    at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackSt
    ateManager.java:76)
    at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelP
    roxy.java:160)
    at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81)

    Grazie mille è molto importante per me.

    Ciao Mariarita

  13. #13
    Join Date
    Jan 2006
    Posts
    245

    Default

    Da quello che vedo potrebbe esserci un problema con la query MDX. Puoi postare il cubo e la query che fai?

    S.
    Follow Me on Twitter: sramazzina
    My Skype account: sramazzina
    My Blog
    View my profile on LinkedIn: http://www.linkedin.com/in/sramazzina
    Author of Pentaho Data Integration Kitchen How-To and Pentaho Business Analytics Cookbook

    Join us on IRC server Freenode.net, channel ##pentaho ##saiku

  14. #14
    Join Date
    Feb 2011
    Posts
    240

    Default

    Lo schema è il seguente:


    <Schema name="SchemaInterv">
    <Cube name="CuboInterv" cache="true" enabled="true">
    <Table name="INTERV" schema="SINSNT_TEST" alias="">
    </Table>
    <Dimension type="StandardDimension" foreignKey="INT_CARTELLA" name="Assistito">
    <Hierarchy hasAll="true" allMemberName="Assistiti" primaryKey="N_CARTELLA">
    <Table name="CARTELLA" schema="SINSNT_TEST" alias="">
    </Table>
    <Level name="Cognome" column="COGNOME" type="String" uniqueMembers="false" levelType="Regular">
    </Level>
    <Level name="Nome" column="NOME" type="String" uniqueMembers="false" levelType="Regular">
    </Level>
    <Level name="Codice fiscale" column="COD_FISC" type="String" uniqueMembers="false" levelType="Regular">
    </Level>
    </Hierarchy>
    </Dimension>
    <Dimension type="StandardDimension" foreignKey="INT_ANNO" name="Anno">
    <Hierarchy hasAll="true" allMemberName="Anni" primaryKey="INT_ANNO">
    <Table name="INTERV" schema="SINSNT_TEST" alias="">
    </Table>
    <Level name="Anno" column="INT_ANNO" type="String" uniqueMembers="false" levelType="Regular">
    </Level>
    </Hierarchy>
    </Dimension>
    <Dimension type="StandardDimension" foreignKey="INT_AMBDOM" name="Tipo intervento">
    <Hierarchy hasAll="true" allMemberName="Tipo intervento" primaryKey="INT_AMBDOM">
    <Table name="INTERV" schema="SINSNT_TEST" alias="">
    </Table>
    <Level name="Tipo intervento" column="INT_AMBDOM" type="String" uniqueMembers="false" levelType="Regular">
    </Level>
    </Hierarchy>
    </Dimension>
    <Dimension type="StandardDimension" foreignKey="INT_QUAL_OPER" name="Profilo professionale">
    <Hierarchy hasAll="true" allMemberName="Profili Professionali" primaryKey="COD_QUALIF">
    <Table name="OPERQUAL" schema="SINSNT_TEST" alias="">
    </Table>
    <Level name="Profilo Professionale" column="DESC_QUALIF" type="String" uniqueMembers="false" levelType="Regular">
    </Level>
    </Hierarchy>
    </Dimension>
    <Measure name="n&#176;Assistiti" column="INT_CARTELLA" aggregator="distinct-count" visible="true">
    </Measure>
    </Cube>
    </Schema>

    Una volta che salvo lo schema clicco su New -> MdxQuery. La connessione è ok, ma quando clicco su execute:

    Mondrian Error:Failed to parse query ''

    Mondrian Error:Error while parsing MDX statement ''

    Mondrian Error:Syntax error at line 1, column 1, token 'EOF'

    Grazie mille per l'aiuto
    Ciao
    Mariarita

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.