.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

visualization of multiple parent hierarchies

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :ASP.Net

I have table like

HierarchyId     EmployeeId     ParentId


1                     1                      0

2                     2                      3

3                     3                      1

4                     3                      2

see, employee id 3 has two parents, 1 and 2. The same situation may arise for other employees also. How can I visualize this hierarchy in my webpage? what would be the best

View Complete Post

More Related Resource Links

Multiple Parent Child Hierarchies in SSAS 2008 R2


I'm trying to create a dimension containing financial accounts in SSAS 2008 R2 where individual accounts can belong to one or more hierarchies.  I also need to be able to specify a unary operator since a leaf level account may be subtracted from one parent but additive to another parent.  For example revenues and expenses may be grouped one way for statutory reporting and a completly different way for management reporting and further belong to some arbitraty groupings that users find necessary.

I can't seem to find a way to have a leaf level member in a dimension more than one time in a Parent child hierarchy, and I can't seem to find any way to include the unary operator in a hierarchy where I use attributes to define the hierarchy.

Are there any work arounds that anyone knows about?  What I found from the help file was that multiple parent child hierarchies which supported in SSAS 2000 are not supported in 2008.  However there is no suggestion for what to do.

Any insight would be greatly appreciated.


Bill Webster

Calculated measure that works across multiple hierarchies

Dear all,

I need to create a calculated measure for YTD that dynamically calculates based on the date hierarchy selected by the user (SSRS & Excel).

On the date dimension, I have 2 hierarchies "Year-Month-Day" and "Year-Week-Day", that both share the year and day attributes.

What's the best way to go about this?

Many thanks,


The first axis of the query should not have multiple hierarchies








[Calendar Date].[Calendar Hierarchy].[0-90]






Best design option for multiple parent / multiple child list?


I made 2 lists.  "User Groups" and "Resource Groups".  In User Groups, I setup a column to do a multi-select lookup to the Resource Groups lists title column.  Obviously as this gets built, groupings will form in the other direction as well... Is there a way to programatically do that, so I don't have to complete a multi-select colum in the Resource Groups list that does a lookup to the User Groups list to get info I logically already have.

I tried to do it with a workflow, but was only able to update 1 item so the multi-select concept was pointless. 

I want to have the multi-select information displayed regardless of which list your looking in.  If you look in a User Groups list item, you can see all the resources the users have access to... if you look at a Resource Group list item, you can see what User Groups have access to it (linked by multi-select lookup), and i'd like to only have to populate the lookup in 1 direction and build the reverse relationships on automatically.

Hope that makes sense.  You'd think you could auto import this info but I can't get Domain Local groups to show up, seems to be a limitation of the WSDL for connecting to AD (forget the correct term for that piece), so I'll add them manually..



How to add multiple reports in single parent pane with each report had its own pane and dropdown to


We had a report to create which should show multiple reports with each of them had there own pane and each of them had drop down to select the parameters to run this report. We had to create this report using SSRS, any ideas???



TreeView with parent to single child relation from multiple children c#



how to populate treeview  with a child node and with all its parent nodes





       -----a11 // if selected i want to draw treeview with its all parents






Ratio to Parent by Multiple Dimensions on both Row and Column Axes



I recently read "Percentage of Parent for all dimensions" thread ...To say the least, it was eye-opening...The amount of effort and detailed explanation that Tomislav Piasevoli put in was tremendous and helpful. I'm doing the same thing for our BI requirements, and I practically copied the entire code and see that it works for dimensions that are being identified on both Axes (Column / Row). However, the code is not a perfect solution for my situation.It seems that the calculation only works for any single Dimension on each Axis.  If I select more than one dimension onto the Colum / Row axes, the results came out incorrectly for the inner dimensions.

Note that: The possible dimensions that will be used for the "Ratio to Parent" are as follows:


how to create multiple dimensions on single parent column


How i cant create multiple dimensions on single parent column? 

This is the senario


Workflow fact table

Wf_id (int)






Department Dimension Table




Now if i create dimension from dimdept , it have only one department name column, how i can use this same lookup to represent the service and source department names? Same senario pops up in sales fact tables as well , like manage_id and salesman_id both looks up to same parent table "Emp_id"

Nested table 'link' which inherits its namespace cannot have multiple parent tables in different n


Does anyone know what I need to do to get past this error?

The error is "Nested table 'link' which inherits its namespace cannot have multiple parent tables in different namespaces."

I get the error on this line:


 Protected Sub lstOpens_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim ConnectStr As String = _

        Dim ctu As String = GetCTU()
        Dim ctp As String = GetCTP()
        'check if user has ct's
        If String.IsNullOrEmpty(ctu) Then
            Exit Sub
        End If
        If String.IsNullOrEmpty(ctp) Then
            Exit Sub
        End If

        'this returns an xml info for selected Campaign (email)

        Dim sUri As String = "https://api.constantcontact.com" & Me.lstOpens.SelectedValue.ToString()
        Dim sAPIKey As String = "/////"

        'setup httpWebReqeust to send the request
        Dim address As New Uri(sUri)
        Dim theRequest As HttpWebRequest = TryCast(WebRequest.Create(address), HttpWebRequest)
        theRequest.Credentials = New NetworkCredential((sAPIKey & "%" & ctu), ctp)


Multiple database support with Entity Framework

One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

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.

Binding the multiple drop down boxes in GridView using JQuery in ASP.NET

Here is the code for binding the multiple drop down boxes in GridView using JQuery in ASP.NET

Upload Multiple File using JQuery in asp.net

In this article I have explained how to upload multiple files using file upload control. I have used jQuery plugin for uploading multiple files.

I have also explained how to check for file type, file maximum size limit using jQuery & also using server side validation code.

Adding Multiple Columns and Rows in GridView without using a Database

This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

GridView Multiple Filter AJAX Control

This AJAX control enables the user to filter data within any column inside a GridView. The user can add multiple filters and can delete existing ones too.

Multiple Column Dropdownlist for the ASP.NET DataGrid

Based on my previous control "Multiple Column DropDownList for ASP.NET", I received many emails asking for the same control to be used in the DataGrid for web applications. Here we go.. This control can be used as the regular MS DropDownList in the DataGrid and also as a regular dropdownlist. It has all the properties, like DataTextField, DataValueField, DataSource, SelectedIndex etc. The download file contains the samples both in VB.NET and C#. In this sample, I have used the Northwind database of SQL Server.

ASP.NET Multiple Selection DropDownList with AJAX HoverMenuExtender

Recently, I was looking for a multiple selection dropdownlist control for my new project. After spending some time researching for it, I decided to put together all my finding in one web user control. This web user control consists of an ASP.NET AJAX HoverMenuExtender, JavaScript, StyleSheet and CheckBoxListExCtrl . The final product will work with or without a MasterPage and you can drag and drop more than one instances of the control on to the page.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend