How to filter a Cubeset with a filter expression to calculate ytd Values

Question

I want to filter a simple cubeset to calculate Year-To-Date Values in a Excel Pivot Datamodell

There are ways I tried:

with a From - To expression - this works but depends on the existens of the start and end month in the Datamodell
with a filter expression - this works NOT for me, the filter is not appliend and the Cubevalue function returns no value.

The sample file with all data is avaiable here: https://my.hidrive.com/lnk/Y3ASXPQg

I'm looking for a way:

Gerd · Accepted Answer · 2017-12-22 12:42:41Z

0

I found the answer, the missing Keyword was "Member_Value".

If you change the above shown Formulas to

=CUBEMENGE("ThisWorkbookDataModel";"filter([Bereich].[Month].[All].Children,[Bereich].[Month].Member_Value < 6)";"Set filtered")

it works fine.

answered Dec 22, 2017 at 12:42

Gerd

1381 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1