So if you put  there directly it all works fine. This is member unique name. This will generate the last 13 periods. Good for previous year. Note - Using lead ,Lag will return you only one member and Not 13 members. So they cant be used here.
|Published (Last):||18 September 2019|
|PDF File Size:||6.86 Mb|
|ePub File Size:||8.25 Mb|
|Price:||Free* [*Free Regsitration Required]|
So if you put  there directly it all works fine. This is member unique name. This will generate the last 13 periods. Good for previous year. Note - Using lead ,Lag will return you only one member and Not 13 members. So they cant be used here. Duplicates are retained only if the optional keyword all is supplied as the third argument.
How it can be used in report If you want to show data from May to Nov So once you do extract you are left with May. Here you could not have used lastperiod directly.
You will find it in the MDX help guide. But we hardly come across such scenario. IBM Defination. The result retains duplicates only when the optional keyword "all" is supplied as the third argument.
Here we give product line and it takes out product type for each product line and finds the top2 from product type.
How you can use it in report. You can use number of ideas to achieve the below. Its just one example of generate. Need to show selected year and year prior to that. There are few function that work only on set and not on member.
Remember that members in hierarchy make a set.
Current Member: Returns the Current member of a hierarchy. Ancestor; Returns the ancestor of the specified member Children: Returns the set of children of a specified member. Cognos MDx Functions Tuple — Refers to an intersection of one or members from one or more dimensions to define a specific measure value Set — A group of members or tuples. In the [Years] hierarchy, the members [Q1 ], [Q2 ], [Q1 ], [Q2 ] taken together is a set of members. As an example, a slicer of  will limit any data returned to
Supported MDX Syntax
Akizahn What you can do instead is reference the YTD as the default value in the prompt macro: In the case of a tuple, measures are considered part of a hierarchy and the same limitation applies. I am using running count in my query to calculate the number of occuerence of the the data item. Difficult problem, but not insurmountable. The problem happens when they want to truncate the Long Name of the KPI to show only the first 3 characters. As 4th week has 0 value for the measure, 3rd 4th week cumilative value is same and I am seeing parllel stright line from 3rd week to 4th week. Leave a Reply Cancel reply Your email address will not be published.
MDX Function Support