joeri

This is the very basic workaround I made: After the ETL process, I call a script that will flush the cache. The Java class that will call the flushOlapCache() method and the sh script: Code:import com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapManagementServiceImpl;public class FlushCache { public static void main(String[] args) { new OlapManagementServiceImpl().flushOlapCache(); System.out.println("Flushing cache... Done."); }}## Run this script to flush the OLAP cache## Compose classpathfor i in /home/jasperserver/jasperserver-ce-3.7.1/apache-tomcat/webapps/jasperserver/WEB-INF/lib/*doCP="$CP:$i"done# run java commandjava -cp "$CP" FlushCache Post Edited by joeri at 02/22/2011 08:16

Hi, I have a question regarding caching on JasperServer CE 3.7.1. The clients are using the Excel ODBO connect plugin. The data is loaded on a daily basis using JasperETL. The problem I have is that the data from my clients isn't refreshed after a daily load. Even if the users do a refresh of the pivotTable data in excel it is't updated with the latest changes in the database. (I have to flush manually using the menu. I've tried adapting cache settings in mondrian.properties (mondrian.rolap.star.disableCaching=true) and in my cube xml file (caching="false") but the drop in performance is huge, so I'm looking for another solution. If you're using JSP to display data to your users, you could call the "flush OLAP cache" function: com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapManagementServiceImpl()).flushOlapCache(); but in my case I'm using excel. I was thinking there maybe was a way to call this function using JasperETL, that way I could include it in the daily load. Regards Joeri Post Edited by joeri at 02/21/2011 08:39

I'm running it on a Red Hat 3.4.6. Standard install. No virtual machine.

What version of JasperServer are you running? 3.7.1 ? I'm currentlty using 3.7.0 CE. I see there were some patches to Mondrian/OLAP for 3.7.0. Did you try these out already? http://jasperforge.org/plugins/mwiki/index.php/Jasperserverpatches/JasperServer_3.7.0_Patches_and_Extensions

Yes, I had the feeling that wasn't going to solve the problem. I think it's a bug (driver or excel) because I saved the xlsx file in which I had this error, closed it and opened it again in the same excel session, and I could reproduce the error on every operation I performed. I also restarted jasperserver and still I got the error in this xlsx file. Next, I restarted excel, opened the template, and it worked... having to restart excel all the time is a nightmare to my users Post Edited by joeri at 11/22/2010 10:18

Jaspersoft Support told me that this might be a memory problem in JasperServer. To increase memory for the JVM, you can modify the setenv.sh(or bat) file in the apache-tomcat/bin directory -Xms1800m -Xmx1800m (or a higher value) and restart jasperserver. I'm currently limited by my development machine which has only 2 Gb, so I wasn't able to test yet. I have my doubts about the solution because there aren't any outofMemory errors reporting on the serverside, but it's worth the try. Best Regards Joeri

Hi, We are currently evaluating the Excel Addon from jaspersoft. We often receive the following error in Excel: An operation that uses the database driver could not be completed. If the driver is a MS driver, make sure the driver file isn't damaged, and if it is, reinstall.. blablabla When we receive this error, there is no exception on the jasperserver, except a WARN, but this warning also is logged on successfull operations. 2010-10-28 16:34:08,683 WARN LoggerListener,http-9090-Processor21:60 - Authentication event AuthenticationSuccessEvent: userX ; details: org.springframework.security.ui.WebAuthenticationDetails@ffff4c9c: RemoteIpAddress: 192.168.10.51; SessionId: null2010-10-28 16:34:08,717 DEBUG mdx,http-9090-Processor21:556 - 628: select from [Products]where [Measures].[Orders]2010-10-28 16:34:08,718 DEBUG mdx,http-9090-Processor21:594 - 628: exec: 0 ms Here is relevant information from our excel datasource file: <html xmlns:o="urn:schemas-microsoft-com:office:office"xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/x-ms-odc; charset=utf-8"><meta name=ProgId content=ODC.Cube><meta name=SourceType content=OLEDB><meta name=Catalog content=DWHCube><meta name=Schema content=DWHCube><meta name=Table content=Products><title>DWHCube Products</title><xml id=docprops><o:DocumentProperties xmlns:o="urn:schemas-microsoft-com:office:office" xmlns="http://www.w3.org/TR/REC-html40"> <o:Description>DWHCube Schema - Products Cube</o:Description> <o:Name>DWHCube Products</o:Name> </o:DocumentProperties></xml><xml id=msodc><odc:OfficeDataConnection xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns="http://www.w3.org/TR/REC-html40"> <odc:Connection odc:Type="OLEDB"> <odc:ConnectionString>Provider=Jaspersoft ODBO Connect.1;Password=x;User ID=x;Data Source=http://xxx:9090/jasperserver/xmla;Extended Properties="Provider=Mondrian;DataSource=DWHCube;";Initial Catalog=DWHCube;Initial Catalog=DWHCube</odc:ConnectionString> <odc:CommandType>Cube</odc:CommandType> <odc:CommandText>Products</odc:CommandText> </odc:Connection> </odc:OfficeDataConnection></xml> I've also attached logging from the driver, and there is an error in it, but it's not clear to me what this means, except that a property is not found?[2010-10-28] [16:58:24.484] [006748] [Property ] ....+CBIDBPropertySet::PropertyIDLookup Value:* DBPROP_MULTIPLEPARAMSETS (NOT FOUND) *[2010-10-28] [16:58:24.484] [006748] [Error ] ..CBIDBPropertySet::GetProperties m_cPropFailed 1 Things I noticed: I saved the xlsx file in which I had this error, closed it and opened it again in the same excel session, and I could reproduce the error on every operation I performed. Next, I restarted excel, opened the template, and it worked. Some support is really appreciated.... Best Regards Joeri Peeters

What am I doing wrong? Anyone an idea?

Hi, I'm trying to join some tables in my mondrian schema with a custom query: <Dimension name="User"> <Hierarchy hasAll="true" allMemberName="All Users" primaryKey="USERID"> <Query> <SQL dialect="oracle"> SELECT * FROM DIMUSER INNER JOIN DIMCOUNTRY ON DIMUSER.bkcountry = DIMCOUNTRY.COUNTRYBK INNER JOIN DIMCONTINENT ON DIMCOUNTRY.continentbk = DIMCONTINENT.continentbk </SQL> </Query> <Level name="UserName" column="BKUSERNAME" uniqueMembers="true"/> <Level name="CountryName" column="COUNTRY" uniqueMembers="true"/> </Hierarchy> </Dimension> In my JasperServer Analysis View, I can't browse through the Levels that I've defined above (UserName and CountryName) As a matter of fact, I can even put invalid values in the Level in my mondrian schema. ?? It seems the Level elements are just ignored? <Level name="CountryName" column="INVALIIIIIDCOLUMN" uniqueMembers="true"/> What's the problem here? Thanks. Regards Joeri

Hi, I'm trying to join some tables in my mondrian schema with a custom query: <Dimension name="User"> <Hierarchy hasAll="true" allMemberName="All Users" primaryKey="USERID"> <Query> <SQL dialect="oracle"> SELECT * FROM DIMUSER INNER JOIN DIMCOUNTRY ON DIMUSER.bkcountry = DIMCOUNTRY.COUNTRYBK INNER JOIN DIMCONTINENT ON DIMCOUNTRY.continentbk = DIMCONTINENT.continentbk </SQL> </Query> <Level name="UserName" column="BKUSERNAME" uniqueMembers="true"/> <Level name="CountryName" column="COUNTRY" uniqueMembers="true"/> </Hierarchy> </Dimension> In my JasperServer Analysis View, I can't browse through the Levels that I've defined above (UserName and CountryName) As a matter of fact, I can even put invalid values in the Level in my mondrian schema. ?? It seems the Level elements are just ignored? <Level name="CountryName" column="INVALIIIIIDCOLUMN" uniqueMembers="true"/> What's the problem here? Thanks. Regards Joeri

I am having the same problem. I have created custom routines that I want to use. When I go via the navigator tab, i can add my java classes, but they disappear once I restart the JasperETL IDE. The code node is not available in the repository list. This is a frustrating issue.

This has been solved. You receive this error when: - Dimension table name is invalid - parentColumn, nameColumn, Column of a Level in your dimension hierarchy is invalid

Hi, I am creating a report that displays the number of unique users that placed an order per year. This is what my result looks like: /uploads/projects/jasperserver/image/report1.JPG This is how my dimension is defined in Mondrian. <Dimension type="StandardDimension" foreignKey="DATEID" name="date"> <Hierarchy hasAll="true" allMemberName="All Dates" primaryKey="DATEID"> <Table name="DIMDATE"/> <Level name="Year" column="CALENDARYEAR" uniqueMembers="true" /> <Level name="Quarter" column="CALENDARYEARQTR" uniqueMembers="true" /> <Level name="Date" column="FULLDATE" uniqueMembers="true"/> </Hierarchy> </Dimension> When I click on the + button for a particular Quarter, the drill down fails with error: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy Is there something wrong with my Mondrian? Something missing? Anyone has an idea? Thanks in advance. Best Regards Joeri Post Edited by joeri at 05/26/2010 10:00

I got it working with this workaround: First create the schema via the menu: Add Resource -> other -> OLAP Schema If you now create an analysis view, you can select the previously created OLAP schema from the repository (dropdown list) Add Resource -> other -> Analysis View

Anyone had this problem before? Thanks

Hi, When I try to create a new Analysis View, I receive the following error: 2010-05-07 17:29:04,390 WARN OlapConnectionServiceImpl,http-8085-Processor22:285 - Validation Failed for Olap Unit: ComOptest mondrian.olap.MondrianException: Mondrian Error:Internal error: Virtual file is not readable: repo:/analysis/views/DWH at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:808) at mondrian.olap.Util.newInternal(Util.java:1465) My MDX query works perfect in JasperAnalysis Schema Workbench. This is the query SELECT {[measures].[nrProducts]} ON COLUMNS, {descendants([Coops])} ON ROWS FROM [products] Any advice?

Nevermind; I found a good document about the JasperAnalysis Schema workbench; it allows to create cubes, so I will read through this first: http://community.jaspersoft.com/sites/all/libraries/pdf.js/web/viewer.html?file=http://community.jaspersoft.com/sites/default/files/docs/olap-workbench-user-guide.pdf#page=1

Hi All, I am new to ETL/Datawarehousing and I'd like to create a cube with JasperAnalysis, but i don't know where to start ! My ETL layer is ready: I read data from multiple source databases, transform them and store them in multiple dimension tables and I have one fact table containing products. (star schema) Now I want to build a cube with that data and also create measures (products per user for example) in the cube. Where do I go from here? How can I create a cube? Measures? using JasperAnalysis. is there any good documentation out there? Thanks in advance for your help! Regards, Joeri