Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have written a visual studio (VB.NET) app to extract all master dimensions and measures from a select QS App. I then created a set of default Master Dimensions and Measures that can be applied based on field names to any selected App.
My problem is that when you add a master dimension that is an expression e.g. If(Approved = 1, 'Yes', 'No') the QS engine adds square brackets which causes the expression to fail. I tried quite a while thinking there was something I was adding in the text list in visual studio however when I extract the master items having created my own, the expression does not have square brackets around it.
Is there something I am missing an indicator etc. when I create the dimension?
Thank you in advance
Patrick
You probably need to add the character '=' in front of the expression. That indicates to the engine that this is a calculated dimension and not a field reference.
You probably need to add the character '=' in front of the expression. That indicates to the engine that this is a calculated dimension and not a field reference.
Thank you so much worked immediately, just need to identify for myself now wether it's purely a field or a calculated dimension which is easy.
Really appreciate your prompt response