1) We have Mondrian Olap engine. When i tried to do fields filtering over Time dimension in column of kendo ui pivot grid, mondrian gave following error saying the MDX query pivot grid sent as a part of xml request could not be parsed. Here Mondrian could not understand SELECT statement after FROM.
Mondrian error:
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: While parsing SELECT NON EMPTY {CROSSJOIN({[Time].[All Time]},{{[Measures].[Revenue],[Measures].[Margin],[Measures].[Cost]}})} DIMENSION PROPERTIES CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON COLUMNS, NON EMPTY {[Product].[All Product],[Product].[All Product].Children} DIMENSION PROPERTIES CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON ROWS FROM (SELECT (Filter([Time].[All Time].MEMBERS, InStr([Time].[All Time].CurrentMember.MEMBER_CAPTION,"2014") > 0)) ON 0 FROM [Transaction])
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:967) ~[MondrianResource$_Def0.class:na]
at mondrian.olap.Util.newInternal(Util.java:2400) ~[Util.class:na]
at mondrian.olap.Util.newError(Util.java:2416) ~[Util.class:na]
at mondrian.parser.JavaccParserValidatorImpl.convertException(JavaccParserValidatorImpl.java:110) ~[JavaccParserValidatorImpl.class:na]
at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:59) ~[JavaccParserValidatorImpl.class:na]
at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:96) ~[ConnectionBase.class:na]
... 88 common frames omitted
Caused by: mondrian.olap.MondrianException: Mondrian Error:Syntax error at line 1, column 332, token '('
at mondrian.parser.JavaccParserValidatorImpl.convertException(JavaccParserValidatorImpl.java:99) ~[JavaccParserValidatorImpl.class:na]
... 90 common frames omitted​
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2) Pivot grid does not display members under Include Fields option as well to select.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3) Similarly I had my my Time hierarchy expanded until month level in column and product dimension expanded until department level. Now when i tried to click on Dairy in department level to drill down further, mondrian throws me an error again saying Tuple contains more than one member of hierarchy '[Time]' as follows
Mondrian error:
Caused by: mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'SELECT NON EMPTY {CROSSJOIN({CROSSJOIN({[Time].[All Time]},{[Time].[2014]})},{{[Measures].[Revenue],[Measures].[Margin],[Measures].[Cost]}}),CROSSJOIN({CROSSJOIN({[Time].[All Time].Children},{[Time].[2014]})},{{[Measures].[Revenue],[Measures].[Margin],[Measures].[Cost]}}),CROSSJOIN({CROSSJOIN({[Time].[All Time]},{[Time].[2014].Children})},{{[Measures].[Revenue],[Measures].[Margin],[Measures].[Cost]}}),CROSSJOIN({CROSSJOIN({[Time].[All Time]},{[Time].[2014].[201409].Children})},{{[Measures].[Revenue],[Measures].[Margin],[Measures].[Cost]}})} DIMENSION PROPERTIES CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON COLUMNS, NON EMPTY {[Product].[Dairy],[Product].[Dairy].Children} DIMENSION PROPERTIES CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON ROWS FROM [Transaction]'
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:967) ~[MondrianResource$_Def0.class:na]
at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:100) ~[ConnectionBase.class:na]
at mondrian.olap4j.MondrianOlap4jStatement$1.execute(MondrianOlap4jStatement.java:362) ~[MondrianOlap4jStatement$1.class:na]
at mondrian.olap4j.MondrianOlap4jStatement$1.execute(MondrianOlap4jStatement.java:360) ~[MondrianOlap4jStatement$1.class:na]
at mondrian.server.Locus.execute(Locus.java:87) ~[Locus.class:na]
at mondrian.server.Locus.execute(Locus.java:72) ~[Locus.class:na]
at mondrian.olap4j.MondrianOlap4jStatement.parseQuery(MondrianOlap4jStatement.java:356) ~[MondrianOlap4jStatement.class:na]
... 83 common frames omitted
Caused by: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy '[Time]'.
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:964) ~[MondrianResource$_Def0.class:na]​
A similar question has been asked here: http://www.telerik.com/forums/hide-totals and http://www.telerik.com/forums/hide-aggregate-values .
For a project it would be extremelly useful to have a pivot grid with local binding without the agregate values and all measures allways expanded. Basically ​one wants to show only the basic values while keeping the ability to change the dimension axis. It can be done with a normal multicolumn grid but would require much more coding.
In the attached examples one wants the image result:
Hi,
I was trying to globalize the Datepicker in a kendo grid in the filter row(option set)
I added the de-DE language package.
Setting the culture option of the Datepicker didn'tt work(dojo)
Whereas in fiddle it worked.
Although it worked in fiddle I could not made it run in my code.
Could you please help and give a running dojo, thanks.
1) Is it possible to remove the gap in timeline event (like attached image) ?
2) Is it possible divide hours in quarter ?
Hi,
I'm trying to make the following scenario, i searched for it, tried to extend the Grid but sadly i cant figure it out.
I'm adding a new row to the Grid, mode is popup. its just a simple html template , and of course the Update/Cancel button are appended by the Grid. ( for now its working perfectly)
I Added a third button which is "Save & New" and renamed the Update to "Save & Close".
The "Save & Close" Button is working as expected, the row is inserted and the popup is closed, (the default behaviour)
What I'm trying to achieve with the "Save & New", is simply, not to let the popup close after the insertion of the row, and of course clear the fields, so the user can re-fill them. ( straight forward business logic ).
is there ​a way that i can achieve this logic? I guess we can because when i press the Add button in the toolbar, the fields are emptied ( the model is emptied )
what are the events that I need to look at? is there a special one that I should extend?
Thanks
Hello,
I have setup a grid wrapped in a Bootstrap column layout. At smaller screen sizes the scrollable area (and header) may exceed the width defined by the Bootstrap layout. The pager however does not - it remains within the bounds defined by the layout.
Is there any way to force the pager to follow the size of the rest of the grid?
Thank,
Casper