PDA

View Full Version : [Mondrian] Role "No HR Cube" can select against HR cube



Richard Emberson
03-28-2007, 05:20 PM
While looking into Roles (and having added a command-line
option to the CmdRunner, '-r role_name', allowing one
to set a role name from the command line) I discovered that
the query:

select {[Measures].[Org Salary]} on ROWS from HR;

returns:

Axis #0:
{}
Axis #1:
{[Measures].[Org Salary]}
Row #0: $39,431.67

regardless of whether one has no role or if one has the
role 'No HR Cube'.

Is this correct behavior?

Richard

--
Quis custodiet ipsos custodes:
This email message is for the sole use of the intended recipient(s) and
may contain confidential information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all
copies of the original message.
_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian

Julian Hyde
03-28-2007, 07:06 PM
That's a bug. Can you log it please.

Julian

> -----Original Message-----
> From: mondrian-bounces (AT) pentaho (DOT) org
> [mailto:mondrian-bounces (AT) pentaho (DOT) org] On Behalf Of Richard Emberson
> Sent: Wednesday, March 28, 2007 2:24 PM
> To: 'Mondrian developer mailing list'
> Subject: [Mondrian] Role "No HR Cube" can select against HR cube
>
>
> While looking into Roles (and having added a command-line
> option to the CmdRunner, '-r role_name', allowing one
> to set a role name from the command line) I discovered that
> the query:
>
> select {[Measures].[Org Salary]} on ROWS from HR;
>
> returns:
>
> Axis #0:
> {}
> Axis #1:
> {[Measures].[Org Salary]}
> Row #0: $39,431.67
>
> regardless of whether one has no role or if one has the
> role 'No HR Cube'.
>
> Is this correct behavior?
>
> Richard
>
> --
> Quis custodiet ipsos custodes:
> This email message is for the sole use of the intended
> recipient(s) and
> may contain confidential information. Any unauthorized review, use,
> disclosure or distribution is prohibited. If you are not the intended
> recipient, please contact the sender by reply email and destroy all
> copies of the original message.
> _______________________________________________
> Mondrian mailing list
> Mondrian (AT) pentaho (DOT) org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>

_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian