RE: Why does my virtual cube always get processed (OLAP 2000)
- From: petery@xxxxxxxxxxxxxxxxxxxx ("privatenews")
- Date: Mon, 28 Aug 2006 02:26:07 GMT
Hello Fergus,
To understand the issue better, I'd like to know how you process cubs in
parallel? Do you use Analysis Services Parallel Processing Utility? Any
details might be helpful.
If you don't use Analysis Services Parallel Processing Utility (PPU), you
may consider use it to process your cubes.
http://thesource.ofallevil.com/downloads/details.aspx?FamilyID=a2eef773-6df7
-4688-8211-e02cf13cbdb4&displaylang=en
http://download.microsoft.com/download/1/b/0/1b06ae62-932a-4fe2-ac1d-bc9d047
9fc88/ParallelProcess.exe
I have extracted the following informtion from readme file of PPU:
======================================
? Virtual cubes are now specifically handed by the utility. In previous
versions, virtual cubes looked like physical cubes and the underlying
physical cubes looked like partitions. In V3, the system not only displays
them properly, it now has a separate pass for them.
Requests are now handled in 3 passes: first, all dimensions are processed;
then physical cubes and partitions, then virtual cubes ? in the order
specified in the configuration file.
This option is available only with virtual cubes. In Food Mart, if you want
to try this new feature, create a configuration with the Warehouse and
Sales virtual cube. You will notice that when it select it, the form
changes the available options (it no longer displays the underlying
physical cubes as if they were partitions), and the request display on the
main form now clearly shows that this is a virtual cube. If you add another
item, such as a dimension and an partition, you will notice that there are
now three passes. Even though the virtual cube is the first item in the
request list, it is actually processed after dimensions, and then
cubes/partitions.
=======================================
Also, you may want to see "Changing Properties of an Analysis Services
Processing Task" in SQL Server Books on-line, and you might be able to use
workflow of the DTS to control the process of virtul cubes.
If you have any update, please feel free to let's know. We look forward to
your reply.
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.
.
- Prev by Date: Re: How to create a dimension sourced from three fact tables
- Next by Date: Re: How to create a dimension sourced from three fact tables
- Previous by thread: Dimension common across different AS databases -data warehouse
- Next by thread: RE: Why does my virtual cube always get processed (OLAP 2000)
- Index(es):
Relevant Pages
|
Loading
