Need a special offer?Find out if your project fits.
+

Mondrian - Dimension with closure not work

Answered
Gabriel Ribeiro asked on August 12, 2019

Hello,
I am testing the foodmart example on modrian4 and HR cube. The employees dimension is set to and parentColumn and closure but the hierarchy is not showing. 

 

I am testing version 2.7.11

Attachments:
print2.png

5 answers

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster August 13, 2019

Hello Gabriel,
Thank you for writing to us.
 
The parent-child relationship is not supported for Mondrian data source. 
We recommend reconsidering Mondrian schema structure.
 
 
Please let us know in case of any other question.
Regards,
Dmytro
 

Public
Gabriel Ribeiro August 15, 2019

Thanks for the answer.
I reconsidered the structure of my scheme and managed to get the desired result.
There are some details that I couldn't solve: when I have a level set with the hideMemberIf = "IfBlankName" property flexmonster still continues to display the hierarchy link even though it has no more levels. Would it be possible to solve using customizeCell?
In the attached print all marked items have no value hierarchy.

Attachments:
print1.png

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster August 16, 2019

Hello Gabriel,
Thank you for writing.
 
We are glad that you managed to find a workaround for your case.
As for unavailable levels, yes, it is possible to remove the drill-down buttons with customizeCell.
The only thing that you will need to explicitly define the levels which do not have children levels.
 
Please let us know in case you need any other assistance.
Regards,
Dmytro

Public
Gabriel Ribeiro August 16, 2019

I managed to solve. Follow the code if anyone needs it too.
Thank's

function customizeCellFunction(cell, data) {
if (flexmonster.getReport()["dataSource"]["dataSourceType"] === "mondrian") {
if (data.member) {
flexmonster.getMembers(data.member.hierarchyName, data.member.uniqueName, function (member) {
if (member.length === 0) {
cell.text = cell.text.replace(/<span class="fm-hierarchy-link" [\s\S]*?<\/span>/, '');
}
})
}
}
}
Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster August 16, 2019

Hello Gabriel,
We are glad you have managed to resolve it.
Thank you for sharing your experience.
Please let us know if you have any other question.
Regards,
Dmytro

Please login or Register to Submit Answer