<div>Julian, Thanks, that was it, I was way of with my xml, At one point I became a little desesperate so I tried anything that went through my mind. Now, with the 'schema' atribute the cube is working perfectly. I really appreciate your help and patience specially considering my ignorance in this topic. Thank you again.</div>
<div> </div>
<div>Regards,</div>
<div> Francisco MartМn C.<br><br> </div>
<div><span class="gmail_quote">2008/2/17, <a href="mailto:mondrian-request@pentaho.org">mondrian-request@pentaho.org</a> <<a href="mailto:mondrian-request@pentaho.org">mondrian-request@pentaho.org</a>>:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Send Mondrian mailing list submissions to<br> <a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a><br>
<br>To subscribe or unsubscribe via the World Wide Web, visit<br> <a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:mondrian-request@pentaho.org">mondrian-request@pentaho.org</a><br><br>You can reach the person managing the list at<br> <a href="mailto:mondrian-owner@pentaho.org">mondrian-owner@pentaho.org</a><br>
<br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Mondrian digest..."<br><br><br>Today's Topics:<br><br> 1. RE: RE: I need help conecting to Teradata (Julian Hyde)<br>
(Julian Hyde)<br> 2. RE: Parent-child hierarchies and StrToMember (Julian Hyde)<br> 3. RE: Problem with aggregate tables.. (Julian Hyde)<br><br><br>----------------------------------------------------------------------<br>
<br>Message: 1<br>Date: Sun, 17 Feb 2008 10:52:05 -0800<br>From: "Julian Hyde" <<a href="mailto:jhyde@pentaho.org">jhyde@pentaho.org</a>><br>Subject: RE: [Mondrian] RE: I need help conecting to Teradata (Julian<br>
Hyde)<br>To: "'Mondrian developer mailing list'" <<a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a>><br>Message-ID: <5C97BB5AC144409DAC0F71EC9EAACE0C@mackerel><br>Content-Type: text/plain; charset="iso-8859-1"<br>
<br>Really?<br><br> <Table name="GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000"/><br><br>isn't even valid XML and shouldn't parse.<br><br>Use the 'schema' attribute, and take those dots out of the table names. Let<br>
me know if that fixes the problem.<br><br>Julian<br><br>> -----Original Message-----<br>> From: <a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a><br>> [mailto:<a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a>] On Behalf Of Francisco MartМn C.<br>
> Sent: Sunday, February 17, 2008 6:38 AM<br>> To: <a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a><br>> Subject: [Mondrian] RE: I need help conecting to Teradata<br>> (Julian Hyde)<br>><br>> The base .xml I'm using is the one created with cube<br>
> designer, the reason I<br>> use '"."' is because Teradata doen't support table names<br>> longer tan 30 bytes<br>> so I have to put them like that (in the query). Im not in the<br>> office right<br>
> now so I can't check, but I think that when I putt he names with a '.'<br>> insteade of '"."' I got the 'Can't create native connection'<br>> error from<br>> mondrian. The file definition of the cube is:<br>
><br>> <?xml version="1.0" encoding="UTF-8"?><br>> <Schema name="cubosimple"><br>> <Cube name="cubosimple"><br>> <Table name="GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000"/><br>
> <Dimension name="Sexo"><br>> <Hierarchy name="Sexo" hasAll="true"<br>> allMemberName="All sexo"><br>> <Table<br>> name="GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000"/><br>
> <Level<br>> name="GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000.SEXO"<br>> table="GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000" column="SEXO"<br>> uniqueMembers="false"/><br>
> </Hierarchy><br>> </Dimension><br>> <Measure name="Monto" column="MONTO_CHEQUE" aggregator="sum"<br>> datatype="Numeric" formatString="#.##0,###"/><br>
> </Cube><br>> </Schema><br>><br>> Thanks.<br>><br>> FmC<br>><br>><br>><br>> Message: 1<br>> Date: Fri, 15 Feb 2008 13:03:13 -0800<br>> From: "Julian Hyde" <<a href="mailto:jhyde@pentaho.org">jhyde@pentaho.org</a>><br>
> Subject: RE: [Mondrian] RE: I need help conecting to Teradata (Julian<br>> Hyde)<br>> To: "'Mondrian developer mailing list'" <<a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a>><br>
> Message-ID: <27980DD428C24149B59AEFD732ABA466@mackerel><br>> Content-Type: text/plain; charset="iso-8859-1"<br>><br>> Are you using the 'schema' attribute of the <Table> element?<br>
> You should be.<br>> I have a feeling that you're doing funny stuff like putting<br>> '"."' in table<br>> names - if so, that's bound to confuse things.<br>><br>> Julian<br>><br>
><br>> _____<br>><br>> From: <a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a><br>> [mailto:<a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a>] On<br>
> Behalf Of Francisco Martmn<br>> Sent: Friday, February 15, 2008 7:35 AM<br>> To: <a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a><br>> Subject: [Mondrian] RE: I need help conecting to Teradata<br>
> (Julian Hyde)<br>><br>><br>> Apparently I screwed up the previous message because i<br>> attached a file...<br>> Sorry about that, Anyway, here it goes again without<br>> attachment... (In case<br>> that the message is duplicate I am Double sorry, I'm just new<br>
> here and need<br>> help)<br>><br>> Julian, thanks for the response, unfortunately I am still<br>> having problems, I<br>> now don't have the problem with the '>' delimiter. What I did<br>
> was create a<br>> new cube definition, very simple so I can test it. I modified<br>> the xml so it<br>> includes de Database name, but none of the .xml worked.<br>> Teradata is not case<br>> sensitive so that isn't a problem, but the query that<br>
> mondrian is creating<br>> is not working, Maybe I added the DB name in too may places<br>> (I added in<br>> every 'Table' and 'Table name' field). I modified the query from the<br>> modified definition so that it would work in teradata, the<br>
> 'correct' query<br>> would be:<br>><br>> select<br>> sum("GC_LiDEr_WRK"."TBL_CUBO_CLIENTES_MCL_3000"."MONTO_CHEQUE") as<br>> "m0"<br>> from "TBL_CUBO_CLIENTES_MCL_3000"<br>
><br>> Instead of the original:<br>><br>> select<br>> sum("GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000"."MONTO_CHEQUE") as<br>> "m0" from "GC_LIDER_WRK"."<br>
> TBL_CUBO_CLIENTES_MCL_3000" as<br>> "GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000"<br>><br>> I hope you can help me a bit more, I feel I'm getting close. Thanks a<br>> million.<br>
><br>> PS: I dont think it matters, but the JDBC driver I use in<br>> cube designer is<br>> older that the one in Design Studio, for some reason the new<br>> one does not<br>> connect in CD and the old one doesn't connect in DS.<br>
> PSS: Apparently I can't attach files here and to post the<br>> entire error logs<br>> + the definitions would be a bother to everyone, If more<br>> information is<br>> needed just ask.<br>><br>><br>
><br>> Message: 1<br>> Date: Thu, 14 Feb 2008 09:12:15 -0800<br>> From: "Julian Hyde" <<a href="mailto:jhyde@pentaho.org">jhyde@pentaho.org</a>><br>> Subject: RE: [Mondrian] I need help conecting to Teradata<br>
> To: "'Mondrian developer mailing list'" <<a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a>><br>> Message-ID: <459B0A2691BA494D8316BDD1BACB1082@mackerel><br>> Content-Type: text/plain; charset="iso-8859-1"<br>
><br>> Two errors here. First, it can't find the object. Have you<br>> maybe spelled the<br>> table in lowercase in your schema file, and it is uppercase<br>> in Teradata; or<br>> perhaps it needs to be qualified by a schema name in<br>
> teradata. Turn on SQL<br>> tracing (mondrian.trace.level=1) and see what SQL mondrian<br>> generates, then<br>> try running that SQL using teradata's command line.<br>><br>> Second, when you changed the schema.xml file you made it into<br>
> invalid XML. I<br>> think you forgot to terminate the <Level> element with />.<br>> Maybe you tried<br>> to put comments inside the Level element?<br>><br>> Julian<br>><br>><br>> _____<br>
><br>> From: <a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a><br>> [mailto:<a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a>] On<br>> Behalf Of Francisco Martmn<br>
> Sent: Thursday, February 14, 2008 4:48 AM<br>> To: <a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a><br>> Subject: [Mondrian] I need help conecting to Teradata<br>><br>><br>> Hello, I've been using Mondrn with Pentaho BI Suite and for<br>
> some reason I<br>> can't connect to Teradata with Mondrian, I can make reports<br>> using my DB, the<br>> problem only comes with Mondrian. Here's what I do:<br>><br>> I use Cube Designer to design and publish a cube, at this<br>
> point I have no<br>> problem accesing the data from Teradata, I can use the<br>> graphic interface<br>> perfectly. In Cube designer I have to use the JDBC drivers version<br>> <a href="http://03.01.00.102">03.01.00.102</a>, If I use newer ones I can't connect... So far so good<br>
><br>> Now to actually SEE the cube, The JDBC drivers defined in<br>> Jboss are version<br>> 12.0, here the version <a href="http://3.01.00.102">3.01.00.102</a> simply don't work. So, I go to<br>> localhost/samples/analysis and when I click on a SampleData<br>
> cube I can see<br>> it perfectly, but, a Teradatya cube... NOTHING, The only<br>> thing I see is the<br>> message from Jboss that goes like this:<br>><br>><br>> 10:23:15,865 INFO [STDOUT] , exec+fetch 47 ms, 0 rows<br>
> 10:23:15,865 ERROR [MondrianModel] Parse Failure<br>> mondrian.olap.MondrianException: Mondrian Error:Failed to<br>> parse query '<br>> select NON EMPTY {[Measures].[SUM of<br>> TBL_CUBO_CLIENTES_MCL_3000.RUTCLI]} ON columns, NON EMPTY<br>
> {([Sexo.Sexo].[All<br>> sexo], [Rango.Rango].[All r<br>> ango])} ON rows from [cubo0902]<br>> '<br>> at<br>> mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)<br>> .<br>
> .<br>> .<br>> .<br>> at java.lang.Thread.run(Thread.java:595)<br>> Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while<br>> parsing MDX statement '<br>> select NON EMPTY {[Measures].[SUM of<br>
> TBL_CUBO_CLIENTES_MCL_3000.RUTCLI]} ON columns, NON EMPTY<br>> {([Sexo.Sexo].[All<br>> sexo], [Rango.Rango].[All r<br>> ango])} ON rows from [cubo0902]<br>> '<br>> at<br>> mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)<br>
> .<br>> .<br>> .<br>> .<br>> 10:23:15,865 ERROR [MondrianModel] [NCR] [Teradata DBMS] : Object<br>> 'TBL_CUBO_CLIENTES_MCL_3000' does not exist.<br>> 10:23:15,865 ERROR [OlapModelProxy]<br>> com.tonbeller.jpivot.olap.model.OlapException: [NCR] [Teradata DBMS] :<br>
> Object 'TBL_CUBO_CLIENTES_MCL_3000' does not exist.<br>><br>><br>> (...And a lot more)<br>> Which seems to be because the name of the Database itself is<br>> nowehre to be<br>> found, it just references the tables. So, my natural instinct<br>
> suggest me to<br>> change the .xml and add the reference to the table... at this<br>> point I get<br>> the following error:<br>><br>><br>><br>> 10:27:51,940 ERROR [Logger] Error: Pentaho Pentaho BI<br>
> Platform 1.6.0.GA.863<br>> 10:27:51,940 ERROR [Logger]<br>> misc-org.pentaho.data.connection.mdx.MDXConnection:<br>> MDXConnection.ERROR_0002<br>> - "Unable to create a native connection for c<br>> onnection string: "Mondrian Error:Internal error: while<br>
> parsing catalog<br>> solution:samples/analysis/cuboprueba.mondrian.xml"<br>> mondrian.olap.MondrianException: Mondrian Error:Internal error: while<br>> parsing catalog solution:samples/analysis/cuboprueba.mondrian.xml<br>
> at<br>> mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)<br>> .<br>> .<br>> .<br>><br>> at java.lang.Thread.run(Thread.java:595)<br>> Caused by: org.eigenbase.xom.XOMException: Document parse<br>
> failed: [Fatal<br>> Error] :32:88: Element type "Level" must be followed by<br>> either attribute<br>> spec<br>> ifications, ">" or "/>".<br>><br>> at<br>> org.eigenbase.xom.wrappers.GenericDOMParser.handleErrors(Unknown<br>
> Source)<br>> at<br>> org.eigenbase.xom.wrappers.JaxpDOMParser.parseInputSource(Unknown<br>> Source)<br>> at<br>> org.eigenbase.xom.wrappers.GenericDOMParser.parse(Unknown Source)<br>> at mondrian.rolap.RolapSchema.load(RolapSchema.java:303)<br>
> ... 94 more<br>> 10:27:51,956 ERROR [Logger] Error end:<br>> 10:27:51,956 ERROR [Logger] misc-MondrianModelComponent:<br>> MondrianModel.ERROR_0001 - [es_82] getInitialQuery():<br>> Connection is not<br>
> valid: {PoolNeeded=fa<br>> lse, dataSource=java:TeradataDS, Provider=mondrian,<br>> Catalog=solution:samples/analysis/cuboprueba.mondrian.xml}<br>> 10:27:51,956 ERROR [PivotViewComponent] Error Start: Pentaho<br>
> Pentaho BI<br>> Platform 1.6.0.GA.863<br>> 10:27:51,956 ERROR [PivotViewComponent]<br>> 79ff1a2b-da37-11dc-ad54-931a72ea8013:COMPONENT:context-1735417<br>8-120290927190<br>> 9:cuboprueba.xactionBase.ERROR_000<br>
> 2 - Ejecuci>n fallida del Componente<br>> java.lang.NullPointerException<br>> at java.util.regex.Matcher.getTextLength(Matcher.java:1127)<br>><br>> .<br>><br>> .<br>><br>> .<br>><br>
> 10:27:51,956 ERROR [PivotViewComponent] Error end:<br>> 10:27:51,956 ERROR [RuntimeContext]<br>> 79ff1a2b-da37-11dc-ad54-931a72ea8013:RUNTIME:context-17354178-<br>1202909271909:<br>> cuboprueba.xaction RuntimeContext.ERRO<br>
> R_0012 - [es_33] ActionDefinition for PivotViewComponent did<br>> not execute<br>> successfully<br>><br>><br>> (Again, the error itself is a lot longer, but that seems like the most<br>> important part)<br>
> PLEASE, at this point Im desesperate, I've searched every<br>> forum I've found<br>> and I found nothing to help me, We have a lot of hope in this<br>> platform, but<br>> at this point it's begining to be a lot of trouble. HELP!!<br>
><br>> Thanks.<br>> Francisco Martmn C.<br>><br>> -------------- next part --------------<br>> An HTML attachment was scrubbed...<br>> URL:<br>> <a href="http://lists.pentaho.org/pipermail/mondrian/attachments/200802">http://lists.pentaho.org/pipermail/mondrian/attachments/200802</a><br>
> 14/a16cf8d4/at<br>> tachment-0001.html<br>><br>> ------------------------------<br>><br>> Message: 2<br>> Date: Thu, 14 Feb 2008 11:45:52 -0800<br>> From: "Julian Hyde" <<a href="mailto:jhyde@pentaho.org">jhyde@pentaho.org</a>><br>
> Subject: RE: [Mondrian] High Cardinality for Mondrian<br>> To: <<a href="mailto:luis.canals@stratebi.com">luis.canals@stratebi.com</a>><br>> Cc: <a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a><br>
> Message-ID: <2A840341C8ED4706A866F2BCCA09AF1A@mackerel><br>> Content-Type: text/plain; charset="us-ascii"<br>><br>> I have logged a bug to track this issue:<br>><br>> <a href="http://sourceforge.net/tracker/index.php?func=detail">http://sourceforge.net/tracker/index.php?func=detail</a><br>
> <<a href="http://sourceforge.net/tracker/index.php?func=detail&aid=1893">http://sourceforge.net/tracker/index.php?func=detail&aid=1893</a><br>985&group_id=3<br>> 5> &aid=1893985&group_id=35<br>
> 302&atid=414616<br>><br>> I have attached the code after I integrated it with the head<br>> revision. It is<br>> in the format produced by the packChange utility, so it<br>> should be easy to<br>> re-integrate with head in future.<br>
><br>> Packchange is described here:<br>><br>> <a href="http://p4web.eigenbase.org/open/util/index.html">http://p4web.eigenbase.org/open/util/index.html</a><br>><br>> and can be downloaded from here:<br>
><br>> <a href="http://p4web.eigenbase.org/open/util/bin/">http://p4web.eigenbase.org/open/util/bin/</a><br>><br>> It runs on linux and windows/cygwin.<br>><br>> Julian<br>> -------------- next part --------------<br>
> A non-text attachment was scrubbed...<br>> Name: changelist10559-large-dimension-support.tar.gz<br>> Type: application/x-gzip<br>> Size: 496848 bytes<br>> Desc: not available<br>> Url :<br>> <a href="http://lists.pentaho.org/pipermail/mondrian/attachments/200802">http://lists.pentaho.org/pipermail/mondrian/attachments/200802</a><br>
> 14/1f200d91/ch<br>> angelist10559-large-dimension-support.tar.gz<br>><br>> ------------------------------<br>><br>> _______________________________________________<br>> Mondrian mailing list<br>> <a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
> <a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>><br>><br>> End of Mondrian Digest, Vol 15, Issue 19<br>> ****************************************<br>
><br>><br>><br>> -------------- next part --------------<br>> An HTML attachment was scrubbed...<br>> URL:<br>> <a href="http://lists.pentaho.org/pipermail/mondrian/attachments/200802">http://lists.pentaho.org/pipermail/mondrian/attachments/200802</a><br>
> 15/f2951773/at<br>> tachment-0001.html<br>><br>> ------------------------------<br>><br>> _______________________________________________<br>> Mondrian mailing list<br>> <a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
> <a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>><br>><br>> End of Mondrian Digest, Vol 15, Issue 23<br>> ****************************************<br>
><br>> _______________________________________________<br>> Mondrian mailing list<br>> <a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>> <a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
><br><br><br><br>------------------------------<br><br>Message: 2<br>Date: Sun, 17 Feb 2008 10:59:52 -0800<br>From: "Julian Hyde" <<a href="mailto:jhyde@pentaho.org">jhyde@pentaho.org</a>><br>Subject: RE: [Mondrian] Parent-child hierarchies and StrToMember<br>
To: "'Mondrian developer mailing list'" <<a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a>><br>Message-ID: <0A64A0EC9F3445C4A7E54CD62CDF3A93@mackerel><br>Content-Type: text/plain; charset="KOI8-R"<br>
<br>Nikolay,<br><br>Can you please log a bug with all of this information in it. I will get to<br>it as soon as I can. If you can reproduce the problem against the FoodMart<br>database, even better - we will be able to fix it faster.<br>
<br>Julian<br><br>> -----Original Message-----<br>> From: <a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a><br>> [mailto:<a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a>] On Behalf Of Nikolay Samofatov<br>
> Sent: Sunday, February 17, 2008 3:32 AM<br>> To: Mondrian developer mailing list<br>> Subject: [Mondrian] Parent-child hierarchies and StrToMember<br>><br>> Hi, Dear Mondrian developers!<br>><br>> We have encountered an issue with parent-child hierarchies.<br>
><br>> The problem is that if you take UniqueName for a member in a<br>> parent-child hierarchy and than pass it to a StrToMember it<br>> cannot find<br>> a member.<br>><br>> The UniqueName is generated in the form:<br>
> <HierarchyName>.<AllMemeberName>.<ParentName>.<ChildName>......<br>><br>> Such name does not resolve in recent mondrian (tested<br>> perforce version<br>> as of yesterday).<br>><br>
> This logic doesn't work for a while already. I think this is a<br>> regression from Mondrian 2.2 release, but I didn't test to find exact<br>> build where it got broken.<br>><br>> To reference members in parent-child hierarchy now one has to use:<br>
> <HierarchyName>.<LevelName>.<MemberName><br>><br>> If so, shouldn't UniqueName return names in this form for<br>> members of a<br>> parent-child hierarchy?<br>><br>> As an example, see cube:<br>
><br>> <Cube name="Фильтры и представления"><br>> <Table name="KBK_REGION_FACT"/><br>><br>> <Dimension name="Территория" foreignKey="REGION"><br>
> <Hierarchy hasAll="true" parentColumn="PARENT_ID"<br>> allMemberName="Все территории" primaryKey="ID"><br>> <Table name="TERRITORY"/><br>
> <Level name="Территория" column="ID" nameColumn="CAPTION"<br>> parentColumn="PARENT_ID" uniqueMembers="true"><br>> <Property name="HasChildren" type="Numeric"<br>
> column="HAS_CHILDREN"/><br>> <Closure parentColumn="PARENT_ID"<br>> childColumn="TERRITORY_ID"><br>> <Table name="TERRITORY_CLOSURE"/><br>
> </Closure><br>> </Level><br>> </Hierarchy><br>> </Dimension><br>><br>> <Dimension name="КБК" foreignKey="KBK"><br>> <Hierarchy hasAll="true" allMemberName="Все коды"<br>
> primaryKey="KBK"><br>> <Table name="KBK_VIEW"/><br>> <Level name="КБК1" column="KBK1" uniqueMembers="true"/><br>> <Level name="КБК2" column="KBK2" uniqueMembers="true"/><br>
> <Level name="КБК" column="KBK" uniqueMembers="true"/><br>> </Hierarchy><br>> </Dimension><br>><br>> <Measure name="PARAM" column="AMOUNT" aggregator="sum"<br>
> formatString="#,###.00"/><br>><br>> </Cube><br>><br>> The query:<br>><br>> with member [Measures].[Test] as<br>> 'StrToMember([Территория].CurrentMember.UniqueName)'<br>
> select NON EMPTY {[Measures].[Test]}<br>> ON COLUMNS,<br>> crossjoin({[Территория].[Территория].[Венгрия]},<br>> {[КБК].AllMembers})<br>> ON ROWS<br>> from [Фильтры и представления]<br>><br>> Dies with:<br>
><br>> Caused by: mondrian.olap.MondrianException: Mondrian Error:MDX object<br>> 'Венгрия' not found in member '[Территория].[Все территории]'<br>> at<br>> mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:802)<br>
> at mondrian.olap.Util.lookupCompound(Util.java:585)<br>> at<br>> mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaRea<br>> der.java:345)<br>> at<br>> mondrian.olap.DelegatingSchemaReader.lookupCompound(Delegating<br>
> SchemaReader.java:100)<br>> at<br>> mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1539)<br>> at<br>> mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1506)<br>> at<br>
> mondrian.olap.fun.BuiltinFunTable$23.strToMember(BuiltinFunTab<br>> le.java:649)<br>> at<br>> mondrian.olap.fun.BuiltinFunTable$23$1.evaluateMember(BuiltinF<br>> unTable.java:639)<br>> at<br>> mondrian.calc.impl.MemberValueCalc.evaluate(MemberValueCalc.java:47)<br>
> at<br>> mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:529)<br>><br>><br>><br>> Nikolay Samofatov<br>> _______________________________________________<br>> Mondrian mailing list<br>
> <a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>> <a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>><br><br><br><br>------------------------------<br>
<br>Message: 3<br>Date: Sun, 17 Feb 2008 11:19:04 -0800<br>From: "Julian Hyde" <<a href="mailto:jhyde@pentaho.org">jhyde@pentaho.org</a>><br>Subject: RE: [Mondrian] Problem with aggregate tables..<br>To: "'Mondrian developer mailing list'" <<a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a>><br>
Message-ID: <29891C70C8A846DCB4B151BF55916870@mackerel><br>Content-Type: text/plain; charset="us-ascii"<br><br>I don't think any progress has been made on this issue. I looked at the<br>history of the email thread, and it quickly diverged into another issue. I<br>
ran the tests, but as I said, I need that regression test, and I'm not going<br>to have any time soon to write it. Maybe someone else will write it - my<br>description re. TestAggregationManager is as much as I'll give as far as<br>
'pointers' - any more and I'd be writing the code myself - but I have a<br>feeling that no one else will write the test.<br><br>So, please log a bug with all of this information in it, so it doesn't get<br>
forgotten, and we will get to it one day.<br><br>Julian<br><br><br>_____<br><br>From: <a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a> [mailto:<a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a>] On<br>
Behalf Of Ati Rosselet<br>Sent: Sunday, February 17, 2008 5:04 AM<br>To: Mondrian developer mailing list<br>Subject: Re: [Mondrian] Problem with aggregate tables..<br><br><br>Julian (and others?)<br>Ok... I give up.. I have no idea how to properly test these changes. Are<br>
they still applicable to the current CVS version? (I assume so.. since I<br>haven't seen any notes/commits pertaining to this problem). You mentioned<br>that you were going to run it through the regression suite to see if any<br>
problems popped up - but I never heard of any results.. Does this mean that<br>basically all is ok? This fix is kind of important.. pretty vital to us in<br>fact, and I'm surprised no-one else has encountered the problem I address in<br>
it. If you (or anyone) would be willing to either write the test, or give<br>me some pointers (I'm completely lost - probably partly from being in the<br>middle of a large .NET project :)), I'd be very grateful. I'll try to get<br>
the CVS version of 3.0 and see if the patches can still be applied.<br><br>Cheers<br>Ati<br><br><br>2007/10/23 Julian Hyde <<a href="mailto:julianhyde@speakeasy.net">julianhyde@speakeasy.net</a>>:<br><br><br>Ati,<br>
<br>Thanks for the fix. I've run your changes through the regression suite.<br>Looking good so far. I'll run the suite in all of its various property<br>settings tonight and see if anything pops out.<br><br>Since this change is a bug fix, I need a regression test before I will check<br>
in. I think you could construct a testcase based on the foodmart database.<br>Add the test to TestAggregationManager; testMultipleMeasures is an example<br>of a test which runs an MDX query and checks that a particular SQL query is<br>
generated. You will also need to use TestContext.create() to alter the XML;<br>testKeyExpressionCardinalityCache is an example of a test which does that.<br><br>Julian<br><br><br>_____<br><br><br>From: <a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a> [mailto:<a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a>] On<br>
Behalf Of Ati Rosselet<br><br>Sent: Monday, October 22, 2007 5:23 PM<br>To: Mondrian developer mailing list<br>Subject: Re: [Mondrian] Problem with aggregate tables..<br><br><br>sorry... cut and paste got me.. end of first function ended up after the end<br>
of the 2nd modified function. so<br><br> /**<br> * Finds ALL the child tables of the fact table with the given<br>columnName<br> * used in their left join condition. This is used by the<br>AggTableManager<br>
* while characterizing the fact table columns. (previous only<br>returned FIRST child)<br> */<br> public ArrayList<RolapStar.Table><br>findTablesWithLeftJoinCondition(final String columnName)<br>
<br> {<br> java.util.ArrayList<RolapStar.Table> tables = new<br>java.util.ArrayList<RolapStar.Table>();<br> for (Table child : getChildren()) {<br> Condition condition = child.joinCondition;<br>
if (condition != null) {<br> if (condition.left instanceof MondrianDef.Column) {<br> MondrianDef.Column mcolumn =<br> ( MondrianDef.Column) condition.left;<br>
if (mcolumn.name.equals(columnName)) {<br> tables.add(child);<br> }<br> }<br> }<br> }<br> return (tables.size()==0?null:tables);<br>
}<br><br>and remove the return part from other function..<br><br>Cheers..<br>Ati<br><br><br><br>_______________________________________________<br>Mondrian mailing list<br><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br><br><br><br><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://lists.pentaho.org/pipermail/mondrian/attachments/20080217/43be873f/attachment.html">http://lists.pentaho.org/pipermail/mondrian/attachments/20080217/43be873f/attachment.html</a><br>
<br>------------------------------<br><br>_______________________________________________<br>Mondrian mailing list<br><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br><a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br><br>End of Mondrian Digest, Vol 15, Issue 25<br>****************************************<br></blockquote></div><br>