Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MDX Dynamic Set not showing up in cube

Status
Not open for further replies.

PerlIsGood

Programmer
Jan 24, 2002
154
US
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';
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top