Discretization method question

Hi,

I wonder what type of expression I could use in the Discretization method property of a dimension attribute to achieve a custom grouping.

As an example, I have a margin % measure that I would also have available as a discretized dimension.

I guess first step would be to create a calculated member where the parent hierarchy would be dimension, then use discretization to specify something like

less than 0%
between 0% and 15%
greater than 15% and lower or equal 30%
greater than 30%

Any example out there?

Thanks,

Philippe

This article should explain it:

http://msdn2.microsoft.com/en-us/library/ms174810.aspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

disable select-all from mutli-value report parameter

Is there ANY way to disable the display of select-all from the mutli-value
report parameter option in SRS 2005 SP2? We use a custom "All" option and
would like to supress the default select-all that is displayed
Thanks,
RandyOn Jul 12, 8:59 am, "Randall M. Richardson"
<microlo...@.newsgroup.nospam> wrote:
> Is there ANY way to disable the display of select-all from the mutli-value
> report parameter option in SRS 2005 SP2? We use a custom "All" option and
> would like to supress the default select-all that is displayed
> Thanks,
> Randy
As far as I know, there is not (unless, of course, you revert back to
SP1). What is the reason you can't utilize the default Select All
functionality? Normally, this option is easy to implement as long as
you have a way to loop through the result set passed to the stored
procedure/query that sources the report. Normally, I handle this via a
while loop or cursor in the SP that loads a single column temp table
and then uses "where in/not in" the temp table. Hope this is helpful.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I never got a reply to my post... What is the answer? Can we disable the
default "Select All" option in SRS 2005
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:EdYYaZFyHHA.5836@.TK2MSFTNGHUB02.phx.gbl...
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Also, Am I in the wrong place? I thought I was supposed to get 48 hour or
less answer as an Empower ISV partner?
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:EdYYaZFyHHA.5836@.TK2MSFTNGHUB02.phx.gbl...
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||On Jul 25, 8:56 am, "Randall M. Richardson"
<microlo...@.newsgroup.nospam> wrote:
> Also, Am I in the wrong place? I thought I was supposed to get 48 hour or
> less answer as an Empower ISV partner?
> "Wei Lu [MSFT]" <we...@.online.microsoft.com> wrote in messagenews:EdYYaZFyHHA.5836@.TK2MSFTNGHUB02.phx.gbl...
> > Hi ,
> > How is everything going? Please feel free to let me know if you need any
> > assistance.
> > Sincerely,
> > Wei Lu
> > Microsoft Online Community Support
> > ==================================================> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> > ==================================================> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
My previous response (on July 12th) was that you cannot. I offered a
work around at that time. The other question Mr. Lu will need to
address, as I am not affiliated w/Microsoft.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hello Randall,
As Enrique Martinez mentioned in the previous post, you could not disable
the "Select All" unless you revert back to SP1.
He provide a workaround that you could use a SP to load a single column
temp table and then uses "where in/not in" the temp table.
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Disable Right Click?

Is there anyway to disable mouse right click events in Reporting Services
Reports?
I am using RS 2005.
On custom web pages, I can either use javascript/vbscript or set
oncontextmenu="return false".
How can I accomplish the same results using Reporting Services?
I've been searching and find no built-in property for my desired result. I
do have access to Visual Studio 2005, is there a custom way to provide what I
need using VB.Net or other method?
I realize that even if possible, users can probably get around it, but at
least it will limit users from exporting data to Excel for example.
Thanks!labsRcool@.community.nospan wrote:
> Is there anyway to disable mouse right click events in Reporting Services
> Reports?
> I am using RS 2005.
> On custom web pages, I can either use javascript/vbscript or set
> oncontextmenu="return false".
> How can I accomplish the same results using Reporting Services?
> I've been searching and find no built-in property for my desired result. I
> do have access to Visual Studio 2005, is there a custom way to provide what I
> need using VB.Net or other method?
> I realize that even if possible, users can probably get around it, but at
> least it will limit users from exporting data to Excel for example.
> Thanks!
I also responded to your other posting. It seems that you should
design a custom interface in VB.NET that allows a user to view the
report in some manner; but not actually have access to the report to
export it. I believe that an application can customize user access
much better.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Thanks EMartinez for your input.
When you say "VB.Net", are you refering to creating custom asp.net webpages
via vb.net, or are you suggesting the only way to accomplish my goal is to
move away from webpages all to gether?
Thanks
"EMartinez" wrote:
> labsRcool@.community.nospan wrote:
> > Is there anyway to disable mouse right click events in Reporting Services
> > Reports?
> >
> > I am using RS 2005.
> > On custom web pages, I can either use javascript/vbscript or set
> > oncontextmenu="return false".
> >
> > How can I accomplish the same results using Reporting Services?
> >
> > I've been searching and find no built-in property for my desired result. I
> > do have access to Visual Studio 2005, is there a custom way to provide what I
> > need using VB.Net or other method?
> >
> > I realize that even if possible, users can probably get around it, but at
> > least it will limit users from exporting data to Excel for example.
> >
> > Thanks!
> I also responded to your other posting. It seems that you should
> design a custom interface in VB.NET that allows a user to view the
> report in some manner; but not actually have access to the report to
> export it. I believe that an application can customize user access
> much better.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||On Mar 2, 5:10 pm, labsRc...@.community.nospan
<labsRcoolcommunitynos...@.discussions.microsoft.com> wrote:
> Thanks EMartinez for your input.
> When you say "VB.Net", are you refering to creating custom asp.net webpages
> via vb.net, or are you suggesting the only way to accomplish my goal is to
> move away from webpages all to gether?
> Thanks
> "EMartinez" wrote:
> > labsRc...@.community.nospan wrote:
> > > Is there anyway to disable mouse right click events in Reporting Services
> > > Reports?
> > > I am using RS 2005.
> > > On custom web pages, I can either use javascript/vbscript or set
> > > oncontextmenu="return false".
> > > How can I accomplish the same results using Reporting Services?
> > > I've been searching and find no built-in property for my desired result. I
> > > do have access to Visual Studio 2005, is there a custom way to provide what I
> > > need using VB.Net or other method?
> > > I realize that even if possible, users can probably get around it, but at
> > > least it will limit users from exporting data to Excel for example.
> > > Thanks!
> > I also responded to your other posting. It seems that you should
> > design a custom interface in VB.NET that allows a user to view the
> > report in some manner; but not actually have access to the report to
> > export it. I believe that an application can customize user access
> > much better.
> > Regards,
> > Enrique Martinez
> > Sr. SQL Server Developer
You should be able to use VB.NET to create custom web pages w/various
access levels.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Thank for your input.
I will attempt custom asp.net approach,
Thanks!
"EMartinez" wrote:
> On Mar 2, 5:10 pm, labsRc...@.community.nospan
> <labsRcoolcommunitynos...@.discussions.microsoft.com> wrote:
> > Thanks EMartinez for your input.
> >
> > When you say "VB.Net", are you refering to creating custom asp.net webpages
> > via vb.net, or are you suggesting the only way to accomplish my goal is to
> > move away from webpages all to gether?
> >
> > Thanks
> >
> > "EMartinez" wrote:
> >
> > > labsRc...@.community.nospan wrote:
> > > > Is there anyway to disable mouse right click events in Reporting Services
> > > > Reports?
> >
> > > > I am using RS 2005.
> > > > On custom web pages, I can either use javascript/vbscript or set
> > > > oncontextmenu="return false".
> >
> > > > How can I accomplish the same results using Reporting Services?
> >
> > > > I've been searching and find no built-in property for my desired result. I
> > > > do have access to Visual Studio 2005, is there a custom way to provide what I
> > > > need using VB.Net or other method?
> >
> > > > I realize that even if possible, users can probably get around it, but at
> > > > least it will limit users from exporting data to Excel for example.
> >
> > > > Thanks!
> >
> > > I also responded to your other posting. It seems that you should
> > > design a custom interface in VB.NET that allows a user to view the
> > > report in some manner; but not actually have access to the report to
> > > export it. I believe that an application can customize user access
> > > much better.
> >
> > > Regards,
> >
> > > Enrique Martinez
> > > Sr. SQL Server Developer
>
> You should be able to use VB.NET to create custom web pages w/various
> access levels.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>