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
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
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.
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
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>/, '');
}
})
}
}
}
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