dbTalk Databases Forums  

Suppress totals for Time Levels

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Suppress totals for Time Levels in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
G Billins
 
Posts: n/a

Default Suppress totals for Time Levels - 04-08-2004 , 02:06 PM






Hello,

I have been using a Virtual time dimension based on Fiscal
Yr, and FiscalWK
I would like to exclude the automatic aggregation
done at the All and FiscalYr levels.

a) The All Level is greyed out which precludes that I
exclude it.
b) I do not wish to remove the Fiscal Yr level because it
affects the LastPeriods function nor make it not visible
c) I am calculating moving averages. Here is a sample MDX

Iif(
Count(LastPeriods(4,[Time].[FiscalYW].CurrentMember))<4,
null,
SUM(LastPeriods(4,[Time].[FiscalYW].CurrentMember ),
([Trend].&[No Trend]) )
/4

Thanks



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.