An MDX Question?

OLAP Server User Guide

Configuring icCube

Running icCube

Migrating icCube

Security

Creating Schemas/Cubes

Working with icCube

Reporting Tools Integration

Embedding icCube

Plugins/Extensions

HOWTO

Web Reporting

Visualization Library

Tutorials

Demos

MDX Documentation

MDX Tutorial (Gentle Introduction)

MDX Functions Reference

MDX Language Reference

MDX OO Extensions

JAVA Integration

R Integration

Reference

icCube Client Library

XMLA Client Library

Ytd	(standard MDX)

Returns PeriodsToDate( Year_Level, Member ).

Parameters

Name	Type	Cardinality	Default value
	member-expression	zero-one

Return

set

Description

This function is strictly equivalent to: PeriodsToDate(Year_Level, Member).

If no member is defined, then [Time].currentMember is used.

Examples

Ytd(member)

Ytd()

period_names
Jan 2010-Feb 2010-Mar 2010-Apr 2010-May 2010-Jun 2010-Jul 2010-Aug 2010

Special Examples (errors, null, ...)

Ytd(member) - non time dimension

Ytd(NULL)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.