jshih
-
Posts
24 -
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 jshih
-
-
There are two problems with this schema:
1. The schema needs a name. Otherwise, it cannot be loaded by the schema editor, e.g., <Schema name="FoodMart">
2. 'Store Costs' is used in the CalculatedMember, but not defined as a measure. So, add: <Measure name="Store Cost" column="store_cost" aggregator="sum" formatString="#,###.00"/>
And after the above changes, the query suggested by Sebastian can be run. If you want to fix the original query, change the ‘descendants’ to ‘children’, i.e.,
SELECT {[Measures].[unit Sales], [Measures].[store Sales]} ON COLUMNS,
{[Time].[1997].[Q1].children} ON ROWS
FROM [sales]
WHERE [Gender].[F]
-
If you are familiar with Eclipse, you may start by using the two Eclipse project files - .project and .classpath, located in the jasperserver directory to import the project called 'jasperserver'.
Jenngang
JasperSoft
-
Yes, you still need settings.xml, but in case you have the element <offline>true</offline> defined in the file, remove the element or change the value to false.
Jenngang
JasperSoft
-
From the build outputs, looks like you are building in the ‘offline’ mode which prevents you from getting needed files from online sources. So, either change <offline>true</offline> to false in your settings.xml, and/or don’t use the offline (–o) option at the command line, and try the build again.
Also, if you are building this version of JasperServer for the first time, it’s a good idea to remove the existing directories/files under Maven's .m2repository directory in case the new version has new dependencies that conflict with the existing ones.
Jenngang
JasperSoft
-
After trying Maven version: 2.0.7, it doesn't seem to be the problem. What exception did you get when building with Maven version: 2.0.7? I don't find the attachment you mentioned.
Jenngang
JasperSoft
-
Regarding the Maven exception, try Maven version: 2.0.4 if that is not the one you are using.
Jenngang
JasperSoft
-
Since the totals are pre-defined, it is possible to display a total that does not match the sum when a user omits a sub-category shown in your earlier example.
Like the underlining MDX, the GUI does not detect such a discrepancy. This would be a good usability enhancement.
For now, the WITH construct can be used to ensure that the sum matches the sub-categories.
Jenngang
JasperSoft
-
I am not sure I understand the question precisely.
However, since the 'with' construct used in the earlier example is a standard MDX language construct, and as long as the Microsoft Analysis Services interprets a query according to the MDX language definition, it should work.
Jenngang
JasperSoft
-
This can be done using the 'with' construct.
Try this:
with member [Product].[FoodAndDrink] as '([Product].[All Products].[Food] + [Product].[All Products].[Drink])'
select {[Measures].[unit Sales]} ON COLUMNS,
{[Product].[FoodAndDrink], [Product].[All Products].[Drink], [Product].[All Products].[Food]} ON ROWS
from [sales]
Jenngang
JasperSoft
-
Please make sure you have the following database creation and jdbc connection settings:
- create database with the utf8 characterset option, e.g., 'create database foodmart_cn character set utf8;'
- add encoding options to jdbc connection string, e.g., 'jdbc:mysql://localhost:3306/foodmart_cn? useUnicode=true&characterEncoding=UTF-8'
Jenngang
JasperSoft
-
I noticed that the encoding used in the schema is GBK, which may be the problem, since Jasperserver supports UTF-8.
Jenngang
JasperSoft
-
Please see a similar posting below for a resolution to the #{${... problem.
Jenngang
JasperSoft
-
The next release should be around mid-August.
Jenngang
JasperSoft
-
#{${requestScope.name}/table}" is the result of embedding JSP expression ${} inside the JPivot expression #{}, specifically in viewOlap.jsp.
While the combined expression works in earlier versions of Tomcat, it starts to fail in Tomcat 6. We are considering changing the JPivot expression to #() to get around the problem. If everything goes well, the fix will be included in the next release.
Jenngang
JasperSoft
-
PDF for analysis view is rendered using Apache FOP (http://xmlgraphics.apache.org/fop/). Some knowledge of it is helpful.
The file for rendering PDF is called fo_mdxtable.xsl, and can be found in the WEB-INF directory, for example c:Tomcatapache-tomcat-6.0.13webappsjasperserverweb-infjpivottableWEB-INFjpivottablefo_mdxtable.xsl, where ‘c:Tomcatapache-tomcat-6.0.13’ is tomcat deployment directory, ‘jasperserver’ is the context root
Jenngang
JasperSoft
-
We have recently released version 2.0.0, and I just tried adding an analysis view with mondrian connection, a mondrian schema, and a JDBC datasource, all at once, and worked.
In this example, I put connection, schema, and datasource in their respective folder, namely views, connections, schemas, and datasources for ease of maintenance.
I believe the problem you are experiencing was a bug in the previous releases.
-Jenngang
-
One way to do this is using Firefox's Save Page As function. That is, when you are ready to share the page using Firefox, select 'File'/'Save Page As' and provide a name for the page. This will create an html file with the name you supplied. The saved html file can be loaded back with a browser, such as IE or Firefox.
If you have access to JasperServer Prefessional version, there are 'Save View As' and 'Save View' functions that save the view with chart, drill through table, and settings in the repository, so the view can be shared with others on the same server by loading the view you saved.
-Jenngang
-
The measures in the drilldown table is implemented as BigDecimal, but no formatting feature is implemented.
If you have access to the JasperServer Professoinal version, the drilldown table there can be exported as a CSV file and number fomratting can be done by using third party software, such as Excel.
Jennang
-
Please see the following posting for a solution:
In short,
"just change in busy.jsp row 35 the url from ' url=<c:url value="${requestSynchronizer.resultURI}" /> ' to ' url="${requestSynchronizer.resultURI}" '"
Jenngang
-
What are the steps you used that generate the busy.jsp?
A quick look at the code does not find 'jasperserver' hardcoded anywhere, so it looks like an env/config issue.
Also, the 'No OLAP Model name' bug will be fixed in the next release.
Jenngang
JasperSoft
-
The jsp page for input controls is FillParams.jsp, and can be found in [install_dir]jasperserver-warsrcmainwebappweb-infjsp
Typically, when using input controls, one would want to put some values in the input control fields. Then, the submit button will have focus.
-
The jsp page for input controls is FillParams.jsp, and can be found in [install_dir]/jasperserver-war/src/main/webapp/web-inf/jsp/
(change to 'forward slash' from 'backward slash' that got lost in the text above)
Typically, when using input controls, one would want to put some values in the input control fields. Then, the submit button will have focus.
Post edited by: jshih, at: 2006/07/29 00:22
-
Since Mondrian schema can have a role attribute, you should be able to pass the role to Mondrian with the query (See http://mondrian.sourceforge.net/schema.html).
Can't display Japanese Label and Discription
in Products
Posted
Try using utf-8 encoding to re-create your database (e.g., create database jasperserver character set utf8;), configuring tomcat to recognize utf-8 encoding (e.g. URIEncoding="UTF-8" in conf/server.xml), and defining jdbc connection accordingly (e.g., url="jdbc:mysql://localhost:3306/jasperserver?
useUnicode=true&characterEncoding=UTF-8").
See the JasperServer-Localization-Guide for more details.
Jenngang
JasperSoft