empty view as data source for TI

[ioscat]

Hello, forum.

If TI get an empty view as data source (for example if all subset elements were deleted or subset was cleaned), it will break with following error

Code: Select all

Error: Prolog procedure line (0): Unable to open data source "<CUBENAME>".

I suppose this behaviour is logic enough, not a bug. But is it documented somewhere or discussed before? I tried to search the exact error sentence with other keywords, but didn't get anything. So if empty view is not restricted to be used as data source so why is it not a bug?

[jim wood]

This is probably the kind of thing that IBM thought "Why would anybody use an empty view as a data source?" The fact that it does give an error kind of tells us it's doing what it supposed to do. As for documenting it, I'm not sure IBM document every error possible, especially those that stem from something that doesn't make sense anyway.

[declanr]

This is why I try to never have a hard set datasource on anything that could change.

I tend to set my datasource in the prolog tab, that way you can use an IF statement to exit the process and output a comment explaining why it was exited such as "Process terminated due to Subset X returning no elements"... or whatever else you define as the parameters of your exit conditions. If its a view that should be your datasource you can loop through all dimension subsets of the view (easily done if you also create all of them in the prolog with the Process Name as the subset name) and determine whether the view is "valid" or not.