Re: Combining Two Cubes with Different Time Periods
- From: Jason <jason2004@xxxxxxxxxxxxx>
- Date: Thu, 5 Jul 2007 23:48:01 -0700
Hello Peter, thanks for the post.
The BOL SSAS tutorial as well as Vidals's post (see post
http://groups.google.com/group/microsoft.public.sqlserver.olap/browse_thread/thread/3d5ba894b2abada0/2a79c4f9f9e15266)
say that you can join different two fact tables on different levels of
granularity. It's an interesting idea, but I haven't tried it yet.
Assuming this is correct, I should be able to combine the two cubes and
share the same Time dimension. However, the issue I am stuggling with is the
fact that the Time period for the Forecast cube is in the future, while my
Order cube is in the past. Joining the dimensions/cubes together may yield
and Inner join (which would exclude the forecast).
Are you suggesting that I summarize the Order cube to the Month level, and
then Union the Order and Forecast tables in SQL Server? I thought about this
approach, but was wondering if there was a solution in SSAS 2005.
My original thought was to create Parent-Child dimension for every
dimensions, but I'm afraid of the performance hit. My fact tables are over
100M rows each.
Your thoughts are much appreciated.
Jason
""Peter YangMSFT]"" wrote:
Hello Jason,.
I think the this issue might be caused by that forecast and Order fact
tables are linked to different levels time dimension tables. The leaf level
of forecast data is at month level while Order data is at day level.
You may want to create a named query or create another table to aggregate
the Order fact table to month level and use the same timekey in this fact
table or named query. At this point, you could create cube based on these 2
fact tables, and they shall be able to join properly. The time dimesion
only needs to have Year > Qtr > Month levels under the situation.
If you have any comments, please feel free to let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
- Follow-Ups:
- Re: Combining Two Cubes with Different Time Periods
- From: "Peter YangMSFT]"
- Re: Combining Two Cubes with Different Time Periods
- References:
- Re: Combining Two Cubes with Different Time Periods
- From: Will Alber
- Re: Combining Two Cubes with Different Time Periods
- From: "Peter YangMSFT]"
- Re: Combining Two Cubes with Different Time Periods
- Prev by Date: Re: Combining Two Cubes with Different Time Periods
- Next by Date: Re: Analysis Server Process Error: Line 3311 in function PFFileStore
- Previous by thread: Re: Combining Two Cubes with Different Time Periods
- Next by thread: Re: Combining Two Cubes with Different Time Periods
- Index(es):
Relevant Pages
|
