asked on September 23, 2025
We are using Flexmonster with MS Analysis services and the Accelerator. When setting the report configuration manually, we use the below, see that the column hierarchy is year-quarter-month including year and quarter, however we don't see the year in the resulting cube (see screenshot in the attachment). What is wrong here? We can see correctly the cube in Excel, with year/quarter dimensions, so the problem is not with Analysis Services.
{
"rows": [
{
"uniqueName": "[Customer Segments].[Segment]",
"levelName": "[Customer Segments].[Segment]"
},
{
"uniqueName": "[Branches].[Bank Hierarchy]",
"levelName": "[Branches].[Bank Hierarchy].[Branch]"
}
],
"columns": [
{
"uniqueName": "[Dates].[Year-Quarter-Month]",
"levelName": "[Dates].[Year-Quarter-Month].[Year]"
},
{
"uniqueName": "[Dates].[Year-Quarter-Month]",
"levelName": "[Dates].[Year-Quarter-Month].[Quarter]"
}
],
"measures": [
{
"uniqueName": "[Measures].[Balance]"
}
]
⋅ September 25, 2025
Hello, Pablo!
Thank you for reaching out to us.
Kindly note that to set the hierarchy starting with a specific level, it is enough to specify it once in the slice. So, you need to leave the following field in columns:
"columns": [
{
"uniqueName": "[Dates].[Year-Quarter-Month]",
"levelName": "[Dates].[Year-Quarter-Month].[Year]"
}
]
Then, remove the next field with "levelName": "[Dates].[Year-Quarter-Month].[Quarter]" as it is overriding the previous configuration for the [Dates].[Year-Quarter-Month] field.
Here is the JSFiddle to illustrate the idea: https://jsfiddle.net/flexmonster/qLnzsoje/.
Hope it helps.
Kind regards,
Solomiia
⋅ September 26, 2025
It worked, thank you!
⋅ September 29, 2025
Hello, Pablo!
Thank you for your feedback.
We are happy to hear everything works well now.
Feel free to reach out to us in case of any other questions.
Kind regards,
Solomiia
