Re: SQLServer OLAP and PivotTable OWC (Office Web Component)

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

From: Michael Vardinghus (michaelvardinghus_at_hotmail.com)
Date: 11/19/04 

Date: Fri, 19 Nov 2004 14:37:42 +0100

Another way to go was to try out AS dimensional security ....

<josh@nautilusnet.com> wrote in message
news:1100819875.075290.157370@z14g2000cwz.googlegroups.com...
> I have created a simple cube that contains a hierarchy of employees and
> managers (parent-child dimension). I am able to connect to the cube
> and drill-down through the dimension within the PivotTable OWC very
> easily. In the OWC it automatically creates fields for each level of -
> employee to manager (level 02, level 03, etc.)
>
> When users visit the page that contains the OWC I need to automatically
> filter the PivotTable by the visisting user (So they don't always have
> to find themselves in the list and select themself). I am able to
> obtain the visitors alias or employeeID (both of which are in the
> dimenstion) but I can't figure out how to get it to automatically
> filter by supplying criteria.
>
> I am desperate for answer to this problem since I can't seem to find
> anyone who can figure it out...
>
>
> Thanks
>

Relevant Pages

  • Re: Filtering a dimension based on value from another cube?
    ... creating a new dimension called "Targeted population". ... Employees with more then XX absences in the month ... calculated cells formula can apply the MDX formula in the cube. ... then the standard calculation is applied. ...
    (microsoft.public.sqlserver.olap)
  • SQLServer OLAP and PivotTable OWC (Office Web Component)
    ... I have created a simple cube that contains a hierarchy of employees and ... managers (parent-child dimension). ... I am able to connect to the cube ...
    (microsoft.public.sqlserver.olap)
  • Re: lightweight activeX control - browse single dimension
    ... Office XP OWC toolpack: ... >> against a cube. ... When you browse a dimension, Analysis Manager first ...
    (microsoft.public.sqlserver.olap)
  • Re: Calculated Member question
    ... also be saved in the cube as a calculated member rather than redefined ... {Measures.MyInternetSales,Measures.[Sales Amount]} ... > I have a measure table - Employees - where the only measure I'm really ... > an attribute of the status dimension. ...
    (microsoft.public.sqlserver.olap)
  • Calculated Member question
    ... I have a measure table - Employees - where the only measure I'm really ... an attribute of the status dimension. ... display it side by side with the total employee count. ... I'm thinking the way to do this is to add a calculated member that ...
    (microsoft.public.sqlserver.olap)