Issue with NamedSet

nadia aziz
  • nadia aziz

    nadia aziz - 2009-11-10

    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:

    <NamedSet name="Top95">
    <Formula>TopCount(.Children, 95, .</Formula>

    And within the openI UI I make the followin query
        {.} ON COLUMNS,
        {} ON ROWS

    However I get the following error that it does not recognise the nameset
            … 20 more
    Caused by: mondrian.olap.MondrianException: Mondrian Error:MDX object ''
    not found in cube 'New_Ticket9'
            at mondrian.resource.MondrianResource$_Def1.ex(
            at mondrian.olap.Util.lookup(
            at mondrian.olap.Id.accept(
            at mondrian.olap.ValidatorImpl.validate(
            at mondrian.mdx.UnresolvedFunCall.accept(
            at mondrian.olap.ValidatorImpl.validate(
            at mondrian.olap.QueryAxis.resolve(
            at mondrian.olap.ValidatorImpl.validate(
            at mondrian.olap.Query.resolve(
            at mondrian.olap.Query.resolve(
            at mondrian.olap.Query.<init>(
            at mondrian.olap.Query.<init>(
            at mondrian.olap.Parser.makeQuery(
            at mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(
            at mondrian.olap.Parser.do_action(
            at java_cup.runtime.lr_parser.parse(
            at mondrian.olap.Parser.parseInternal(
            … 21 more
    2009-11-10 16:44:39 ERROR org.openi.web.ui.jsf.component.WcfRenderer - render pr
    com.tonbeller.jpivot.olap.model.OlapException: Soap Fault code=Client.00HSBD01 f
    ault string=XMLA MDX parse failed fault actor=Mondrian
            at org.openi.olap.xmla.XmlaSoap.errorCheck(
            at org.openi.olap.xmla.XmlaSoap.executeQuery(
            at org.openi.olap.xmla.XmlaResult.<init>(
            at org.openi.olap.xmla.XmlaModel.getResult(
            at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapMode
            at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOla

    Any idea why??

    However I made another test, by including the NamedSet in the Query in the UI, it then works, but however this will be disturbed each time I click an element.

    Any pointers?



  • nadia aziz

    nadia aziz - 2009-11-10

    I think some part of my message is cut off::
    In schema
    <NamedSet name="Top95">

  • Julian Hyde

    Julian Hyde - 2009-11-10

    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.

  • nadia aziz

    nadia aziz - 2009-11-12

    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?



Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks