A good question and that was/is indeed the problem. I am unable to register a VIEW based on a WORK table in the metadata.
1. If I use EG 4.2 via Tools -> Update Library Metadata I get the error
"No metadata objects found matching the specified URI".
Odly, one of the three Views is registered and ready to use. (strange)
2. If I use SAS OLAP Cube Studio -> Register tables and select the tables
that are part of the library, I get the error "WORK.MygreatView.DATA does not exists."
The table is then registered without any variables or data.
Note, this all works fine if I register VIEWS that do --not-- select from the WORK library but as soon as the view select from the WORK library the whole thing causes problems.
Why I use the WORK library? - I want to create prompt source tables that are filled depending on the user login (dynamic PROC SQL - identity driver properties) by a STP that executes as soon as the web report opens.