joeri
-
Posts
18 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by joeri
-
-
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?
-
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.. blablablaWhen 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 SchemaIf 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
JasperServer cache and how to flush olap cache
in Products
Posted
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:
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