PerlIsGood
Programmer
I'm drawing a blank here. The cube processes w/o error and I have several other dynamic sets in the cube, but this one set won't show up and I can't figure out why. I confirmed the MDX does return a set in SSMS.... Any ideas?
Code:
CREATE DYNAMIC SET CURRENTCUBE.[Last 7 Days]
AS {Tail(Exists([Calendar].[Date].Members,,"Bypass Events")).Item(0).Item(0).Lag(6):
Tail(Exists([Calendar].[Date].Members,,"Bypass Events")).Item(0).Item(0)}
, DISPLAY_FOLDER = 'Sets';