Drilling down a recursive hierarchy

Hi,

We have two dimensions: User and Employee. Employees are recursive - each Employee can have several Employees that report to him/her and each Employee as a (or no) boss.

If a User has the right to access a specific employee he/she also has the rights to access his/her staff.

The following query returns all Employees a specific user has rights for.

select

filter([Employee].[Employee].members,[Measures].[UserEmployeeLink] > 0 ) on 0

from

[REPL]

where

([Measures].[UserEmployeeLink], StrToTuple("[User].[Login].&[XYZ]") )

How to modify this query that also all (directly and indirectly) subordinated employees of the queried employees are returned ?

There might exist cases, where a user has rights for employees at different levels, for instance for A and D.

+ B

|

A --| C

|

+ D

In this case, the query should return all, A, B, C and D.

Whishes,

Manfred

If I understand your question correctly, I think your looking for the DESCENDANTS function with the LEAVES parameter.

B.

Drilldown Problem Using Parent Hierarchy

Does anyone know how to create a parent-child hierarchy that can be expanded (ie drilldown capabilities) in reporting services as well as analysis services?

Currently, I have a dimension with three attributes: parent, child, and key. Everything works fine in Analysis Services. When I click browse for the cube and I add the parent-child hierarchy, Analysis Services autogenerates a drilldown from the top level to the bottom level. However, reporting services doesn't seem to recognize the parent hierarchy as being a true hierarchy. After I add the parent-child hierarchy to a table or matrix, it will only add the very first level. There doesn't seem to be any way for reporting services to autogenerate the drilldown like in Analysis Services.

I really need this to work on a report. Any ideas would be much appreciated? Thank you.

You need to set the parent property on the grouping, check out this page on Recursive Hierarchies for details http://msdn2.microsoft.com/en-us/library/ms155903.aspx|||That link applies to Report Designer but what about Report Builder? When I generate a SMDL from an Analysis Services cube, the model contains all my dimensions but if I drag them over to the report, it returns all the available members.

Drilldown Problem Using Parent Hierarchy

Does anyone know how to create a parent-child hierarchy that can be expanded (ie drilldown capabilities) in reporting services as well as analysis services?

Currently, I have a dimension with three attributes: parent, child, and key. Everything works fine in Analysis Services. When I click browse for the cube and I add the parent-child hierarchy, Analysis Services autogenerates a drilldown from the top level to the bottom level. However, reporting services doesn't seem to recognize the parent hierarchy as being a true hierarchy. After I add the parent-child hierarchy to a table or matrix, it will only add the very first level. There doesn't seem to be any way for reporting services to autogenerate the drilldown like in Analysis Services.

I really need this to work on a report. Any ideas would be much appreciated? Thank you.

You need to set the parent property on the grouping, check out this page on Recursive Hierarchies for details http://msdn2.microsoft.com/en-us/library/ms155903.aspx|||That link applies to Report Designer but what about Report Builder? When I generate a SMDL from an Analysis Services cube, the model contains all my dimensions but if I drag them over to the report, it returns all the available members.

drill-down capabilities and security implementation across different levels of h

Hi,

How to create the in crystal reports having drill-down capabilities and security implementation across different levels of hierarchy?
For instance, they can create a report having billing and booking Qty. that can be drilled-down across time dimension. Different levels could be year, month, week etc. Security should be implemented in such a way that a particular group of users can see data only at the week level, second group of users can see data at the month as well as the week level and third group can see all three - year, month and week data.

Can anybody helpppp??

smithaHi

CR is just a reporting tool, if u implement the security feature in the database that is accessed by the report, then you don't need to bother about it in the reports.