[Mondrian] Reg. Drill Through

Smruti Naik mehtasmruti at gmail.com
Sat Nov 17 04:05:49 EST 2007


Can  you please tell me in more details  >?
i have defined Schema in Xml file and i refer that xml file in one jsp page
?
i could nt get your mean to say ,,,,
Please tell me .....

Regrads,
Smruti.



On Nov 16, 2007 10:30 PM, <mondrian-request at pentaho.org> wrote:

> Send Mondrian mailing list submissions to
>        mondrian at pentaho.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        http://lists.pentaho.org/mailman/listinfo/mondrian
> or, via email, send a message with subject or body 'help' to
>        mondrian-request at pentaho.org
>
> You can reach the person managing the list at
>        mondrian-owner at pentaho.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Mondrian digest..."
>
>
> Today's Topics:
>
>   1. Reg. Drill Through (Smruti Naik)
>   2. RE: Reg . Formatting Levels (Julian Hyde)
>   3. Store/Restore MDX Query ? (Eduardo Andrade)
>   4. Re: Reg. Drill Through (Haridasan T)
>   5. RE: Store/Restore MDX Query ? (Julian Hyde)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 16 Nov 2007 19:11:52 +0530
> From: "Smruti Naik" <mehtasmruti at gmail.com>
> Subject: [Mondrian] Reg. Drill Through
> To: mondrian at pentaho.org
> Message-ID:
>        <64c4ff000711160541v6211aaa4i8e3bad4d07cfffbb at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hello ,
>
> I hope will get reply sooon,
> In drill through table for specific measure we can only see the levels
> defined in specific Dimension ,
> if i want to see the additional levels in drillthrough which i dont have
> in
> JPivot table , how can i do that ?
>
> suppose i have Orgunit dimention upto team level ,
> i want to see User id and name in Drillthrough table ,
> How can i do that?
>
> Regards,
> Smruti
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.pentaho.org/pipermail/mondrian/attachments/20071116/5b9ce876/attachment-0001.html
>
> ------------------------------
>
> Message: 2
> Date: Fri, 16 Nov 2007 07:12:03 -0800
> From: "Julian Hyde" <jhyde at pentaho.org>
> Subject: RE: [Mondrian] Reg . Formatting Levels
> To: "'Mondrian developer mailing list'" <mondrian at pentaho.org>
> Message-ID: <55F4E291D05842179B587A6F35C353FA at mackerel>
> Content-Type: text/plain; charset="us-ascii"
>
> I think I answered that question in the last 2 weeks. Look through the
> forums.
>
> Julian
>
>
>  _____
>
> From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
> On
> Behalf Of Smruti Naik
> Sent: Wednesday, November 14, 2007 10:37 PM
> To: mondrian at pentaho.org
> Subject: [Mondrian] Reg . Formatting Levels
>
>
> Hello there ,
> in Jpivot table when i drill through any field then i am getting all
> timedimention value as
> suppose Year 2007 then it is 2,007 .00 so i want to format it .
> can you please tell how to do that ?
> Regards,
> Smruti
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.pentaho.org/pipermail/mondrian/attachments/20071116/d7406d80/attachment-0001.html
>
> ------------------------------
>
> Message: 3
> Date: Fri, 16 Nov 2007 15:22:35 +0000
> From: "Eduardo Andrade" <eduardofandrade at gmail.com>
> Subject: [Mondrian] Store/Restore MDX Query ?
> To: "Mondrian Mailing List" <mondrian at pentaho.org>
> Message-ID:
>        <13557f840711160722i2e84ac57m9cbdef804e27fb0b at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hello,
> we're using using jPivot+Mondrian to provide multidimensional analysis.
> We permit that users save their "views" of data (MDX Query) and restore
> them
> later.
> The problem is that some MDX queries that jPivot built, contains explicit
> referneces to dimension members, thus limiting the view of the underliyng
> data. So if data changes on the datasource, the view doesn't present those
> changes.
> Is there a way to achieve this ? Storing something that is independent of
> the data, automatically ?
>
> P.S.: I know that probably this is a jPivot limitation but i just want to
> be
> sure that I can't use mondrian to store/restore the model with some
> arbitrary state reflecting a user's view of the data.
>
> Thank you so much,
> --
> Eduardo Andrade
> eduardofandrade at gmail.com
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.pentaho.org/pipermail/mondrian/attachments/20071116/7d406c40/attachment-0001.html
>
> ------------------------------
>
> Message: 4
> Date: Fri, 16 Nov 2007 21:26:52 +0530
> From: "Haridasan T" <haridasan.t at gmail.com>
> Subject: Re: [Mondrian] Reg. Drill Through
> To: "Mondrian developer mailing list" <mondrian at pentaho.org>
> Message-ID:
>        <1475574a0711160756q1d861dcr1489fe620f72de6e at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> keep userid and name in the xml page - not in jsp page - sql
> when u drill through user id and name can be seen
>
> On 11/16/07, Smruti Naik <mehtasmruti at gmail.com> wrote:
> > Hello ,
> >
> > I hope will get reply sooon,
> > In drill through table for specific measure we can only see the levels
> > defined in specific Dimension ,
> > if i want to see the additional levels in drillthrough which i dont have
> in
> > JPivot table , how can i do that ?
> >
> > suppose i have Orgunit dimention upto team level ,
> > i want to see User id and name in Drillthrough table ,
> > How can i do that?
> >
> > Regards,
> > Smruti
> > _______________________________________________
> > Mondrian mailing list
> > Mondrian at pentaho.org
> > http://lists.pentaho.org/mailman/listinfo/mondrian
> >
> >
>
>
> --
> http://cfo-portal.blogspot.com/
>
>
> ------------------------------
>
> Message: 5
> Date: Fri, 16 Nov 2007 16:34:17 -0000
> From: "Julian Hyde" <jhyde at pentaho.org>
> Subject: RE: [Mondrian] Store/Restore MDX Query ?
> To: "'Mondrian developer mailing list'" <mondrian at pentaho.org>
> Message-ID: <98E03240EB2D43409746EB1EB828F225 at mackerel>
> Content-Type: text/plain; charset="us-ascii"
>
> Mondrian doesn't support this.
>
> One option is to convert explicit members into parameters. This is useful
> if
> you are creating a set of reports, less useful for end users saving their
> reports.
>
> Matt Campbell recentedly (change 10052) added an option to tell mondrian's
> parser/validator to ignore invalid members: see
> mondrian.rolap.ignoreInvalidMembersDuringQuery in MondrianProperties.java.
> This will be in mondrian 3.0.
>
> Julian
>
>
>  _____
>
> From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
> On
> Behalf Of Eduardo Andrade
> Sent: Friday, November 16, 2007 3:23 PM
> To: Mondrian Mailing List
> Subject: [Mondrian] Store/Restore MDX Query ?
>
>
> Hello,
> we're using using jPivot+Mondrian to provide multidimensional analysis.
> We permit that users save their "views" of data (MDX Query) and restore
> them
> later.
> The problem is that some MDX queries that jPivot built, contains explicit
> referneces to dimension members, thus limiting the view of the underliyng
> data. So if data changes on the datasource, the view doesn't present those
> changes.
> Is there a way to achieve this ? Storing something that is independent of
> the data, automatically ?
>
> P.S.: I know that probably this is a jPivot limitation but i just want to
> be
> sure that I can't use mondrian to store/restore the model with some
> arbitrary state reflecting a user's view of the data.
>
> Thank you so much,
> --
> Eduardo Andrade
> eduardofandrade at gmail.com
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.pentaho.org/pipermail/mondrian/attachments/20071116/285ea998/attachment-0001.html
>
> ------------------------------
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
> End of Mondrian Digest, Vol 12, Issue 8
> ***************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20071117/a7e4fa0c/attachment.html 


More information about the Mondrian mailing list