View Complete Post
I have a problem with the parent-child-hierarchy after page reload.
Wie use SSAS 2005 and SSRS 2005 with newest service packs and patches. The parent-child-hierarchy works in the reports excellently. But we have a hierarchy with 9 levels. If the users expand some levels and thereafter change the filter or
sort the columns, will be the page reloaded and whole hierarchy is collapsed again.
Can you suggest a solution for this problem. Is the problem solved in SSRS 2008?
I have a dimension with a parent-child hierarchy on the key attribute and another attribute for the parent. I also want to declare a role with a permission to view only a specific member of that dimension, but it doesn't let me define a restriction on the
key attribute and says I must define the equivalent restriction on the parent attribute. The problem is that I don't know how to accomplish that because I must use a specific value, so I can't restrict it using this value's parent or children. I might be stupid,
but I really have no idea how to do it...
What's the best way to represent a Parent-Child hierarchy in the Cube? I've seen the Usage that can be applied as Parent.
I've applied this, for example,
ID ParentID CompanyName Rank
1 1 AAA Excellent
2 1 BBB Good
3 1 CCC Ok
4 1 DDD None
I can link the ID and ParentID Usage appropriately by setting the ParentID to a Usage of Parent. I've also set the Parent Key, so that if the Company rolls up to itself, it doesn't show the Parent as its own child (NonLeafDataHidden).
When using only the CompanyName in the Cube Browser / Excel, this is working okay.
The problem occurs when trying to bring in other attributes, such as Rank.
Dragging the following into the Cube Browser:
- (Parent Company, Company...hierarchy), Rank - If the Rank is at the end of the table, Cube Browser doesn't show the Rank column at all, only the heading appears.
- Rank, (Parent Company, Company...hierarchy) - If the Rank is at the start of the table, Cube Browser displays correctly.
- (Parent Company, Company...hierarchy), Rank - If Rank is at the end of the table, Excel doesn't display the Rank of the Parent Company, but does display the
I'm, workin at the moment on a report for my company. I have a problem with searching in a parameter list which is based upon a parent child hierarchy. The users asked me for type in the first few characters to search the parameter faster (like in this
post ) , because it's a large hierarchy with about 1700 values. In a "normal" list ("linear" without a hierarchy) this feature is available.
So my question:
Isn't it possible to search in the parameter list in general if this is based upon a hierarchy?
Are there any possibilities or suggestions to get this feature?
Or is this the only way to do this:
Thanks in advance!
This is my present structure - I appreciate feedback
EmpChildId(FK to EmployeeId)
EmpParentId(FK to EmployeeId)
(If EmployeeId of Employee Table is connected on EmpChildId of EmployeeHierarchy table, that means we want all EmpParentId's
and vice versa
If EmployeeId of Employee Table is connected on EmpParentId of EmployeeHierarchy table, that means we want all EmpChildId's)
I need a list of all employees with Employeeid, name and description, so I created a EmployeeDimension - I can use order, filter(working good)
I needed a list of all parents with their employeeid, name and description for this employeeId so I created a ParentDimension and I did a join on EmpParentId=EmployeeId to get employeeId, name and description from Employee table, later on I filter on
EmpChildId to get parents for specific EmployeeId
Similary I created a ChildDimension also
Everything is working so far
Now the problem arised that I want to show all Employees with their name, description, id who are parents of x EmployeeId and child of y EmployeeId
I have three seperate dimensions
facts, EmployeeDimension, EmpParentsDimension, EmpChildrenDi
my parent/child dimension has the following structure:
structur is as follows:
- TOP Level
GridView Parent Child View with JQuery Effects I was just checked how to add some more cool effects to the GridView control using JQuery. In this post I will display parent-child data in the GridView control with some help of the wonderful JQuery library.Let's first populate the GridView control.
I'm using cssfriendly control adapter for menu. My asp.net menu control's datasource is a sitemap file I'm using which contains all the urls.
I have the following questions:
MSDN Magazine May 2004
MSDN Magazine July 2003