I’m trying to create a report where the time ranges are custom irregular time periods. I created a calculated member in the Time dimension for each of these periods and this seems to work fine. Each calculated member’s formula is something like:
‘Aug 29 2019’, ‘Sep 16 2019’)
In the example above, my report needs to look at the value of Test for the first date in each of those date ranges and include that into the following calculations. However, using
seems to only bring back the first date of the month for each date. I also seem to be unable to use [Time].CurrentMember.NextMember or PrevMember to find the date before or after. I get the error message
“Failed to execute query. Error message:
Internal error: member [Time].[Aug 29 2019] not found among its siblings”
Can you tell me what I’m doing incorrectly? Thanks for your help!