Re: AS2005: Implementing a Static filter in a perspective?

Tech-Archive recommends: Fix windows errors by optimizing your registry

unfortunatly I can't
I access the cubes through OWC and Excel.

"Akshai Mirchandani [MS]" <akshaim@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:%236i$6wtUGHA.4952@xxxxxxxxxxxxxxxxxxxxxxx
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_@xxxxxxxxxxxxxx> wrote in message
news:%23f3i$SrUGHA.328@xxxxxxxxxxxxxxxxxxxxxxx
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.






.

Relevant Pages

  • Re: Help Required in building MDX Query
    ... member in each of your dimensions. ... I am facing trouble in making MDX ... > query, in which I have to set filter on the members of dimensions, ... > We have to provide the UI in which user can filter the data. ...
    (microsoft.public.sqlserver.olap)
  • Excel 2007 Pivot Table - Poor MDX?
    ... They have a dimension in the filter where they choose 22 of 24 members. ... They pull three dimensions down to rows - first is a hierarchy with 10 ... The Filter is built into a Calculated Member - uses AGGREGATE, ...
    (microsoft.public.sqlserver.olap)
  • [Full-Disclosure] KILL STRINGZ/EREBUS/PROPHET/BLACKFIST WEEK
    ... > you just made the filter today. ... only people with a brain read my "worthwhile" posts. ... Well basically when you map everything to 0 dimensions there is ... Life is a gift from thy Self to thy Self. ...
    (Full-Disclosure)
  • Re: Error executing MDX query
    ... The cubes this error occurs for are 1.08 MB and 13.2 MB. ... The other 2 are 1680 and 2 members each. ... What are the sizes of the two dimensions that you are crossjoining? ... Blog: http://www.geekswithblogs.net/darrengosbell ...
    (microsoft.public.sqlserver.olap)
  • Re: Assigning postal code from definitions table based on address elem
    ... filter by the all the ... make sure that the tblPostalCodeDefs is thoroughly ... > display it in the form as well as add it to the table of members. ...
    (microsoft.public.access.formscoding)