ViewCreateByMDX - Erring on creation of empty view
Posted: Fri Apr 24, 2020 2:58 pm
Hi,
This function appears to suffer from the same issue as the subset function in that it errors if the MDX does not return any values.
This seems like very dumb behaviour (though I'll no doubt be told its by design and to raise a RFE..).
I've been fiddling around with creating a union of my real query with a tuple that I know will return a cell but this adds a lot of downstream complexity in getting that record ignored when I do get results.
Anyone hit this already and have something more elegant?
Cheers.
This function appears to suffer from the same issue as the subset function in that it errors if the MDX does not return any values.
This seems like very dumb behaviour (though I'll no doubt be told its by design and to raise a RFE..).
I've been fiddling around with creating a union of my real query with a tuple that I know will return a cell but this adds a lot of downstream complexity in getting that record ignored when I do get results.
Anyone hit this already and have something more elegant?
Cheers.