Is there a chance to increase speed with use of FE caching ?

This is a discussion on Is there a chance to increase speed with use of FE caching ? within the sqlserver-olap forums in Data Warehousing category; ------------------------- How to compute: Average [Count] of each [AnyAttr] per each [Deciminute of day] in the period Jan-Feb 2008 ? ------------------------- dimension [Time] for example Fri 13.4.2008 13:20 attributes [Year] [Month] [Day] [Hour] [DeciMinute] [DayOfWeek] ... Fri [HourOfDay] ... 13 [DeciMinuteOfDay] ... 13:20 hierarchies [YMDH] [Year] [Month] [Day] [Hour] [DeciMinute] dimension Any attributes [AnyAttr] measures [Count] Following query is correct but too slow for large sets of AnyAttr.children. Is there a chance to improve it using FE caching ? And how? with set [TimeUnits] as [YMDH].[DeciMinute] member C as count([DeciMinuteOfDay] * [TimeUnits]) member [AvgCount] as [Count] / C set [Rowset] as { [...

Go Back   Database Forum > Data Warehousing > sqlserver-olap

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-25-2008, 05:06 AM
Default Is there a chance to increase speed with use of FE caching ?

-------------------------
How to compute:
Average [Count] of each [AnyAttr] per each [Deciminute of day] in the
period Jan-Feb 2008 ?
-------------------------

dimension [Time] for example Fri 13.4.2008 13:20
attributes
[Year]
[Month]
[Day]
[Hour]
[DeciMinute]
[DayOfWeek] ... Fri
[HourOfDay] ... 13
[DeciMinuteOfDay] ... 13:20
hierarchies
[YMDH]
[Year]
[Month]
[Day]
[Hour]
[DeciMinute]
dimension Any
attributes
[AnyAttr]

measures
[Count]

Following query is correct but too slow for large sets of AnyAttr.children.
Is there a chance to improve it using FE caching ? And how?

with
set [TimeUnits] as [YMDH].[DeciMinute]
member C as count([DeciMinuteOfDay] * [TimeUnits])
member [AvgCount] as [Count] / C
set [Rowset] as { [Any].[AnyAttr].children }
select
{ [DeciMinuteOfDay].children} * {[Count],[AvgCount]} on 0,
[Rowset] on 1
from
(select [YMDH].[2008].[Jan] : [YMDH].[2008].[Feb] on 0 from MYCUBE)

Thanks, Stanislav.
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 03:10 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.