Filtering date type

Resolved
Simon asked on June 10, 2017

Hello,
 
if you try like this: uniqueName: "[Cas Validacije Dim].[Datum]", filter: {members: ["[Cas Validacije Dim].[Datum].[2017-04-24]"]} or even like this: uniqueName: "[Cas Validacije Dim].[Datum]", filter: {members: ["[Cas Validacije Dim].[Datum].&[2017-04-24]"]}, isn't work.
So how is correct?
 
Thank you,
regards,
Simon

1 answer

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster June 12, 2017

Hello Simon,
Thank you for your question. The correct filter member is "[Cas Validacije Dim].[Datum].&[20170424]". Please note that you can always check yourself by configuring the correct filter with UI pivot tools and saving the configuration to the report. In order to save the configuration to the report please press the save button on the toolbar or just use the save() API call (https://www.flexmonster.com/api/save/).
Please let us know if everything works fine for you.
Best regrds,
Dmytro.

Please login or Register to Submit Answer