Error browsing dimension

Question

Error browsing dimension

JanM-66

Ten Centuries

Points: 1247
More actions
December 5, 2007 at 4:54 am

#119345

Hi
When I want to browse my dimension with the dimension browser the error occurred(translated):
Query(4, 7) The Children-Function waits for an element expression for the 0-argument. A level expression has been used.
With the Cube browser I get values out, so what is wrong with the dimension?
Thanks for help.
Jan

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Dave Balsillie SSCertifiable Points: 5589 More actions · Answer 1

From the message, it appears you have a problem with your query, not your dimension. The message indicates that you're attempting to call the Children function against a Level. (Invalid in MDX.) Since you're using the dimension browser, the query should be well formed.

To help diagnose this problem, follow these steps.

a) Start SQL Profiler and run against MSAS. Trap the Query End event (and the error event).

b) Repeat your test and at the point of error, check the TextData. Post the contents back here for diagnosis.

JanM-66 Ten Centuries Points: 1247 More actions · Answer 2

The sql server profiler shows:

WITH MEMBER [Measures].[-DimBrowseLevelKey 0-] AS '[Dim Konto].[Konto].currentmember.properties("key0", TYPED)'

SELECT { [Measures].[-DimBrowseLevelKey 0-] } ON 0,

Head( [Dim Konto].[Konto].[Konto].Children, 1000) ON 1

FROM [$Dim Konto]

CELL PROPERTIES VALUE

PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" (<> removed to display the list)

Catalog>Syma_DWH</Catalog

ShowHiddenCubes>True</ShowHiddenCubes

SspropInitAppName>Microsoft Visual Studio</SspropInitAppName

Timeout>15</Timeout

LocaleIdentifier>2055</LocaleIdentifier

ClientProcessID>3560</ClientProcessID

Format>Multidimensional</Format

AxisFormat>TupleFormat</AxisFormat

Content>SchemaData</Content

MdxMissingMemberMode>Ignore</MdxMissingMemberMode

PropertyList

That query is made by VisualStudio, just from a simple table dim_account with the fields entry_no (key), account_no, name.

Dave Balsillie SSCertifiable Points: 5589 More actions · Answer 3

This query is being executed against the [Dim Konto] dimension (German for account). Ok, we're on our way.

I'm not exactly sure, but it looks like you may have defined the "AttributeAllMemberName" as "Konto". You also have an attribute name as "Konto". In MDX, the full qualification for dimension is:

{Dimension}.{Hierarchy}.{Level}.{member}

In this case, it sees [Dim Konto].[Konto].[Konto].Children and thinks you want {Dimension}.{Hierarchy}.{Level}.Children (which is invalid), when what you're really after is {Dimension}.{Hierarchy}.{all member}.Children

Change the "AttributeAllMemberName" (or leave it to the default). It's confusing anyways to have the same name, you probably should use a name like "Alles Konto" (sorry if the translation is wrong).

Let me know if this works.

JanM-66 Ten Centuries Points: 1247 More actions · Answer 4

Yes, that was the problem!

I'm not close to MDX yet, but I see this is essential for analysing.

Thanks a lot.