There is an apparent bug with the Dimension Usage screen in the Cube
editor for AS2005. If I enter anything in the Description property for
a dimension used in the cube, when I attempt to deploy the cube I get
the following error:

The Description element at line 1748, column 25 (namespace
http://schemas.microsoft.com/analysi...es/2003/engine) cannot
appear under
Envelope/Body/Execute/Command/Batch/Alter/ObjectDefinition/Cube/Dimensions/Dimension

The only way to clear the error seems to be to edit the code and remove
the <Description> element. Has anyone else seen this behaviour?

Is there a workaround? I want to populate the Description property,
because I want to use the metadata to build a web application that
provides documentation of the cube structures for business users.

I am using the developer edition with SP1 and hot fix build 2153.

Hi,

I have the same bug and have asked the MS PSS.
They are thinking it about.

Vladimir Chtepa


"Graham Binner" <graham.binner (AT) aleagroup (DOT) com> schrieb im Newsbeitrag
news:1151573475.373948.112210 (AT) d56g2000cwd (DOT) googlegroups.com...

With a bit of reading between the lines, BOL defines the elements that
can appear under .../Cube/Dimensions/Dimension as:

<CubeDimension>
<ID>...</ID>
<Name>...</Name>
<Translations>...</Translations>
<DimensionID>...</DimensionID>
<Visible>...</Visible>
<AllMemberAggregationUsage>...</AllMemberAggregationUsage>
<HierarchyUniqueNameStyle>...</HierarchyUniqueNameStyle>
<MemberUniqueNameStyle>...</MemberUniqueNameStyle>
<Attributes>...</Attributes>
<Hierarchies>...</Hierarchies>
<Annotations>...</Annotation>
</CubeDimension>

see: http://msdn2.microsoft.com/en-us/library/ms126687.aspx

Is there a reason you are not setting the description from within the
actual dimension itself?

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <#fEUIT2mGHA.1208 (AT) TK2MSFTNGP03 (DOT) phx.gbl>, vc.nospam@diacom-
systemhaus.nospam.de says...

Thanks for the information.

I may well end up relying on the description property in the actual
dimension. My intention was to use the description property on the
Dimension to capture general information about the purpose of the
dimension, but to use the description property in the Dimension Usage
window to capture any information specific to the usage of the
dimension within the cube (for example with role playing dimensions).


Darren Gosbell wrote:

Hi Darren,

I need to set differing description for the role playing dimensions,
otherwise I can't explain business users, what is difference between them.
For example: "shipping date" and "delivery date". Nobody will be happy from
the description of the original "time" dimension in this place.

Thanks in advance,
Vladimir Chtepa

p.s.
There are many thing in MSDN2, espessially related to SSAS, from
MDSCHEMA_... documentation till AMO help that are very spacy and can't serve
as proven truth.


"Darren Gosbell" <jam (AT) newsgroups (DOT) nospam> schrieb im Newsbeitrag
news:MPG.1f0e79e7909ac36398995c (AT) news (DOT) microsoft.com...

Hi Darren,

If you mean, that CubeDimension couldn't has description by design, how
could you explain, that AMO exposes Description as get/set property in
CubeDimension class?
Why BI studio allows developer set it manually?
I don't belive that both AMO and BI Studio Developers have implemented some
additional features, that conflict with engine.

Thanks in advance,
Vladimir Chtepa

"Darren Gosbell" <jam (AT) newsgroups (DOT) nospam> schrieb im Newsbeitrag
news:MPG.1f0e79e7909ac36398995c (AT) news (DOT) microsoft.com...

Vladimir,

I did not say that CubeDimension does not have a description by design.
I just pointed out that BOL does not have it listed in the XMLA.

I am guessing that the documentation in BOL may have come from what ever
internal XSD is being used to validate the XMLA, hence the error. And I
agree that BOL is quite sparse in some places and even completely wrong
in others (if I find any of these I use the "send feedback" link and
they do end up getting fixed)

AMO and BI Studio ultimately end up sending XMLA commands to the server
and whether you try to set the description from BI Studio, AMO or XMLA
directly you always get an error like:

-------------------
The Description element at line 1280, column 31 (namespace
http://schemas.microsoft.com/analysi...es/2003/engine) cannot appear
under
Envelope/Body/Execute/Command/Alter/ObjectDefinition/Cube/Dimensions/Dim
ension.
------------------

I agree that role playing dimensions is an excellent reason to have a
separate description attached to the CubeDimension object. I would guess
that this property probably does exist in the engine, there is just no
way of setting it as the xmla is being rejected as invalid.

I think your only hope in the short term is if you can get some help
from PSS as I can't see a way of setting this property in the current
release of the product.

Good Luck

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <u9u2TK5mGHA.2252 (AT) TK2MSFTNGP04 (DOT) phx.gbl>, vc.nospam@diacom-
systemhaus.nospam.de says...