Hello,

I would like to get quick status of OLAP database: size, what
cubes/partitions/measures are processed and what not. Currently in SQL
Server management studio I have an option on cube/measuregroup/partition to
create report, but that is very limited report just about that level and
does not give me more details about levels below. For example if I select
cube, I would like to see sizes/status for all measure groups in that cube,
etc. Is there an easy way to do this?

Thanks

Hello Vimas,

Nice to meet you again. I understand that you'd like to see the
sizes/status for all measure groups in a cube. Based on my research, this
feature is not avaialable in management studio. However, you could develop
your own code to enumberate the measuregroup/partitions to get this
information and get the aggration information as you want. Usually AMO can
do this job.

Partition.EstimatedSize Property
http://msdn2.microsoft.com/en-us/lib...vices.partitio
n.estimatedsize.aspx

If we use profiler to trace the events when we check the properties of
partitions, we could see the XMLA discover commands. For example:

<RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis">

<DatabaseID>Adventure Works DW</DatabaseID>

<CubeID>Adventure Works DW</CubeID>

<MeasureGroupID>Fact Internet Sales</MeasureGroupID>

<PartitionID>Customers_2003</PartitionID>

<ObjectExpansion>ExpandObject</ObjectExpansion>

</RestrictionList>

<PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis">

<Timeout>0</Timeout>

<SspropInitAppName>Microsoft SQL Server Management
Studio</SspropInitAppName>

<LocaleIdentifier>1033</LocaleIdentifier>

<ClientProcessID>3400</ClientProcessID>

</PropertyList>


You could run xmla directly in management studio to get the information of
the database so that you could get all informaiton you want in a xml
result. You shall be able to see estimated size for measuregroup in the
result as well.


<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>DISCOVER_XML_METADATA</RequestType>
<Restrictions>
<RestrictionList>
<ObjectExpansion>ExpandFull</ObjectExpansion>
</RestrictionList>
</Restrictions>
<Properties>
<PropertyList>
</PropertyList>
</Properties>
</Discover>

I understand it shall be convenient that we could get this information in
management studio and please rest assured that your feedback is routed to
the right channel. In the meantime, I also encourage you submit via the
link below

http://lab.msdn.microsoft.com/produc...k/default.aspx

If you have any comments or questions on the issue, 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/subscripti...ult.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.