dbTalk Databases Forums  

Cube structure advice?

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


Discuss Cube structure advice? in the microsoft.public.sqlserver.olap forum.



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

Default Cube structure advice? - 05-24-2006 , 01:26 PM






I built a Total Revenue Cube but there are four different reports that I want
to pull against this cube. So I thought I should build 4 partitions to
reference the different filters for each report.

Any suggestions?

Reply With Quote
  #2  
Old   
AT
 
Posts: n/a

Default Re: Cube structure advice? - 05-24-2006 , 02:24 PM






4 reports doesn't correlate to 4 partitions.

4 partitions could correlate to 4 sources; or Sales_2005, Sales_2006,
Returns_2005, Returns_2006

then most likely; when you build a report; you will report off of all 4
partitions.

it's super-fast give it a try!


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.