How to set one single level directly as a hierarchy (AttributeHierarchy Request)

[xiaobao520123]

Before moving to Mondrian, we're using SSAS to do multidimensional data modeling.
SSAS natively supports AttributeHierarchy, which means by default a single column can directly serve as a hierarchy without we specifically design or create one.

We use Excel as the front-end, and we present the data as a PivotTable.
Now with Mondrian, according to its logical model, I have to create a dimension/hierarchy/level schema to present data and do filtering/measurement.

For Mondrian, is there any feature or configuration that can resemble SSAS's AttributeHierarchy?.
It seems Mondrian treats every hierarchy as a User-Define Hierarchy. We want a single column to be created as a hierarchy by default.

[Kuaffu]

In Mondrian 4.x, there was a feature that allowed creating a default hierarchy for a single column using the hasHierarchy attribute in the tag. Setting hasHierarchy='true' would generate a default hierarchy for the specified column.
Example:
<Dimension name='Time' table='my_time_by_day' type='TIME' key='Time Id'> <Attributes> <Attribute name='Time Id' keyColumn='time_id' hasHierarchy='false'/> <Attribute name='Year' keyColumn='the_year' levelType='TimeYears' hasHierarchy='true'/> <Attribute name='Quarter' levelType='TimeQuarters' keyColumn='quarter' hasHierarchy='true'/> <Attribute name='Month' levelType='TimeMonths' keyColumn='month_of_year' hasHierarchy='true'/> </Attributes> </Dimension>
Unfortunately, the Mondrian team abandoned the 4.x branch and did not retain compatibility with its features in subsequent releases. As of now, Mondrian does not seem to support a configuration equivalent to SSAS's AttributeHierarchy.

[xiaobao520123]

@Kuaffu could you please tell me the last version they had this feature? I might have a look at it.

[Kuaffu]

You can try Mondrian 4.7, which had the hasHierarchy feature. If you want to compile it locally, the latest repository is hosted at this URL. Unfortunately, access to the repository currently requires authentication.

[xiaobao520123]

@Kuaffu Thank you for providing evidence. Fortunately, I've found something very interesting in the latest master version.
Permalink:

mondrian/mondrian/src/main/resources/mondrian.xsd

Line 419 in 9c408db

<xs:attribute name="origin" type="xs:unsignedShort"> <!-- New --> <!-- TODO check what this is... what values should be settable. type inferred from mondrian.xmla.RowsetDefinition class. -->

When I set this 'origin' attribute to 6, hierarchies will be presented exactly as AttributeHierarchy, accroding to Microsoft OLE DB documentation.

Interestingly, developers from Mondrian don't even know what this attribute 'origin' is. But that's actually what I've been looking for.