Post New Web Links

Cube Calculation get Members of second last Level of a parent-child hierarchie

Posted By: Posted Date: April 14, 2011 Points: 0 Category :

Hi everyone,

I have a parent-child-hierarchie, where the different branches has different lengths; for example the fist one is:

Level1 - aLevel2 -aLevel3 -atotal

and the second:

Level1 - bLevel2-bLevel3 - bLevel4 - bLevel5 - btotal

Now I need the memebers of the second last Level, so in the examle: aLevel3 and bLevel5

How can I get them?

Thanks in advance for your help!

View Complete Post

More Related Resource Links

Parent child hierarchy & MDX to fetch particular level & all members below it along with measures us

I have a Sales Territory dimension that has employee and parent employee attribute on which parent child hierarchy is defined and it gives below hierarchy while browsing - - Mark Rolls --- Lumin Jacs ----- Larry Gomes ------- Messica Owens ------- Tom Ted ----------- Jackson Lopez ----- Matthew Ron --- Fred jacob - Jason Ron --- Jecy Pedro But beside this parent-child hierarchy I have other attributes like employee address, email and telephone. My facts related sales transaction is tagged to lowest level. For example here facts are available only for Jackson Lopez (being Field Executive). When use below query I get complete sales reporting hierarchy result with some measures like sales amount, sales volume. But while accesing other attributes like address or email, it's repeating address/email/telephone of jackson Lopes everywhere to whom fact record is linked, Actually I want address/email/telephone of each sales employee from that dimension within hierarchy. How do I get it? The query I used is: Here Parent Terr ID is parent child hierachy. SELECT ( Descendants( { [Dim SalesRegion].[Parent Terr ID].[Employee Level 01].&[538018] /* here Mark Rolls is 538018 */ }, 0,AFTER), NONEMPTY([Dim SalesRegion].[Emp Address].[Emp Address].Members), NONEMPTY([Dim SalesRegion].[Emp Email].[Emp Email].Members) ) ON ROWS , { ([Dim Date].[The Year].[The Year].[CY-2010], [Dim

SSAS - How to get other members from dimension that has Parent Child hierarchy?

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.

How to keep the hover for Parent menu and set the selected menu item css for child menu item?

Hi,

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:

Is there a way to keep the parent menu item hovered while hovering over the respective child menu items?
Is there a way to keep the child menu item selected? I am able to set the css for the parent menu, however I was wondering if the same is possible with the child items.

Please help!

Thanks,

Moneka

Data Points: Saving Parent-child Data in a Multitiered App Using ADO.NET

John Papa

MSDN Magazine May 2004

C++ Q&A: Parent and Child Window Captions, More MoveDlg

Paul DiLascia

MSDN Magazine July 2003

way of calling "javascript function of parent window from child window."

The article way of calling "javascript function of parent window from child window." was added by raja.s on Sunday, June 06, 2010.

Hi,Here i am going to explain how to call the javascript function of a parent window from the child window(pop-Up).Some may know before reading this post.Parent Java Script Function:script language="Javascript" type="text/javascript">

Two modalpopups as a parent-child

When I open two modalpopups, one over another, there is unexpected order.

After click on "Open Parent Panel", and click on "Open Child Panel",

Child Panel (newone) is under the Parent.

Uploaded with ImageShack.us

What should I do to get it in "normal order"?

The code is:

<asp:ScriptManager ID="A" runat="Server">

</asp:ScriptManager>

<asp:Button id="Z1" runat="server" Text="Open Parent Panel"

Display a nested child ListView on PostBack while using DataPager on parent ListView

Hello ASP.NET community,

I am having trouble finding how to solve the following issue :

I am using nested listviews to display Sales and Sales details.

The main ListView displays General Information about Sales and the child ListView displays the detailed information about one sale. the child listview is shown only when the user clicks on a link (see included code, DataBind is made on PageLoad) :

ASPX Markup Code :

<asp:listview id="lvSales" runat="server" onitemdatabound="lvSales_ItemDataBound">
	<layouttemplate>
		<table cellspacing="0" border="1" width="250" style="border-collapse:collapse;">
			<tr runat="server" id="headerRow">
				<th scope="col" style="width:30px;"></th>
				<th scope="col">SaleNumber</th>
			</tr>
			<tr id="itemPlaceHolder" runat="server" enableviewstate="true"/>
		</table>
	</layouttemplate>
	<itemtemplate>
		<tr id="row" runat="server">
			<td style="text-align:center;"><asp:button id="btnShowHideDetails" runat="server" oncommand=&qu

InfoPath and Access - two parent tables and one child table

Hi there,

I'm trying to link an InfoPath form to an Access database, I want to connect the InfoPath form to 3 tables in the Access database but InfoPath will only recognise parent-child relationships in a series (e.g. the "Company" table is the parent to the "Customer" table, which is again parent to the "Orders" table)

I need to have two parent tables and one child table, though (e.g. "Customer" is parent to "Orders", but "Inventory_Item" is also parent to "Orders"). Is there any way to establish this in InfoPath? I'm using Windows XP, InfoPath 2007 and Access 2007.

Cheers, Patrick

parent and child items

I have to create a aspx page where end users can create, edit and delete category and their subCategory from it.

Please suggest what is simple way to do above? using .Net

PS: a category can have zero or more subcategory and subcategory will not have any of its own subcategory, i.e. there are only two levels.

How to assign data from 1 DataReader into Parent/Child object??

Hi I have a parent & child table. Parent - User UserID UserName Status 1 Shallin A 2 How A Child - UserAccess UserID Country Default 1 US 0 1 UK 0 1 MY 1 2 SG 0 2 HK 0 2 MY 1 I also have parent & child object class. I would like to use 1 C# function and 1 SP to handle the retrieve portion but I have 1 problem. I'm not sure how to assign the value from Reader to the object. I do something like this but I only get 1 country which is the last country. if (dr.HasRows) { while (dr.Read()) { User objUser = new User(); objUser.UserID = dr["User_ID"].ToString().Trim(); objUser.UserName = dr["UserName"].ToString().Trim(); objUser.UserStatus = dr["Status"].ToString().Trim(); UserAccess objUserAccess = new UserAccess(); objUserAccess.Country = dr["Country"].ToString().Trim(); objUserAccess.Default = dr["Default"].ToString().Trim(); objUser.UserAccessCollection = new UserA

MDX Query - Get (Parent-Child) Dimension member regarding another Parent-Child Dimension, then, get

Hi there, I got the following MDX issue. My cube structure looks like that : DIMENSION CATEGORY (Parent-Child) --> (Many to many) FCTLESS_CategoryNode <-- DIMENSION NODE (Parent-Child) ___ DIMENSION NODE (Parent-Child) --> (Many to many) FCTLESS_NodeVariable <-- DIMENSION VARIABLE ___ DIMENSION VARIABLE <-- FACT (Supposed with only one value called VALUE) I'd like aggregate for N nodes linked to a specific category. For example, with the next content : DIMENSION CATEGORY - COUNTRY - SITE - BUILDING DIMENSION NODE US (Category Country) - Site US_A (Category Site) - Building US_A_A (Category Building) FR (Category Country) - Site FR_A (Category Site) - Building FR_A_A (Category Building) - Site FR_A (Category Site) - Building FR_A_B (Category Building) - Site FR_B (Category Site)

can this be done OOB (parent - child related lists)?

Hello, I'm brand new to sharepoint. Can I do the following out of the box, or will I need custom code? I need to create 2 related lists to form a master - detail relationship. 1. need to enter new parent and child list items on the same input form (like when adding a new parent item, also add new child items on the same screen) 2. need to have a view where when a parent item is selected the related child items display in a grid underneath can this be done out of the box? if yes, how? could someone provide an example or links to a 'how to'? thanks!

How to Bind a child control with properties of the parent control in Silverlight and WPF?

Dear Experts, I have a usercontrol in Silverlight and I want to enable the update button inside the usercontrol with property defined in the usercontrol. For the proof of concept sake I have defined the usercontrol xaml and the code behind in VB.NETBelow is the XAML and VB.NET Code. ----------------------------------------------------------------------- <UserControl x:Class="SLBAppAssementQuestions.SilverlightControl1" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="d" d:DesignHeight="300" d:DesignWidth="400"> <StackPanel> <CheckBox x:Name="chkBox1" Margin="10" Checked="chkBox1_Checked" >Checkbox1</CheckBox> <CheckBox x:Name="chkBox2" Margin="10" Checked="chkBox2_Checked">Checkbox1</CheckBox> <Button x:Name="BtnUpdate&q

Help about cascadin M2M with parent child hierachy custom rollup for one measure

Dear MSAS Experts, My name is Andre and i am writing my thesis about data quality which needs to be finished in about 3 weeks.:-( For my thesis i needed to develop a Schema which store data quality issues. This is a part of my schema which includes a cascading M2M: Facttabele: ErrorFact / ChecksFact / RULE ID / ... DT_RULE: Rule_ID / ..... RULE_ATTRIBUTE_BRIDGE: RULE_ID / Attribut_ID => M2M beetween Rule and Attribut(Rules can belong to multiple Attributes) DT_Attribut: Attribut_ID / .... Attribut_KPI_Bridge: Atribute_ID / KPI_ID => M2M beetween Attribute and KPI (Attributes can be used for multible KPI calc) DT_KPI: KPI_ID, KPI_Name, KPI_PARENT => Parent Child Since MSAS do not provide a Agrgatefunction I have a calculated Measure (lets say its called 'EC') which calculates the average of ErrorFact/ChecksFact. Now the problem I do have is that the 'EC' Measure should be aggregated within and only in the DT_KPI dimension that every child which belongs to the same parent should be muliplicated ('*') with each other till we reach the all member node. So if we have the following PC-Hierachy: -A --B ---C ---D --E The result of A would be (C*D)*E = A. B of course would show the result of C*D. On the other hand all the other facts should use the normal aggregation for this dimension. Also EC should be aggregated normal in all other dimensions. I tried usin

Parent-Child relationship on a Type 2 (SCD) Dimension

For a Type 2 slowly changing dimension (SCD) such as Employee with a Parent-Child relationship, how do you handle the explosion of new rows when a high ranking employee has an attribute change? ÃÂ It will require terminating the high ranking employee row and adding a new current row with a new surrogate key. Then every employee row below this employee will also have to be terminated and a new current row added with the new surrogate key of the parent. ÃÂ This will have to be performed 1 level at a time so the subordinate rows will have the new surrogate key of their immediate parent. ÃÂ For a large organization such as 20,000 employees, this will result in a dimension with hundreds of thousands rows in a relatively short time. ÃÂ Is there a better way to model this?


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All