ViewCreateByMDX - Erring on creation of empty view

[Steve Rowe]

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.

[Steve Rowe]

You'd think I would use the search button...

Just cross linking for anyone who finds this post and not the other one

https://www.tm1forum.com/viewtopic.php? ... set#p73290

thanks Lotsaram

Also there is an APAR associated with this

https://www.ibm.com/support/pages/apar/PH16537