Nicolep

Again.. I didn't see that my xml cube schema called an undeclared Store cost measure.. And it seems that Mondrian doesn't notify if the error is in the schema or in the MDX query.. regards, Nicolep

Hi, I've met a pretty weird error in Jasperserver.. I created a new olap datasource, a new olap cube schema, a new olap mondrian connection and I tried to create a new olap analysis view.. My problem deals with the mdx query : I wrote that query : SELECT {[Measures].[unit Sales], [Measures].[store sales]} ON COLUMNS, {[Time].[1997].[Q1].descendants} ON ROWS FROM [sales] WHERE [Gender].[F] the error is : The following is not a valid MDX Query: Mondrian Error:MDX object '[Measures].[store Cost]' not found in cube 'Sales' So it says to me that the store COST measure doesn't exist..I know that! I never ask for the store COST measure but for the Store SALES measure! Why does it think i'm searching the store COST measure?? thanks Nicolep

Thanks. I already tried with my time dimension on rows but it's the same. Don't you see any error in my schema? Nicolep

Thanks. I already tried with my time dimension on rows but it's the same. Don't you see any error in my schema? Nicolep

Hi, I'm trying to run my own cube with jasperServer. It is really simple, here is my schema : <?xml version="1.0" encoding="UTF-8"?> <Schema name="rentabilite"> <Cube name="rentabilite"> <Table name="tbrentabilite_test"/> <Dimension name="Temps" foreignKey="idTemps"> <Hierarchy name="Temps" hasAll="false" primaryKey="id_temps"> <Table name="temps_test"/> <Level name="Annee" TABLE="temps_test" COLUMN="annee" uniqueMembers="true"/> <Level name="Trimestre" TABLE="temps_test" COLUMN="trimestre" uniqueMembers="false"/> <Level name="Mois" TABLE="temps_test" COLUMN="mois" uniqueMembers="false"/> </Hierarchy> </Dimension> <measure name="Taux_rentabilite" column="tauxRentabilite" aggregator="sum" datatype="String" formatString="Standard"/> </Cube> </Schema> So, just one measure and one dimension. I put this query in my analysis view, very simple too : SELECT {[Measures].[Taux_rentabilite]} ON COLUMNS FROM [rentabilite] It doesn't work, I 've got the error : not valid MDX query : null have you got an idea? Thanks Nicolep

Hi, I forward you the response from the Talend forum. "Hi, Yes, of course, there are different ways to schedule your Talend jobs. The first and easier way, if you are under Windows platform, is to extract your Job(click-right on your job in the repository), it makes an archive files in which there are all files to execute the job. Test your job with "file".bat, if it's works, create a planified task (Run -> Parameter -> Control panel -> Planified tasks), in this tool you can specify the day, the frequency of this execution. If you work under linux or if you have a CRON tool program, you can choose the integrated Scheduler of Talend Open Studio (view near "Run Job" view) to schedule your execution and generate a CRON line command, then you put this in your CRON Table, and it's works. Good luck. Regards" Thanks to Cantoine from Talend team. Bye Nicolep

Nobody knows something about that? It's very important please. Thanks Nicolep

Hi, String type is for sure not a acceptable solution.. When you say that you delete the length, you put the value to 0 or is there a way to delete the field? Thanks Nicolep

Hi, I come back on my previous message where I said that I found the solution. The problem wasn't the duplicata of primary key value but it seems that the problem comes from "day" type. The creation of the table raises a problem when I've got a day type in my schema. When I replace the day type by string type, the problem doesn't appears. It may exist a problem of compatibility between jasperETL "day" type and in my case, Mysql "date" or "datetime" type.And your message, Alex, seems to confirm this hypothesis. Have someone a solution other that changing the type to string?? Thank Nicolep

Thanks for your help, the problem is solved. I didn't notice that I was trying to duplicate a primary key value! That was why jasperETL couldn't create the table. So it was indeed a schema problem. Thanks. Nicole (I've just posted a new message, can you read it please??!)

Hi, I would like to know how to schedule data loading from a data base to a data warehouse. For example, I would like that every monday at 8 am new data of the database are loaded into the datawarehouse. That's a very important point of BI and I don't find how to execute it. I'm using JasperETL. This software is pretty good but is it possible to program it to do automatic loading? I saw the "schedule" menu but I don't think it is the good way. (What is it for??) Or do I have to get the perl code generated by JasperETL and to integrate it in my application? Please, if you have the response, light my way! Thanks Nicolep

Hi, When I start my job, I get this error message : DBD::mysql::st execute failed: Erreur de syntaxe près de '(19) NOT NULL , `nomClient` VARCHAR (30) NOT NULL )' à la ligne 6 at C:JasperETLworkspace.PerlDATEVCCIRCE.job_new.pl line 330. can't create table at C:JasperETLworkspace.PerlDATEVCCIRCE.job_new.pl line 330 I verified my schemas many times and I don't think there are mistakes. I also checked up the DATEVCCIRCE.job_new.pl file at line 330, it seems there is a problem in table creation! the line 330 is this one: $sth_tDBOutput_1->execute() So, does someone have an idea about this problem? Where could I modify the create table query used by the perl file? thanks Nicolep

Hi, Yes sorry this is CLEAN and not CLEAR..but I just made the mistake here! so my problem is still alive! Do I need to download and install some plugins? Thanks Nicolep

Hi, I'm trying to build JasperServer from the source code. I follow step by step the appropriate guide but I've got a BUILD ERROR when I execute the command : MVN CLEAR INSTALL. It says that the clear-plugin doesn't exist.. and when I just execute MVN INSTALL, it says that the site-plugin doesn't exist! So i've got problems with pulg-ins! Has someone an idea? Thanks Nicolep

Hello, I'm a beginner in business intelligence engineering and I'm looking for a reporting software. I think JasperReport seems to be a good one but can we use it on a transactional data base or must we build a multi dimensional data base? Thanks