-
Thankyou @jhyde. The additional problem to this is that although the query works fine, each time I click on the hierarchies in the UI, the values reshuffle and the query has no effect thereafter, (it has changed).
Is there a way around this to keep the query constant? I need TopCount each time while allowing users to drill through the hierarchy. Is this possible to achieve?
Regards,
naaziz.
2009-11-12 09:45:02 UTC by naaziz
-
I may have something wrong with my setup, I traced the incoming SOAP message and the fault detail composite is there, still when JPivot gets the fault detail in XMLA_SOAP with fault.getDetail(), the Detail object returns null (the rest of the SOAPfault object is fine, as you can see in the exception message above).
I'm running Jpivot on JBoss 4.2.3, JDK 1.6.0_16 , and JBoss WS jars. Any ins.
2009-11-11 16:35:34 UTC by pschor
-
Hello,
I need to catch and display in my jsp page any MDX syntax errors thrown by the jp:xmlaQuery tag; I tried to catch the JspException thrown by the tag but the error is not there (see below) any suggestions?
As a side note, if I run the query manually from a Java class, I'm able to catch an OlapException with the correct message , that means that JPivot is receiving the error message...
2009-11-10 21:00:43 UTC by pschor
-
The order of XML elements within the Mondrian schema file is very sensitive. NamedSet elements must come after all Measure and CalculatedMember elements in the cube. Elements that come in the wrong order are silently ignored.
2009-11-10 17:27:27 UTC by jhyde
-
I think some part of my message is cut off::
In schema
Topcount(.................)
.
2009-11-10 15:57:47 UTC by naaziz
-
Hi,
I was wondering if namedSet is supported in OpenI?
I get an error each time I try to use this feature. In my schema I have the following:
...........
TopCount([geography ].Children, 95, [Measures].[ResolutionTime]
And within the openI UI I make the followin query
SELECT
{[Measures].[ResolutionTime]} ON COLUMNS,
{[Top95]}...
2009-11-10 15:55:46 UTC by naaziz
-
There is an interface Bookmarkabel which is implemented by the OlapModel (the session attribute "query01"). You can ask it for getBoomkarkState() to capture the current state of the query and later call setBookmarkState() to restore it. This is probably what you want to do.
Andreas.
2009-11-04 19:10:58 UTC by avix
-
i apologize if this is very simple or covered in another thread.
I would like to capture the MDX at a given state from a user so it can be saved as a view specific to that user. we have a "my charts" function in our app, want to add jpivot support in there. so the user would get to a certain jpivot view of the data, already working in production just fine... my plan it to capture...
2009-11-03 16:56:25 UTC by stuckym44
-
I am experiencing some strange problem and I wanted to know if anyone has a clue that would help me fix it, or confirm that is is a jpivot but.
Using Mondrian with XMLA
I am having a Dimension with 2 hierarchies and with a virtual all level :
<Dimension caption="Period" name="PD" type="TimeDimension">
<Hierarchy...
2009-10-28 13:46:41 UTC by leconcombre
-
Hi Ati Rosselet
thanks for your reply, you are right.
More into details, I found the property "UseContentChecksum" to be applied to Mondrian connection string: if it is false (that is the default), the url or the schema is used as key for caching mechanism; if it is true, than the checksum of the schema (the one returned by the dynamic schema processor) is used as key instead...
2009-09-07 08:02:21 UTC by zerba78