|
Home > Archive > MS SQL Server OLAP > March 2006 > AS2005: Implementing a Static filter in a perspective?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
AS2005: Implementing a Static filter in a perspective?
|
|
|
| Hi,
Does it possible to fix a filter for a perspective?
I want to create a perspective like: "Sales in Canada" where I filter my
geographie dimension to include only the Canada.
I have the same question but for excluding 1 member and forcing a visual
total.
does it possible?
thanks.
Jerome.
| |
| Akshai Mirchandani [MS] 2006-03-29, 3:29 am |
| Unfortunately in AS 2005, perspectives only allow restricting the
measures -- they don't allow restricting by members in other dimensions.
You could simulate this in a client/mid-tier application by sending a CREATE
SUBCUBE statement as the first statement to the cube...
Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Jéjé" < willgart_A_@hotmail_
A_.com> wrote in message
news:%23f3i$SrUGHA.328@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> Does it possible to fix a filter for a perspective?
> I want to create a perspective like: "Sales in Canada" where I filter my
> geographie dimension to include only the Canada.
>
> I have the same question but for excluding 1 member and forcing a visual
> total.
>
> does it possible?
>
> thanks.
>
> Jerome.
>
>
| |
|
| unfortunatly I can't
I access the cubes through OWC and Excel.
"Akshai Mirchandani [MS]" <akshaim@online.microsoft.com> wrote in message
news:%236i$6wtUGHA.4952@TK2MSFTNGP09.phx.gbl...
> Unfortunately in AS 2005, perspectives only allow restricting the
> measures -- they don't allow restricting by members in other dimensions.
>
> You could simulate this in a client/mid-tier application by sending a
> CREATE SUBCUBE statement as the first statement to the cube...
>
> Thanks,
> Akshai
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> Please do not send email directly to this alias. This alias is for
> newsgroup
> purposes only.
>
> "Jéjé" < willgart_A_@hotmail_
A_.com> wrote in message
> news:%23f3i$SrUGHA.328@TK2MSFTNGP11.phx.gbl...
>
>
|
|
|
|
|