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

When you say obtain you mean what ?

On the dimension there is a default member possibility - using this you can
either "hard-code" a specific member or use
MDX to construct some kind of logic - but this logic needs to get some
information on who the user is...where would
you get that ? From Active Directory ?

<josh (AT) nautilusnet (DOT) com> wrote

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


<josh (AT) nautilusnet (DOT) com> wrote

I am able to get the user information from ActiveDirectory and use that
to pass-in...


Thanks,
Josh

Any one else have any ideas?

Thanks,
Josh

I think that you can just get this data from WMI and then update the XMLDATA
property of the OWC in order to specify this as a filter.




<josh (AT) nautilusnet (DOT) com> wrote

Yeah... I have no problem getting the ALIAS of the user. It's the
setting of the XMLDATA or automating the grid creation via javascript
that I can't seem to figure out. The problem is that in the
Parent...Child dimension types the "Fields" are generated the OLAP
server automatically "Level 01", "Level 02", "Level 03", etc... In the
javascript when I try to access the field to apply a filter I don't
what level the "User" is going to be at so I don't know with
Field/Level to apply the filter.

I would like to just apply the filter at some parent/dimenstion level
and let the control figure out the filtering. Or optionally do some
sort of MDX query which will filter the datasource before I ever attach
to the grid. I can't figure that out either becuase of the same
problem of not knowing the levels....


Any ideas?