/content/package[@name='ZooConsolidated']/model[@name='model'] No Data Available Image Hourly Daily Year To Date Hourly Report No Data Available Image 9-12 12-3 3-6 Actual Attendance No Data Available Top 5 Attendance Access Codes No Data Available Top 3 Food Locations Revenue Top 5 Food Items Revenue Top 3 Food Locations Revenue Top 5 Food Items Revenue No Data Available No Data Available Top 3 Food Locations Revenue Top 5 Food Items Revenue Top Retail Locations Revenue Top 5 Retail Items Revenue Top Retail Locations Revenue Top 5 Retail Items Revenue No Data Available No Data Available Top Retail Locations Revenue Top 5 Retail Items Revenue Actual Attendance - No Data Available Top 5 attendance Access Codes No Data Available Top 3 Food Locations Revenue Top 5 Food Items Revenue Top 3 Food Locations Revenue Top 5 Food Items Revenue No Data Available No Data Available Top 3 Food Locations Revenue Top 5 Food Items Revenue Top Retail Locations Revenue Top 5 Retail Items Revenue Top Retail Locations Revenue Top 5 Retail Items Revenue No Data Available No Data Available Top Retail Locations Revenue Top 5 Retail Items Revenue Actual Attendance - No Data Available Top 5 attendance Access Codes No Data Available Top 3 Food Locations Revenue Top 5 Food Items Revenue Top 3 Food Locations Revenue Top 5 Food Items Revenue No Data Available No Data Available Top 3 Food Locations Revenue Top 5 Food Items Revenue Top Retail Locations Revenue Top 5 Retail Items Revenue Top Retail Locations Revenue Top 5 Retail Items Revenue No Data Available No Data Available Top Retail Locations Revenue Top 5 Retail Items Revenue Daily Report IN OH PA KYWV No Data Available IN No Data Available OH No Data Available No Data Available KY No Data Available Top 5 Attendance Cities - Indiana No Data Available No Data Available No Data Available IN No Data Available No Data Available No Data Available KY No Data Available Top 5 attendance Cities - Ohio No Data Available No Data Available No Data Available IN No Data Available No Data Available No Data Available KY No Data Available Top 5 attendance Cities - Pennsylvannia No Data Available No Data Available No Data Available IN No Data Available No Data Available No Data Available KY No Data Available Top 5 attendance Cities - West Kentucky No Data Available No Data Available No Data Available IN No Data Available No Data Available No Data Available KY No Data Available Top 5 attendance Cities - West Virgnia No Data Available No Data Available Top 10 Food Items No Data Available Top 10 Retail items No Data Available Yearly Report Attendance YTD vs PYTD Temperature vs Attendance Attendance by Access Codes Attendance YTD vs PYTD Temperature vs Attendance Attendance by Access Codes No Data Available No Data Available No Data Available Yearly Growth Attendance YTD vs PYTD Temperature vs Attendance Attendance by Access Codes As of : ReportDate () Hourly Reports () Time of Report: ReportDate () [timelines].[timeline].[timeline].[timeline1][timelines].[imageurl].[imageurl].[imageurl1][id1][timelines].[Measures].[id]id[timelines].[Measures]Measures[id1]is not null[daytimeblock].[daytimeblock].[daytimeblock].[daytimeblock1][daytimeblock].[imageurl].[imageurl].[imageurl1]'../samples/images/zoo/' + substring([imageurl],35,20)[id1][daytimeblock].[Measures].[id]id[daytimeblock].[Measures]Measures[id1] is not null[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[KY]KY[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]State[dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]MeasurestopCount (children([KY]), 5, tuple([Actual Attendance]))[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Dayif ([Actual Attendance] is null) then (0) else ([Actual Attendance])[Current Day][dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]Measures[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[OH]OH[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]StatetopCount (children([OH]), 5, tuple([Actual Attendance]))[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Dayif ([Actual Attendance] is null) then (0) else ([Actual Attendance])[Current Day][dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[PA]PA[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]State[dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]MeasurestopCount (children([PA]), 5, tuple([Actual Attendance]))[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Dayif ([Actual Attendance] is null) then (0) else ([Actual Attendance])[Current Day][dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[IN]IN[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]State[dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]MeasurestopCount (children([IN]), 5, tuple([Actual Attendance]))[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Dayif ([Actual Attendance] is null) then (0) else ([Actual Attendance])[Current Day][dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[WV]WV[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]State[dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]MeasurestopCount (children([WV]), 5, tuple([Actual Attendance]))[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Dayif ([Actual Attendance] is null) then (0) else ([Actual Attendance])[Current Day][dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]MeasurestopCount (children([KY]), 5, tuple([Actual Attendance]))[dbWarehouse_Attendance_Cube].[State].[State].[State - Short Name]State - Short Name[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]State[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[By State]By State[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]State[Current Day][KY][dbWarehouse - Revenue - F&R Cube].[Location].[Location]->:[PC].[@MEMBER].[Food]Food[dbWarehouse - Revenue - F&R Cube].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Location].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Food]), 5, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[Current Day][dbWarehouse - Revenue - F&R Cube].[Location].[Location]->:[PC].[@MEMBER].[Food]Food[dbWarehouse - Revenue - F&R Cube].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Location].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Food]), 10, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[Current Day][dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Zoo Shop]), children([4D Shop]),children([Family Shop]),5, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Location].[Location]->:[PC].[@MEMBER].[Retail]Retail[dbWarehouse - Revenue - F&R Cube].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Location].[Location]Location[Current Day] [dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]Measures[dbWarehouse_Attendance_Cube].[Client Type].[Client Type]->:[PC].[@MEMBER].[Member]Member[dbWarehouse_Attendance_Cube].[Client Type]Client Type[dbWarehouse_Attendance_Cube].[Client Type].[Client Type]Client Type[dbWarehouse_Attendance_Cube].[Client Type].[Client Type]->:[PC].[@MEMBER].[Non-Member]Non-Member[dbWarehouse_Attendance_Cube].[Client Type]Client Type[dbWarehouse_Attendance_Cube].[Client Type].[Client Type]Client Type[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[9am to 10am]9am to 10am[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[10am to 11am]10am to 11am[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[11am to 12pm]11am to 12pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[3pm to 4pm]3pm to 4pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[4pm to 5pm]4pm to 5pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[5pm to 6pm]5pm to 6pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Day [Current Day] [dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]Hour of Day1[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]Measures[dbWarehouse_Attendance_Cube].[Client Type].[Client Type]->:[PC].[@MEMBER].[Member]Member[dbWarehouse_Attendance_Cube].[Client Type]Client Type[dbWarehouse_Attendance_Cube].[Client Type].[Client Type]Client Type[dbWarehouse_Attendance_Cube].[Client Type].[Client Type]->:[PC].[@MEMBER].[Non-Member]Non-Member[dbWarehouse_Attendance_Cube].[Client Type]Client Type[dbWarehouse_Attendance_Cube].[Client Type].[Client Type]Client Type[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[12pm to 1pm]12pm to 1pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[1pm to 2pm]1pm to 2pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[2pm to 3pm]2pm to 3pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Day [Current Day] [dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]Hour of Day1[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]Measures[dbWarehouse_Attendance_Cube].[Client Type].[Client Type]->:[PC].[@MEMBER].[Member]Member[dbWarehouse_Attendance_Cube].[Client Type]Client Type[dbWarehouse_Attendance_Cube].[Client Type].[Client Type]Client Type[dbWarehouse_Attendance_Cube].[Client Type].[Client Type]->:[PC].[@MEMBER].[Non-Member]Non-Member[dbWarehouse_Attendance_Cube].[Client Type]Client Type[dbWarehouse_Attendance_Cube].[Client Type].[Client Type]Client Type[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[3pm to 4pm]3pm to 4pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[4pm to 5pm]4pm to 5pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[5pm to 6pm]5pm to 6pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Day [Current Day] [dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]Measures[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]->:[PC].[@MEMBER].[By Access Code Level2 Desc]By Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc]Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]Access Code Level2 Desctopcount(children([By Access Code Level2 Desc]), 3, tuple([Actual Attendance]))[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[9am to 10am]9am to 10am[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[10am to 11am]10am to 11am[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[11am to 12pm]11am to 12pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Day [Current Day] [dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]Measures[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]->:[PC].[@MEMBER].[By Access Code Level2 Desc]By Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc]Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]Access Code Level2 Desctopcount(children([By Access Code Level2 Desc]), 5, tuple([Actual Attendance]))[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[9am to 10am]9am to 10am[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[10am to 11am]10am to 11am[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[11am to 12pm]11am to 12pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Day [Current Day] [dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]Measures[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]->:[PC].[@MEMBER].[By Access Code Level2 Desc]By Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc]Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]Access Code Level2 Desctopcount(children([By Access Code Level2 Desc]), 5, tuple([Actual Attendance]))[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[12pm to 1pm]12pm to 1pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[1pm to 2pm]1pm to 2pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[2pm to 3pm]2pm to 3pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Day [Current Day] [dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]Measures[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]->:[PC].[@MEMBER].[By Access Code Level2 Desc]By Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc]Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]Access Code Level2 Desctopcount(children([By Access Code Level2 Desc]), 5, tuple([Actual Attendance]))[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[3pm to 4pm]3pm to 4pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[4pm to 5pm]4pm to 5pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[5pm to 6pm]5pm to 6pm[dbWarehouse_Attendance_Cube].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Day [Current Day][dbWarehouse - Revenue - F&R Cube].[Location].[Location]->:[PC].[@MEMBER].[Food]Food[dbWarehouse - Revenue - F&R Cube].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Location].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Food]), 3, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[9am to 10am]9am to 10am[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[10am to 11am]10am to 11am[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[11am to 12pm]11am to 12pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[Food][Current Day]set([9am to 10am],[10am to 11am],[11am to 12pm])[dbWarehouse - Revenue - F&R Cube].[Location].[Location]->:[PC].[@MEMBER].[Food]Food[dbWarehouse - Revenue - F&R Cube].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Location].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Product Name]), 5, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name].[Product Name]->:[PC].[@MEMBER].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[9am to 10am]9am to 10am[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[10am to 11am]10am to 11am[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[11am to 12pm]11am to 12pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[Food][Current Day]set([9am to 10am],[10am to 11am],[11am to 12pm])[dbWarehouse - Revenue - F&R Cube].[Location].[Location]->:[PC].[@MEMBER].[Food]Food[dbWarehouse - Revenue - F&R Cube].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Location].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Food]), 3, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[12pm to 1pm]12pm to 1pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[1pm to 2pm]1pm to 2pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[2pm to 3pm]2pm to 3pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[Food][Current Day]set([12pm to 1pm],[1pm to 2pm],[2pm to 3pm])[dbWarehouse - Revenue - F&R Cube].[Location].[Location]->:[PC].[@MEMBER].[Food]Food[dbWarehouse - Revenue - F&R Cube].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Location].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Food]), 3, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[3pm to 4pm]3pm to 4pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[4pm to 5pm]4pm to 5pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[5pm to 6pm]5pm to 6pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[Food][Current Day]set([3pm to 4pm],[4pm to 5pm],[5pm to 6pm])[dbWarehouse - Revenue - F&R Cube].[Location].[Location]->:[PC].[@MEMBER].[Food]Food[dbWarehouse - Revenue - F&R Cube].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Location].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Product Name]), 5, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name].[Product Name]->:[PC].[@MEMBER].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[3pm to 4pm]3pm to 4pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[4pm to 5pm]4pm to 5pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[5pm to 6pm]5pm to 6pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[Food][Current Day]set([3pm to 4pm],[4pm to 5pm],[5pm to 6pm])[dbWarehouse - Revenue - F&R Cube].[Location].[Location]->:[PC].[@MEMBER].[Food]Food[dbWarehouse - Revenue - F&R Cube].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Location].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Product Name]), 10, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name].[Product Name]->:[PC].[@MEMBER].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[Food][Current Day][dbWarehouse - Revenue - F&R Cube].[Location].[Location]->:[PC].[@MEMBER].[Food]Food[dbWarehouse - Revenue - F&R Cube].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Location].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Product Name]), 5, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name].[Product Name]->:[PC].[@MEMBER].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[12pm to 1pm]12pm to 1pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[1pm to 2pm]1pm to 2pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[2pm to 3pm]2pm to 3pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[Food][Current Day]set([12pm to 1pm],[1pm to 2pm],[2pm to 3pm])[dbWarehouse - Revenue - F&R Cube].[Location].[Location]->:[PC].[@MEMBER].[Retail]Retail[dbWarehouse - Revenue - F&R Cube].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Location].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Retail]), 3, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[9am to 10am]9am to 10am[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[10am to 11am]10am to 11am[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[11am to 12pm]11am to 12pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[Retail][Current Day]set([9am to 10am],[10am to 11am],[11am to 12pm])[dbWarehouse - Revenue - F&R Cube].[Location].[Location]->:[PC].[@MEMBER].[Retail]Retail[dbWarehouse - Revenue - F&R Cube].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Location].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Product Name]), 5, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name].[Product Name]->:[PC].[@MEMBER].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[9am to 10am]9am to 10am[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[10am to 11am]10am to 11am[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[11am to 12pm]11am to 12pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[Retail][Current Day]set([9am to 10am],[10am to 11am],[11am to 12pm])[dbWarehouse - Revenue - F&R Cube].[Location].[Location]->:[PC].[@MEMBER].[Retail]Retail[dbWarehouse - Revenue - F&R Cube].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Location].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Product Name]), 5, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name].[Product Name]->:[PC].[@MEMBER].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[12pm to 1pm]12pm to 1pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[1pm to 2pm]1pm to 2pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[2pm to 3pm]2pm to 3pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[Retail][Current Day]set([12pm to 1pm],[1pm to 2pm],[2pm to 3pm])[dbWarehouse - Revenue - F&R Cube].[Location].[Location]->:[PC].[@MEMBER].[Retail]Retail[dbWarehouse - Revenue - F&R Cube].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Location].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Product Name]), 10, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name].[Product Name]->:[PC].[@MEMBER].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[Retail][Current Day][dbWarehouse - Revenue - F&R Cube].[Location].[Location]->:[PC].[@MEMBER].[Retail]Retail[dbWarehouse - Revenue - F&R Cube].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Location].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Retail]), 3, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[3pm to 4pm]3pm to 4pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[4pm to 5pm]4pm to 5pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[5pm to 6pm]5pm to 6pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[Retail][Current Day]set([3pm to 4pm],[4pm to 5pm],[5pm to 6pm])[dbWarehouse - Revenue - F&R Cube].[Location].[Location]->:[PC].[@MEMBER].[Retail]Retail[dbWarehouse - Revenue - F&R Cube].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Location].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Retail]), 3, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[12pm to 1pm]12pm to 1pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[1pm to 2pm]1pm to 2pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[2pm to 3pm]2pm to 3pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[Retail][Current Day]set([12pm to 1pm],[1pm to 2pm],[2pm to 3pm])[dbWarehouse - Revenue - F&R Cube].[Location].[Location]->:[PC].[@MEMBER].[Retail]Retail[dbWarehouse - Revenue - F&R Cube].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Location].[Location]Location[dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Product Name]), 5, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name].[Product Name]->:[PC].[@MEMBER].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[3pm to 4pm]3pm to 4pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[4pm to 5pm]4pm to 5pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day].[Hour of Day1]->:[PC].[@MEMBER].[5pm to 6pm]5pm to 6pm[dbWarehouse - Revenue - F&R Cube].[Hour of Day]Hour of Day[dbWarehouse - Revenue - F&R Cube].[Hour of Day].[Hour of Day]Hour of Day[Retail][Current Day]set([3pm to 4pm],[4pm to 5pm],[5pm to 6pm])[dbWarehouse - Revenue - F&R Cube].[Measures].[Revenue Amount]Revenue Amount[dbWarehouse - Revenue - F&R Cube].[Measures]Measurestopcount(children([Product Name]), 10, tuple([Revenue Amount]))[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name].[Product Name]->:[PC].[@MEMBER].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Product Name].[Product Name]Product Name[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse - Revenue - F&R Cube].[Time]Time[dbWarehouse - Revenue - F&R Cube].[Time].[Current Day]Current Day[Retail][Current Day][dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]Measures[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[KY]KY[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]State[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Dayif ([Actual Attendance] is null) then (0) else ([Actual Attendance])[KY][Current Day][dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]Measures[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[OH]OH[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]State[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Dayif ([Actual Attendance] is null) then (0) else ([Actual Attendance])[OH][Current Day][dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]Measures[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[PA]PA[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]Stateif ([Actual Attendance] is null) then (0) else ([Actual Attendance])[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Day[PA][Current Day][dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]Measures[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[IN]IN[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]State[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Dayif ([Actual Attendance] is null) then (0) else ([Actual Attendance])[IN][Current Day][dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]Measures[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[WV]WV[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]State[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Dayif ([Actual Attendance] is null) then (0) else ([Actual Attendance])[WV][Current Day][dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]->:[PC].[@MEMBER].[By Access Code Level2 Desc]By Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc]Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]Measureschildren([By Access Code Level2 Desc])[dbWarehouse_Attendance_Cube].[Time].[Prior YTD].[Prior YTD]->:[PC].[@MEMBER].[Prior YTD]Prior YTD[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Prior YTD]Prior YTD[dbWarehouse_Attendance_Cube].[Time].[YTD].[YTD]->:[PC].[@MEMBER].[YTD]YTD[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[YTD]YTD[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Prior YTD]Prior YTD([YTD1] - [Prior YTD1]) / abs([Prior YTD1])[dbWarehouse_Attendance_Cube].[Time].[YTD].[Quarter]Quarter[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[YTD]YTD[dbWarehouse_Attendance_Cube].[Time].[Prior YTD].[Quarter]Quarter[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Prior YTD]Prior YTD[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Prior YTD]Prior YTD[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[YTD]YTD[dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]Measures[dbWarehouse_Attendance_Cube].[Time].[Prior YTD].[Prior YTD]->:[PC].[@MEMBER].[Prior YTD]Prior YTD[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Prior YTD]Prior YTD[dbWarehouse_Attendance_Cube].[Time].[YTD].[YTD]->:[PC].[@MEMBER].[YTD]YTD[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[YTD]YTD[dbWarehouse_Attendance_Cube].[Month].[Month].[Month1]Month1[dbWarehouse_Attendance_Cube].[Month]Month[dbWarehouse_Attendance_Cube].[Month].[Month]Month[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[OH]OH[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]State[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[WV]WV[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]State[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[IN]IN[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]State[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[PA]PA[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]State[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[KY]KY[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]State[dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]Measures[dbWarehouse_Attendance_Cube].[Time].[Prior YTD].[Prior YTD]->:[PC].[@MEMBER].[Prior YTD]Prior YTD[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Prior YTD]Prior YTD[dbWarehouse_Attendance_Cube].[Time].[YTD].[YTD]->:[PC].[@MEMBER].[YTD]YTD[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[YTD]YTD[dbWarehouse_Attendance_Cube].[Avg Temperature Range].[Avg Temperature Range].[Avg Temperature Range1]Avg Temperature Range1[dbWarehouse_Attendance_Cube].[Avg Temperature Range]Avg Temperature Range[dbWarehouse_Attendance_Cube].[Avg Temperature Range].[Avg Temperature Range]Avg Temperature Range[dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]MeasurestopCount (children([By Access Code Level2 Desc]), 5, tuple([Actual Attendance]))topCount (children([OH]), 5, tuple([Actual Attendance]))[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]->:[PC].[@MEMBER].[By Access Code Level2 Desc]By Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc]Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[OH]OH[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]Stateif ([Actual Attendance] is null) then (0) else ([Actual Attendance])[Current Day][dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]MeasurestopCount (children([By Access Code Level2 Desc]), 5, tuple([Actual Attendance]))topCount (children([KY]), 5, tuple([Actual Attendance]))[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]->:[PC].[@MEMBER].[By Access Code Level2 Desc]By Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc]Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[KY]KY[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]Stateif ([Actual Attendance] is null) then (0) else ([Actual Attendance])[Current Day][dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]MeasurestopCount (children([By Access Code Level2 Desc]), 5, tuple([Actual Attendance]))topCount (children([PA]), 5, tuple([Actual Attendance]))[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]->:[PC].[@MEMBER].[By Access Code Level2 Desc]By Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc]Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[PA]PA[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]Stateif ([Actual Attendance] is null) then (0) else ([Actual Attendance])[Current Day][dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]MeasurestopCount (children([By Access Code Level2 Desc]), 5, tuple([Actual Attendance]))topCount (children([IN]), 5, tuple([Actual Attendance]))[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]->:[PC].[@MEMBER].[By Access Code Level2 Desc]By Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc]Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[IN]IN[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]Stateif ([Actual Attendance] is null) then (0) else ([Actual Attendance])[Current Day][dbWarehouse_Attendance_Cube].[Measures].[Actual Attendance]Actual Attendance[dbWarehouse_Attendance_Cube].[Measures]MeasurestopCount (children([By Access Code Level2 Desc]), 5, tuple([Actual Attendance]))topCount (children([WV]), 5, tuple([Actual Attendance]))[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]->:[PC].[@MEMBER].[By Access Code Level2 Desc]By Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc]Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Access Code Level2 Desc].[Access Code Level2 Desc]Access Code Level2 Desc[dbWarehouse_Attendance_Cube].[Time].[Current Day].[Current Day]->:[PC].[@MEMBER].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[Time]Time[dbWarehouse_Attendance_Cube].[Time].[Current Day]Current Day[dbWarehouse_Attendance_Cube].[State].[State]->:[PC].[@MEMBER].[WV]WV[dbWarehouse_Attendance_Cube].[State]State[dbWarehouse_Attendance_Cube].[State].[State]Stateif ([Actual Attendance] is null) then (0) else ([Actual Attendance])[Current Day]Hourly9-12OHFood RevenueTop 3 Food ItemsTop 3 Access CodesTop 3 Food Locations RevenueTop Retail Locations RevenueAttendance YTD vs PYTDCincinnati Zoo_Final