Hello,
I am trying to create a report with a custom date hierarchy: Year/Month/Week.
For my measures, I use the following definition (other fields omitted):
'claimObject.date_mission.y': {type: 'level', caption: 'Year', hierarchy: 'Mission Date', level: 'Year'},
'claimObject.date_mission.m': {type: 'level', caption: 'Month', hierarchy: 'Mission Date', level: 'Month', parent: 'Year'},
'claimObject.date_mission.w': {type: 'level', caption: 'Week', hierarchy: 'Mission Date', level: 'Week', parent: 'Month'}
then in slice (other fields omitted):
columns: [
{
uniqueName: 'Mission Date',
levelName: 'Month',
filter: {members: ['year.[2017]']}
},
{uniqueName: '[Measures]'}
],
drills: {
columns: [
{tuple: ['year.[2017].[january]']}
]
}
Everything works as expected except that the report is not opened with January drilled down. If I drill manually, it
works except that the produced report contains (same column repeated twice):
drills: {
columns: [
{tuple: ['year.[2017].[january]']},
{tuple: ['year.[2017].[january]']}
]
}
If I click on the week drill down of February, it drills correctly and the report is now (as expected):
drills: {
columns: [
{tuple: ['year.[2017].[january]']},
{tuple: ['year.[2017].[february]']}
]
}
Sadly, using this slice configuration to open a new Flexmonster does not perform any drill. I suspect I am misusing hierarchies.
What is the correct way of working with such a hierarchy ?
Hello Julien,
Thank you for reporting.
We have prepared a sample how to overcome this limitation - http://jsfiddle.net/flexmonster/wkL7et18/
As you can see, the key point is to specify drilled year in tuples as well:
"drills": {
"columns": [
{ "tuple": [ "year.[2017]" ] },
{ "tuple": [ "year.[2017].[jan]" ] }
]
}
Still, it looks like an issue and we will fix it in our future updates.
Please let me know if it works for you.
Regards,
Ian
Thanks a lot Ian, it works perfectly.
Hello Julien,
We are glad to inform that the version 2.412 with the fix has already been released.
You are welcome to download it from our website.
Regards,
Dmytro.