Who is online?  0 guests and 1 members
Home  »  search results

Search Results: Descendants

14 results found
  • SSAS MDX function: DESCENDENTS
    Syntax: DESCENDANTS( «Member»[, «Level»[, «Desc_flags»]] ) DESCENDANTS( «Member»,«Distance»[, «Desc_flags»] ) According to MSDN , descendants MDX function returns the set of descendants of a member at a specified level or distance, optionally including or
    Author: sirfnet sirfnet     Date: 1/18/2011     Section: Blog
  • Using the Descendants Function
    The MDX function, Descendants, is a very versatile and commonly used function that returns the members at, below, or even above a specified level. The first argument of the descendants function is a member or set expression. The second argument can either
    Author: DustinRyan DustinRyan     Date: 2/22/2012     Section: Blog
    tags : Descendants
  • Need MDX for security to view peers data and one level up data under hi boss for different type of managers
    Hi, I have a query we have a dimension in one of our cube which has Hierarchy as Division-->Area-->District-->Territory. Now the security comes into picture when a particular level manager browses then that manager should see only data one level
    Author: Ankit02 Ankit02     Date: 2/26/2013     Section: Forum
  • Average question
    Alright, well you made me write some MDX to get this to work ;) but here ya go. WITH //Gets a Summation of the Orders in the Fiscal period MEMBER [Measures].[Sum] AS SUM([Date].[Fiscal].CHILDREN,[Measures].[Internet Order Count]) //Counts the days in the
    Author: DustinRyan DustinRyan     Date: 8/5/2011     Section: Forum
  • Optimizing Prior Year Calculation
    We have a unique prior year calculation in which we only want to compare where we are in the current time period to the parallel period. For example if we are in the fixcal week hierarchy and it is wednesday, we only want to compare the first up to wednes
    Author: zwag20 zwag20     Date: 12/11/2011     Section: Forum
  • MDX very slow looking for alternative syntax
    Hi Patrick, Not sure of the specifics of your user-defined Products hierarchy but you might be able to do something like this in your cube's MDX script. CREATE MEMBER CurrentCube.[Measures].[Level Specific Calculated Member] AS NULL; //Overwrite SKU level
    Author: CurrentMember CurrentMember     Date: 3/11/2010     Section: Forum
  • Finding Mesures for Specific Dates using MDX
    I'm assuming in your time dimension that you have specified if a day is a business day or not. I'm also assuming that you have identified the fiscal and calendar years in the dimension. If not, I don't think you're going to be able to identify the first b
    Author: DustinRyan DustinRyan     Date: 3/13/2012     Section: Forum
  • Performance Point Scorecard: display children of filter selection
    I have a scorecard that uses a filter to display values on a scorecard. It is a geographical hierarchy, so when the user selects 'North America', the scorecard shows one line with the North America aggregate. The customer has asked for an additional level
    Author: jmbaute jmbaute     Date: 11/15/2011     Section: Forum
  • Scope statement & ignoring non leaf data
    MY first blog post on BIDN :-) Well, let me start off with a brief introduction to the problem : My client, a large coal mining concern, has a warehouse concerned engineering availabilities - i.e. what the machines are doing at any given point. The fact t
    Author: MarkGStacey MarkGStacey     Date: 1/8/2010     Section: Blog
  • Showing an SSAS Hierarchy as Delimited String
    I recently encountered a requirement for a client to display a list of all the individual stores of a ragged hierarchy (the leaf members) on an SSRS report with a bunch of different measures. But they also wanted to be able to quickly see the the ancestor
    Author: DustinRyan DustinRyan     Date: 10/11/2011     Section: Blog
  • Designing SSRS Report using MDX Code + Subscriptions
    Hi Friends, I hope you can help me. I have finished designing an SSRS report for a client using MDX. THe user wanted the report which he was editing using Business Reporter (ProClarity). I am no MDX expert, so my dilemma is the user wants this report to g
    Author: distinguished-gentleman distinguished-gentleman     Date: 10/13/2010     Section: Forum
  • Designing SSRS Report using MDX Code + Subscriptions
    Hi Friends, I hope you can help me. I have finished designing an SSRS report for a client using MDX. THe user wanted the report which he was editing using Business Reporter (ProClarity). I am no MDX expert, so my dilemma is the user wants this report to g
    Author: distinguished-gentleman distinguished-gentleman     Date: 10/13/2010     Section: Forum
  • Hiding Salary from employees according to the company´s hierarchy
    The first thing you will have to do is change the table's structure. You will need to create a hierarchy, and could achieve that by adding an additional field "ManagerEmpID" (or something similar) which will contain the EmpID of the employee's direct mana
    Author: MartinSchoombee MartinSchoombee     Date: 8/12/2011     Section: Forum
  • Average question
    You'd create three measures. The first would be called "Order Count" and would have the expression: SUM([ Date ].[Fiscal].CHILDREN,[Measures].[Internet Order Count]) The second measure would be called "Day Count" and would have the expression: COUNT({DESC
    Author: DustinRyan DustinRyan     Date: 10/22/2012     Section: Forum
Page 1 of 1 (14 items)