asked on December 8, 2022
Hello,
We have a genarated cube.
We encountered the following problem.
As you can see in the attached picture, some dimensions are labeled 'blank'. We checked the same cube with Microsoft Sql Server Manager Studio. The same dimensions are displayed correctly.
We checked the callbacks and we see that the captions are empty for these fields.
Where do we start looking for the cause of the error?
Thanks for your help
⋅ December 8, 2022
Hello, György!
Thank you for reaching out to us.
Our team hasn't managed to reproduce the described behavior on our sample cube. Could you please provide us with your sample cube in .abf format, so we'll be able to continue the investigation?
We are also wondering if you are using Flexmonster Accelerator or XMLA to connect to the cube. This information would help us greatly.
Kindly note that you can send any sensitive information to our inbox.
Looking forward to hearing from you.
Regards,
Solomiia
⋅ December 14, 2022
Hello, Solomiia!
Thank you for the quick reaction.
We found the cause of the error. We analyzed the server log and found that sometimes the returned value does not have a value for 'HIERARCHY_CAPTION'. In such a case, is it possible for the fallback value to be 'HIERARCHY_NAME'?
Regards,
Gyuri
⋅ December 15, 2022
Hello, György!
Thank you for getting back to us.
Kindly note that Flexmonster needs the HIERARCHY_CAPTION property to show the fields' captions.
As a possible workaround, we suggest overriding blank captions on the client side using our mapping property:
dataSource: {
type: "microsoft analysis services",
proxyUrl: ...,
catalog: ...,
cube: ...,
binary: true,
mapping: {
"[Rig].[Shipyard]": {
caption: "Shipyard"
}
}
},
We have prepared a JSFiddle example for reference: https://jsfiddle.net/flexmonster/d5ygw4km/.
Please let us know if the suggested approach works for your case.
Regards,
Solomiia
⋅ December 27, 2022
Hello, György!
Hope you are doing well.
Our team is wondering if you had a chance to try overriding blank captions using mapping. Could you please let us know if it works for your case?
Looking forward to your response.
Kind regards,
Solomiia
⋅ January 3, 2023
Hello, György!
Hope you are having a great week.
Just checking in to ask if overriding blank captions using mapping works for your case.
Looking forward to hearing your feedback.
Regards,
Solomiia
⋅ January 11, 2023
Hi Solomiia,
We managed to solve the problem with the solution you suggested.
Thanks for the help.
Regards
György
⋅ January 11, 2023
Hello, György!
Thank you for your feedback.
We are glad to hear that the mapping approach was helpful.
Feel free to contact us in case of any other questions.
Kind regards,
Solomiia