[Mondrian] Pentaho schema workbench [Résolu]

atifadil · 31/10/2011, 16h12

bonjour,
j'utilise la suite de pentaho BI 4.2 version payante.
j'ai créer un schéma avec l'utilitaire schéma workbench et j'arrive a publier ce schéma. le problème est que la publication me génère juste le fichier XML et pas de fichier XMI ce qui fait que je trouve pas la source de donnée dans la console user de BI server. en plus lorsque je veux tester mon schema avec MDX query

Citation:

Exception: Mondrian Error:Internal error: assert failed: parentExp != null || nullParentValue == null

See workbench log for full stacktrace.

vous trouverais ci joint une prise de mon schéma

sdecloix · 02/11/2011, 13h30

Bonjour

C'est normal, la publication avec le Pentaho Schema Workbench (PSW) ne génère pas de fichier XMI (ce fichier n'est créé que lorsque que tu crées une nouvelle query avec le modéliseur côté Pentaho User Console en web)

Quand tu publies depuis PSW, tu dois indiquer quelle datasource tu attaques.
Pour cela il te faut renseigner le nom JNDI de ta source de données: celui-ci doit déjà exister au niveau de ton serveur, tu peux le retrouver (le créer) depuis la console d'administration (Pentaho Administration/Enterprise Console), dans l'onglet "Datasource"

Pour l'erreur Java, il faudrait que tu mettes en pièce jointe le fichier de log "workbench.log" situé dans le répertoire caché ".schemaWorkbench" directement situé dans le Home utilisateur (${user.home}/.schemaWorkbench/workbench.log)

atifadil · 03/11/2011, 16h24

bonjour,

je te remercie pour ta réponse. la data source est créée dans ma console d'administration et je renseigne son nom lors de la publication et tout ce passe bien. Pour l'Erreur Java je te met le log ci dessous.
J'ai peur de ne pas comprendre comment je pourrais utiliser mon OLAP à partir de la console user sur le web?

tu trouvera des capture d’écran pour le publish et l'admin console

Citation:

2011-11-03 11:02:33,849 DEBUG [httpclient.wire.content] << "[\r]"
2011-11-03 11:02:33,849 DEBUG [httpclient.wire.content] << "[\n]"
2011-11-03 11:02:33,849 DEBUG [httpclient.wire.content] << "0"
2011-11-03 11:02:33,849 DEBUG [httpclient.wire.content] << "[\r]"
2011-11-03 11:02:33,849 DEBUG [httpclient.wire.content] << "[\n]"
2011-11-03 11:02:33,849 DEBUG [httpclient.wire.content] << "[\r]"
2011-11-03 11:02:33,849 DEBUG [httpclient.wire.content] << "[\n]"
2011-11-03 11:02:47,912 DEBUG [httpclient.wire.header] >> "POST /pentaho/MondrianCatalogPublisher?publishPath=%2Fadmin%2Fresources%2Fmetadata&publishKey=0c6cbfb4513068c3dcc4f6530cca391f&overwrite=true&jndiName=ODEMA_POTEAU&enableXmla=true HTTP/1.1[\r][\n]"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.header] >> "Authorization: Basic am9lOnBhc3N3b3Jk[\r][\n]"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.header] >> "User-Agent: Jakarta Commons-HttpClient/3.0.1[\r][\n]"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.header] >> "Host: localhost:8080[\r][\n]"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.header] >> "Content-Length: 7941[\r][\n]"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.header] >> "Content-Type: multipart/form-data; boundary=o0Xht96Xr3tyi7p0noZ0k_3KhPWkr2i-aMNryH5[\r][\n]"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.header] >> "[\r][\n]"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> "--"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> "o0Xht96Xr3tyi7p0noZ0k_3KhPWkr2i-aMNryH5"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> "[\r][\n]"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> "Content-Disposition: form-data; name="
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> """
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> "INS_POTEAU.mondrian.xml"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> """
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> "; filename="
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> """
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> "INS_POTEAU.mondrian.xml"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> """
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> "[\r][\n]"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> "Content-Type: "
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> "application/octet-stream"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> "; charset="
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> "ISO-8859-1"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> "[\r][\n]"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> "Content-Transfer-Encoding: "
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> "binary"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> "[\r][\n]"
2011-11-03 11:02:47,927 DEBUG [httpclient.wire.content] >> "[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> "<Schema name="INS_POTEAU">[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " <Cube name="INS_POTEAU" cache="true" enabled="true">[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " <Table name="T_FAIT_INSPECTION" schema="ODEMA_POTEAU">[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " </Table>[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " <Dimension type="StandardDimension" foreignKey="ID_STATUT_DEMANDE" highCardinality="false" name="STATUT_DEMANDE">[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " <Hierarchy name="SATTUT_DEMANDE" hasAll="true">[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " <Table name="DIM_STATUT_DEMANDE" schema="ODEMA_POTEAU">[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " </Table>[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " <Level name="STATUT_DEMANDE" column="DESC_STATUT_DEMANDE" nullParentValue="Non Disponible" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " </Hierarchy>[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " </Dimension>[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " <Dimension type="StandardDimension" foreignKey="ID_PROJET" highCardinality="false" name="PROJET">[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " <Hierarchy name="PROJET" hasAll="true">[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " <Table name="T_DIM_PROJET" schema="ODEMA_POTEAU">[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " </Table>[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " <Level name="Nom PROJET" column="NOM_PROJET" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " <Level name="Territoire" column="ID_TERRIT" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " <Level name="Annee creation" column="ANNE_PROJET" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " </Hierarchy>[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " </Dimension>[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " <Dimension type="StandardDimension" foreignKey="INSPECTION_ID" highCardinality="false" name="POTEAU">[\r][\n]"
2011-11-03 11:02:47,943 DEBUG [httpclient.wire.content] >> " <Hierarchy name="POTEAU" hasAll="true">[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " <Table name="T_DIM_POTEAU" schema="ODEMA_POTEAU">[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " </Table>[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " <Level name="USAGE" column="USAGE" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " <Level name="ESSENCE" column="ESSENCE" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " <Level name="CLASSE" column="CLASSE" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " <Level name="MATERIAUX" column="MATERIAUX" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " <Level name="PROPRIETAIRE" column="PROPRIETAIRE" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " </Hierarchy>[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " </Dimension>[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " <Dimension type="StandardDimension" foreignKey="ID_STATUT_POTEAUX" highCardinality="false" name="STATUT POTEAU">[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " <Hierarchy name="STATUT POTEAU" hasAll="true">[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " <Table name="DIM_STATUT_POTEAUX" schema="ODEMA_POTEAU">[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " </Table>[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " <Level name="STATUT POTEAU" column="DESC_STATUT_POTEAUX" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " </Hierarchy>[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " </Dimension>[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " <Dimension type="StandardDimension" foreignKey="ID_ANOMALIE" highCardinality="false" name="ANOMALIE">[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " <Hierarchy name="ANOMALIE" hasAll="true">[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " <Table name="DIM_ANOMALIE" schema="ODEMA_POTEAU">[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " </Table>[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " <Level name="DESC ANOMALIE" column="DESC_ANOMALIE" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " <Level name="CAT ANOMALIE" column="CAT_ANOMALIE" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " </Hierarchy>[\r][\n]"
2011-11-03 11:02:47,959 DEBUG [httpclient.wire.content] >> " </Dimension>[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " <Dimension type="StandardDimension" foreignKey="ID_EQUIPE" highCardinality="false" name="EQUIPE">[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " <Hierarchy name="EQUIPE" hasAll="true">[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " <Table name="DIM_EQUIPE" schema="ODEMA_POTEAU">[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " </Table>[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " <Level name="PRENOM PERSONNE" column="PRENOM_PERSONNE" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " <Level name="NOM PERSONNE" column="NOM_PERSONNE" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " </Hierarchy>[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " </Dimension>[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " <Dimension type="StandardDimension" foreignKey="ID_FIRME" highCardinality="false" name="FIRM">[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " <Hierarchy na"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> "me="FIRM" hasAll="true">[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " <Table name="DIM_FIRME" schema="ODEMA_POTEAU">[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " </Table>[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " <Level name="DESC FIRM" column="DESC_SOCIETE" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " </Hierarchy>[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " </Dimension>[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " <Dimension type="StandardDimension" foreignKey="ID_TYPE_PROJET" highCardinality="false" name="TYPE PROJET">[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " <Hierarchy name="TYPE PROJET" hasAll="true">[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " <Table name="DIM_TYPE_PROJET" schema="ODEMA_POTEAU">[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " </Table>[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " <Level name="DESC TYPE PROJET" column="DESC_TYPE_PROJET" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " </Hierarchy>[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " </Dimension>[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " <Dimension type="StandardDimension" foreignKey="ID_ETAT_TETE" highCardinality="false" name="ETAT DE LA TETE">[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " <Hierarchy name="ETAT TETE" hasAll="true">[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " <Table name="DIM_ETAT_TETE" schema="ODEMA_POTEAU">[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " </Table>[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " <Level name="DESC ETAT TETE" column="DESC_ETAT_TETE" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,974 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " </Hierarchy>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " </Dimension>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " <Dimension type="StandardDimension" foreignKey="ID_AGENT_TRAITEMENT_BOIS" highCardinality="false" name="AGENT TRAITEMENT BOIS">[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " <Hierarchy name="AGENT TRAITEMENT BOIS" hasAll="true">[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " <Table name="DIM_AGENT_TRAITEMENT" schema="ODEMA_POTEAU">[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " </Table>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " <Level name="DESC AGENT TRAITEMENT BOIS" column="DESC_AGENT_TRAITEMENT" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " </Hierarchy>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " </Dimension>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " <Dimension type="StandardDimension" foreignKey="ID_AGENT_TRAITEMENT_TROU" highCardinality="false" name="AGENT TRAITEMENT TROU">[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " <Hierarchy name="AGENT TRAITEMENT TROU" hasAll="true">[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " <Table name="DIM_AGENT_TRAITEMENT_TROU" schema="ODEMA_POTEAU">[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " </Table>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " <Level name="DESC AGENT TRAITEMENT TROU" column="DESC_AGENT_TRAITEMENT" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " </Hierarchy>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " </Dimension>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " <Dimension type="StandardDimension" foreignKey="ID_MOR" highCardinality="false" name="MOR">[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " <Hierarchy name="MOR" hasAll="true">[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " <Table name="DIM_MOR" schema="ODEMA_POTEAU">[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " </Table>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " <Level name="DESC MOR" column="DESC_MOR" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " </Level>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " </Hierarchy>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " </Dimension>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " <Measure name="INSPECTION_ID" column="INSPECTION_ID" datatype="String" aggregator="distinct-count" visible="true">[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " </Measure>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " <Measure name="CODE A BARRE" column="CODE_A_BARRE" datatype="String" aggregator="distinct-count" visible="true">[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " </Measure>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " <Measure name="NBR TROU TRAITE" column="RET_NB_TIGES_INSTALLES_TROU" datatype="Numeric" aggregator="sum" visible="true">[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " </Measure>[\r][\n]"
2011-11-03 11:02:47,990 DEBUG [httpclient.wire.content] >> " <Measure name="NBR TIGE TRAITEMENT BOIS" column="RET_NB_TIGES_INSTALLES_BOIS" datatype="Numeric" aggregator="distinct-count" visible="true">[\r][\n]"
2011-11-03 11:02:48,006 DEBUG [httpclient.wire.content] >> " </Measure>[\r][\n]"
2011-11-03 11:02:48,006 DEBUG [httpclient.wire.content] >> " <Measure name="ANNEE_FABRICATION" column="ANNEE_FABRICATION" datatype="Integer" aggregator="avg" visible="true">[\r][\n]"
2011-11-03 11:02:48,006 DEBUG [httpclient.wire.content] >> " </Measure>[\r][\n]"
2011-11-03 11:02:48,006 DEBUG [httpclient.wire.content] >> " <Measure name="ANNEE_INSPECTION" column="ANNEE_INSP" datatype="Integer" aggregator="avg" visible="true">[\r][\n]"
2011-11-03 11:02:48,006 DEBUG [httpclient.wire.content] >> " </Measure>[\r][\n]"
2011-11-03 11:02:48,006 DEBUG [httpclient.wire.content] >> " <CalculatedMember name="AGE" formula="ANNEE_INSP - ANNEE_FABRICATION" dimension="Measures" visible="true">[\r][\n]"
2011-11-03 11:02:48,006 DEBUG [httpclient.wire.content] >> " </CalculatedMember>[\r][\n]"
2011-11-03 11:02:48,006 DEBUG [httpclient.wire.content] >> " </Cube>[\r][\n]"
2011-11-03 11:02:48,006 DEBUG [httpclient.wire.content] >> "</Schema>[\r][\n]"
2011-11-03 11:02:48,006 DEBUG [httpclient.wire.content] >> "[\r][\n]"
2011-11-03 11:02:48,006 DEBUG [httpclient.wire.content] >> "--"
2011-11-03 11:02:48,006 DEBUG [httpclient.wire.content] >> "o0Xht96Xr3tyi7p0noZ0k_3KhPWkr2i-aMNryH5"
2011-11-03 11:02:48,006 DEBUG [httpclient.wire.content] >> "--"
2011-11-03 11:02:48,006 DEBUG [httpclient.wire.content] >> "[\r][\n]"
2011-11-03 11:02:48,302 DEBUG [httpclient.wire.header] << "HTTP/1.1 200 OK[\r][\n]"
2011-11-03 11:02:48,302 DEBUG [httpclient.wire.header] << "Server: Apache-Coyote/1.1[\r][\n]"
2011-11-03 11:02:48,302 DEBUG [httpclient.wire.header] << "Set-Cookie: JSESSIONID=085A61351CA678C2636E60DC6ADD54BC; Path=/pentaho[\r][\n]"
2011-11-03 11:02:48,302 DEBUG [httpclient.wire.header] << "Content-Length: 3[\r][\n]"
2011-11-03 11:02:48,302 DEBUG [httpclient.wire.header] << "Date: Thu, 03 Nov 2011 15:02:48 GMT[\r][\n]"
2011-11-03 11:02:48,302 DEBUG [httpclient.wire.content] << "3[\r][\n]"
2011-11-03 11:02:53,381 ERROR [mondrian.gui.QueryPanel] Exception: Mondrian Error:Internal error: assert failed: parentExp != null || nullParentValue == null
mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed: parentExp != null || nullParentValue == null
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:838)
at mondrian.olap.Util.newInternal(Util.java:1532)
at mondrian.olap.Util.assertTrue(Util.java:1524)
at mondrian.olap.Util.assertPrecondition(Util.java:1594)
at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:162)
at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:314)
at mondrian.rolap.RolapHierarchy.<init>(RolapHierarchy.java:264)
at mondrian.rolap.RolapDimension.<init>(RolapDimension.java:122)
at mondrian.rolap.RolapCube.getOrCreateDimension(RolapCube.java:749)
at mondrian.rolap.RolapCube.<init>(RolapCube.java:188)
at mondrian.rolap.RolapCube.<init>(RolapCube.java:219)
at mondrian.rolap.RolapSchema.load(RolapSchema.java:442)
at mondrian.rolap.RolapSchema.load(RolapSchema.java:318)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:229)
at mondrian.rolap.RolapSchema.<init>(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.<init>(RolapConnection.java:166)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:110)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:74)
at mondrian.gui.QueryPanel.connectButtonActionPerformed(QueryPanel.java:320)
at mondrian.gui.QueryPanel.initConnection(QueryPanel.java:99)
at mondrian.gui.Workbench.newQueryMenuItemActionPerformed(Workbench.java:1441)
at mondrian.gui.Workbench.access$200(Workbench.java:94)
at mondrian.gui.Workbench$3.actionPerformed(Workbench.java:439)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

sdecloix · 03/11/2011, 16h36

Julian Hyde (créateur de Mondrian) donne l'explication de ton pb à qq'un qui a eu le même souci que toi

C'est sur forums.pentaho.com ici:
http://forums.pentaho.com/showthread...606#post237606

atifadil · 21/11/2011, 16h15

bonjour,

j'ai réussi à résoudre le problème qui été enfaite lié à mon schéma car je déclarer des dimension local est non des dimension global ce qui me pénaliser lors d'ajout de dimension d'usage et scraper mon schéma.

02/11/2011, 13h30	#2
sdecloix Membre éprouvé Consultant en Business Intelligence Inscription : mai 2008 Messages : 191 Détails du profil Informations personnelles : Localisation : France Informations professionnelles : Activité : Consultant en Business Intelligence Informations forums : Inscription : mai 2008 Messages : 191 Points : 479 Points : 479	Bonjour C'est normal, la publication avec le Pentaho Schema Workbench (PSW) ne génère pas de fichier XMI (ce fichier n'est créé que lorsque que tu crées une nouvelle query avec le modéliseur côté Pentaho User Console en web) Quand tu publies depuis PSW, tu dois indiquer quelle datasource tu attaques. Pour cela il te faut renseigner le nom JNDI de ta source de données: celui-ci doit déjà exister au niveau de ton serveur, tu peux le retrouver (le créer) depuis la console d'administration (Pentaho Administration/Enterprise Console), dans l'onglet "Datasource" Pour l'erreur Java, il faudrait que tu mettes en pièce jointe le fichier de log "workbench.log" situé dans le répertoire caché ".schemaWorkbench" directement situé dans le Home utilisateur (${user.home}/.schemaWorkbench/workbench.log) __________________ Sylvain (www.osbi.fr)
	10

03/11/2011, 16h36	#4
sdecloix Membre éprouvé Consultant en Business Intelligence Inscription : mai 2008 Messages : 191 Détails du profil Informations personnelles : Localisation : France Informations professionnelles : Activité : Consultant en Business Intelligence Informations forums : Inscription : mai 2008 Messages : 191 Points : 479 Points : 479	Julian Hyde (créateur de Mondrian) donne l'explication de ton pb à qq'un qui a eu le même souci que toi C'est sur forums.pentaho.com ici: http://forums.pentaho.com/showthread...606#post237606 __________________ Sylvain (www.osbi.fr)
	00

21/11/2011, 16h15	#5
atifadil Candidat au titre de Membre du Club Adil ATIF Étudiant Inscription : octobre 2011 Messages : 17 Détails du profil Informations personnelles : Nom : Adil ATIF Localisation : Canada Informations professionnelles : Activité : Étudiant Informations forums : Inscription : octobre 2011 Messages : 17 Points : 11 Points : 11	bonjour, j'ai réussi à résoudre le problème qui été enfaite lié à mon schéma car je déclarer des dimension local est non des dimension global ce qui me pénaliser lors d'ajout de dimension d'usage et scraper mon schéma.
	00

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email