I was trying to access the properties of Dimension in my MDX schema, but the way it is mentioned in the Mondrian documentation was not working in 3.5.8 version. Then we got in trouble and wasted lot of time in figuring out that, how to access properties in Mondrian.
Here is how it worked for me
SELECT
{[Measures].[Total Sales Count]} ON COLUMNS,
[Store].[Store Id].MEMBERS DIMENSION PROPERTIES [Store].[Store Id].[Name] ON ROWS
FROM [Sales]
Where [Name] is the property of the level [Store Id]
Hope if you are searching for this, it may help you.
Here is how it worked for me
SELECT
{[Measures].[Total Sales Count]} ON COLUMNS,
[Store].[Store Id].MEMBERS DIMENSION PROPERTIES [Store].[Store Id].[Name] ON ROWS
FROM [Sales]
Where [Name] is the property of the level [Store Id]
Hope if you are searching for this, it may help you.
Hi ... Thanks for your post. I use the key word you said, that is, DIMENSION PROPERTIES, but I have no result from mondrian (using pentaho cde 5.2 with mondrian 3.8 and jpivot view)...
ReplyDeleteAre you sure DIMENSION PROPERTIES is supported by Mondrian ?? I'm lloing for a way to grouping by level properties.
Some links of interest:
http://diethardsteiner.github.io/mondrian/2014/12/29/OLAP-Properties.html
http://diethardsteiner.github.io/mondrian/2014/12/26/Bridge-And-Closure-Table.html
How should it be the cardinality between the member and the property .. (for example, is correct to say that the level Day with member 1,2,3 .... 31 have a property of day name like "Monday", "Tuesday"?? I would like to grouo by this property, if right).
bonus veren siteler
ReplyDeletebetmatik
mobil ödeme bahis
betpark
tipobet
kralbet
kibris bahis siteleri
poker siteleri
slot siteleri
EJ6WHM
Dont waste time on that my friend. I realized much time ago that custom dimesion/member properties are not supported.
ReplyDeleteJust tryto buld several hierarchies to achieve your needs.
Regards