MDX NONEMPTY Function

The MDX NONEMPTY Function used to display records whose values are not Null. For example, When we are displaying the least Sales by Country-wise or Year wise, you may find NULLs as well. It won’t be very pleasant to see NULL values in High-level data. To remove the NULLs, we can use this MDX NONEMPTY function with … Read more

MDX NON EMPTY

The MDX NON EMPTY Keyword will write all the specified members whose values are not NULL. For example, When we are displaying Non-performing products, you may find a few products with NULLs. To remove the NULLs, we can use this MDX NON EMPTY Keyword. Please refer below table to understand the NON EMPTY output. Measure 1 Value … Read more

MDX COUSIN FUNCTION

In MDX, the Cousin function will write the same level member under the Ancestor specified in the second parameter. For example, If you know the value of the first Quarter in Calendar year 2014. And you want to find the sales of the last Quarter in the Calendar year 2015. Then you can use this MDX … Read more

MDX AVG Function

The MDX AVG Function is used to calculate the average of non-empty members present in the specified Set. It is similar to the SQL AVG Function. The MDX Average Function will ignore the NULL values while calculating the Average MDX AVG Function Syntax The basic syntax of the AVG Function in Multidimensional Expression is as shown … Read more

MDX ParallelPeriod Function

The MDX ParallelPeriod Function used to return member from a prior period in the same relative position as a specified member. For example, If you want to navigate to a particular member, then we can use this MDX ParallelPeriod function. MDX ParallelPeriod Function Syntax The basic syntax of the MDX ParallelPeriod Function in Multidimensional Expression … Read more

MDX PeriodsToDate Function

The MDX PeriodsToDate Function used to navigate between same level members. It returns the set of sibling members from First Sibling to the specified member. For example, If you want to list the members from one position to a particular member, then we can use this MDX PeriodsToDate function. MDX PeriodsToDate Function Syntax The basic … Read more

MDX ClosingPeriod Function

The MDX ClosingPeriod Function will return the Last Sibling member belongs to the specified member or at a specified level. MDX ClosingPeriod Function Syntax The basic syntax of the ClosingPeriod in Multidimensional Expression is as shown below: CLOSINGPERIOD (Level_Expression, Member_Expression) Member_Expression: Any Multidimensional Expression that returns valid Member. Level_Expression: Please specify the level you want … Read more

MDX OpeningPeriod Function

The MDX OpeningPeriod Function will return the First Sibling member belongs to the specified member or at a specified level. MDX OpeningPeriod Function Syntax The basic syntax of the OpeningPeriod in Multidimensional Expression is as shown below: OPENINGPERIOD (Level_Expression, Member_Expression) Member_Expression: Any Multidimensional Expression that returns valid Member. Level_Expression: Please specify the level you want … Read more

MDX LastPeriods Function

The MDX LastPeriods function used to navigate between same level members. It returns the set of members up to the specified position, including the given number itself. For example, If you want to list the members from one position to a particular member, then we can use this MDX LastPeriods function. TIP: If you know … Read more

MDX LastSibling Function

The MDX LastSibling function will return the Last Child member that belongs to the parent of a specified member. For example, If you know a single customer name and you want to find the Sales of the Last customer, then you can use this MDX Last Sibling function. MDX LastSibling Function Syntax The basic syntax … Read more